A TVF to select prime numbers
2018-11-30 (first published: 2017-04-01)
Starting from a string, it returns values embedded in delimiters.
2018-11-29 (first published: 2018-11-23)
I use this script to create data dictionaries.
2018-11-15 (first published: 2018-11-08)
If you have a SQL Server with a High Availability solution (AlwaysOn Availability Groups, Database Mirroring, etc.), and you also have a bunch of jobs which you need to be run on the Primary server only. You need to be able to "failover" the jobs in case the Primary server is no longer Primary.
2018-11-14 (first published: 2018-11-12)
Find a string in a stored procedure and replace with powershell
2018-11-13 (first published: 2018-11-06)
I was using this script to check disk space on individual servers for quite some time. And now since I started to use registered servers for MS SQL, I thought of a little modification to the script.
2018-11-09 (first published: 2018-10-24)
Some times you need to parse over punch values at the while running a query.
Here is an utility function to help with that task.
2018-11-07 (first published: 2018-10-31)
The below script will build a csv file for import of the servers Power Plan Setting.
2018-11-06 (first published: 2018-10-19)
This script trigger will help you to accidental DB drop/delete
2018-11-05 (first published: 2018-10-22)
Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z.
*Dont you just love totally non subjective assessments like this?
2018-11-01 (first published: 2018-10-22)