Disks are often behind a slow server, and the problem can be hard to spot. Here is a PowerShell script to identify Disk Latency on your SQL Server box.
SQL SERVER – PowerShell Script – When Was SQL Server Last Restarted?
A simple PowerShell script that reads the ErrorLog to answer a common question: when was SQL Server last restarted? Tips to improve it are welcome.
SQL SERVER – FIX – The term ‘Invoke-Sqlcmd’ is not recognized as the name of a cmdlet
My weekend PowerShell learning hit an error: the term Invoke-Sqlcmd is not recognized as the name of a cmdlet. Here is why it happened and the fix.
SQL SERVER – PowerShell way of Restarting SQL Server Service
Restarting SQL Server service with PowerShell is one line, and it is wrong on a named instance. The right name, -Force, and when it is really up.
SQL SERVER – Start Services or Stop Services with PowerShell – Answer to Question
You can check out the original post here: SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?.
SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?
A reader asks why you need the -Force flag to stop services with PowerShell but not to start them. I do not know the answer, so I am asking you.
Automating SQL Server Patching With PowerShell
Automating SQL Server Patching with PowerShell means staging a verified package, running Setup quietly, checking logs, and stopping on failure.