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,131 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)
523 reads
This script trigger will help you to accidental DB drop/delete
2018-11-05 (first published: 2018-10-22)
860 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,843 reads
modernized sp_helpindex with info on post S2K features
2018-10-29 (first published: 2018-10-19)
1,335 reads
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
986 reads
extensions to sp_spaceused
2018-10-24 (first published: 2018-10-15)
889 reads
obtain server roles and permissions by login
2018-10-12 (first published: 2018-10-04)
1,116 reads
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
551 reads
Get the number of rows, columns, and space used by all tables in all databases
2018-10-03 (first published: 2018-09-20)
493 reads