Stored procedure to update SSRS Subscription owners to avoid email errors.  Read more...

1100 largest indexes by total buffer cache usage; 100 largest tables by total reserved pages; Largest tables in each database with running total of space usage and growth since last snapshot  Read more...

This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for :)  Read more...

Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.  Read more...