decreasing module import times
SQL Server Operations Studio by Microsoft is like SSMS for ops, all open source and published on GitHub! They recently updated their wiki’s Performance page, addressing why SQL Operations Studio …
blog
three ways to track logins using dbatools
Years ago, I wrote Watch-DbaDbLogin which keeps an inventory of accounts, hosts and programs that log into a SQL Server. It was pretty crude, but helped immensely during my migration, …
Minimal-downtime migrations using Invoke-DbaLogShipping
Last week I performed a server migration from SQL Server 2014 to SQL Server 2016 using dbatools. A lot of work is done up front to prepare and plan for …
Rob Sewell talks about dbatools on RunAs Radio
Back around the time we did SQL Bits, Rob Sewell spoke to Richard Campbell at RunAs Radio. The show, Managing SQL Server using dbatools with Rob Sewell, is a fun …
happy belated world backup day
Happy Belated World Backup Day! I wish it was Backup and Restore Day, Test Your Backups Day, or World Recoverability Day, but alas. I’m currently working on my portion of …
a new command to find all of your sql instances
Nearly every time I inherit a SQL Server environment, I’m only given a partial list of SQL Servers that exist on the network. It’s my usual routine to get permission …
migrating application databases with dbatools
I’ve been working on a project this year to upgrade SQL Server versions for around 80 application databases, with most of the upgrades requiring both SQL Server and Windows Server …
submitting an issue
An Issue Defined In software development, an “issue” can be anything from you hit an error running an application or you get an unexpected result from an operation. You can …
dbatools is now MIT licensed!
Nearly two years ago, I wrote that as a open source GPL-licensed project, dbatools was free as in speech and free as in beer. I chose the GNU GPL for …
simplifying extended events management with dbatools
Gianluca Sartori and I recently presented Simplifying Extended Events with dbatools at SQL Bits and we had a lot of fun. Not only that, we helped convince several people to …