2016-08-04
TSQL – Make Excel Link In Output
Here is a situation I just came across (boiled down and simplified). An end user was...
August 2016
2016-08-04
TSQL – Get All Queries Currently Running
This is perhaps my most commonly used query when troubleshooting. From SQL Server DMV’s in action...
2016-08-04
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
2016-08-04
PowerShell – Create And Write Out To Log File
Creating and writing to output file in PowerShell.