As I keep forgetting to download or store these beautifully helpful procs in one place, I thought it best to create a blog post on it!

In no particular order:

Ola Hallengrens Maintenance scripts
The sp_Blitz, sp_blitzCache sp_blitzIndex from the Brent Ozar team
Glenn Berry’s DMV Queries (I know there not procs, but i use them al lthe time so had to add um!
sqlstudent’s handy Permissions stored procs
sp_WhoIsActive Adam Machanic beasty upgrade to sp_who
Jason Strates Index Analysis
Kimberly Tripps sp_helpindex
Minion by the Midnight DBA’s
Jonathan Kehayias proc to turn Traces into Extended events