Patching Multiple SQL Servers With Powershell and dbatools
Patching SQL Server can sometimes be a time consuming process, especially when you have multiple servers that need to be patched. Remoting in to each box to run through the …
Using dbatools PowerShell Module To Set MAXDOP And Max Memory
As I continue my blog series on using the dbatools PowerShell module, today I want to discuss using it to set MAXDOP and Max Memory on your SQL Server. This builds directly …
Using dbatools PowerShell Module To Configure SQL Server
The more I use the dbatools PowerShell module, the more I like it. It really is a solid set of scripts that allow you to easily manage your SQL Servers via PowerShell. …
Getting Started With The dbatools PowerShell Module
If you are looking for a super easy way to start using PowerShell to manage your SQL Servers, then the dbatools PowerShell module is for you! For those that aren’t familiar, …
Notes From A SQL 2017 Azure Install – Automatic Seeding Of An Availability Group TDE Database
One of the neat features introduced with SQL Server 2016 was the automatic seeding of availability groups. And while it seems to work pretty well in most cases, if you …
Call Multiple SQL Jobs In Sequence Via PowerShell
Recently I had an issue come up where I needed to run about 15 SQL Agent Jobs in a specific order, bouncing back and forth across multiple SQL Servers, ensuring …