SQL Server: Disable/Remove Indexes Across Servers/Databases Using PowerShell & dbatools

This is something I had to do today. In this blog post, I am going to show you how you can disable or remove indexes matching certain name criteria or other condition(s) across multiple servers and databases in various tables. Usually, this is a very painful process if done by hand but with the fantastic …

Advertisement

PowerShell: Invoke-RDPLogoff – Logoff From Windows Servers In Parallel

Recently, I changed my Windows password and that started a chain of events. My account would get locked out because an invalid password was used and I started getting weird errors in various programs when using the account even after getting it unlocked several times. Restarting my own PC did not help. Then, it occurred …

PowerShell & SQL Server: Run In Parallel – Collect SQL Results With PRINT Output From Across Your SQL Farm – Fast!

If you have been working with PowerShell and SQL Server for a while now, you know that it is not difficult to capture the PRINT statement output as VERBOSE output (which can then be redirected to a variable or file). You also know that it is not too difficult to run SQL in parallel against …

Using PowerShell – Add user or group to local Administrators group in Windows + Create SQL Server Login

I cannot imagine a life without PowerShell now. You would agreee after you find out why. This is what I had to do today. The very real problem: I have a list of about 30 servers. I need to add an AD group name to the local adminstrators group on all 30 servers Create a …