Here is a situation I just came across (boiled down and simplified). An end user…
Month: August 2016
TSQL – Get All Queries Currently Running
This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in…
Powershell
Continue Reading

PowerShell – Update All SQL Services To Restart On Failure
PowerShell script to quickly change all Recovery Options to “Restart the Service”. https://gist.github.com/benf101/a3c7020c0a582aca06059b750bd08528
PowerShell – Create And Write Out To Log File
Creating and writing to output file in PowerShell. https://gist.github.com/benf101/379e8040393a24771af81360ee0111ab