How do you manage 1000 SQL Servers without clicking through each one? Here is the script I use to change service account for all instances with WMI and SMO.
SQL SERVER – Starting / Stopping SQL Server Agent Services using PowerShell
Stop clicking through SSMS on every server. Here is how to start and stop SQL Server Agent services on many servers using PowerShell.
SQL SERVER – Working with Event Viewer and PowerShell
A DBA on Windows Server Core had no UI to read logs. Here is how to work with Event Viewer and PowerShell to read the events you need.
SQL SERVER – PowerShell – Knowing SQL Server Information
A PowerShell script that reads SQL Server information from my localhost using SMO and writes it to a simple HTML page you can open in any browser.
PowerShell: How to Find Logical and Physical Processors on SQL Server?
With core based licensing, a DBA friend asked how to count cores. Here is a PowerShell script using WMI to find logical and physical processors on SQL Server.
SQL SERVER – PowerShell to Count Number of VLFs in SQL Server
Too many VLFs can hurt performance. Here is a simple PowerShell script that counts the VLFs in every database on one or many SQL Server instances.
SQL SERVER – Using PowerShell and Native Client to run queries in SQL Server
A friend wanted PowerShell and Native Client, not SQL PowerShell, to run queries against SQL Server. Here is the small sample script I wrote for it.