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)
1,086 reads
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)
369 reads
The below script will build a csv file for import of the servers Power Plan Setting.
2018-11-06 (first published: 2018-10-19)
436 reads
This script trigger will help you to accidental DB drop/delete
2018-11-05 (first published: 2018-10-22)
816 reads
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)
2,353 reads
modernized sp_helpindex with info on post S2K features
2018-10-29 (first published: 2018-10-19)
1,004 reads
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
956 reads
extensions to sp_spaceused
2018-10-24 (first published: 2018-10-15)
833 reads
obtain server roles and permissions by login
2018-10-12 (first published: 2018-10-04)
975 reads
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
516 reads