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 …
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 …
dbachecks commands
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. As of version v1.0, dbachecks contains 15 commands. This article provides an overview …
Installing dbachecks
dbachecks is a new open source module that allows the SQL Server community to crowdsource our checklists and easily test our environments 🤗 You can read more about it in …
introducing dbachecks – a new module from the dbatools team!
In mid-December, we began working on a new PowerShell module for the SQL Server Community. This free and open-source project can be found in the SQL Server Community Collaborative’s repository. …