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
extensions to sp_spaceused
2018-10-24 (first published: 2018-10-15)
Create the code to detect and repair non trusted foreign keys
obtain server roles and permissions by login
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)
Script to stop the default Data Collection sets, clear the cache files and then restart collection sets.
2018-10-02 (first published: 2018-09-25)
Order records based on a different column depending on which absolute value is greater.