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)
modernized sp_helpindex with info on post S2K features
2018-10-29 (first published: 2018-10-19)
Script to build PIVOT queries with an arbitrary number of columns
2018-10-25 (first published: 2018-10-15)
extensions to sp_spaceused
2018-10-24 (first published: 2018-10-15)
Create the code to detect and repair non trusted foreign keys
2018-10-23 (first published: 2018-09-27)
obtain server roles and permissions by login
2018-10-12 (first published: 2018-10-04)
How to identify backup tables within production databases that can be removed.
2018-10-05 (first published: 2018-09-28)
Get the number of rows, columns, and space used by all tables in all databases
2018-10-03 (first published: 2018-09-20)