It’s been a while since I’ve posted on a T-SQL Tuesday topic and glad to see the topic being discussed by Mike Bronowski (blog) on tools.
Throughout my career, I’ve worked for companies that have allowed me to utilize some pretty nice tools. Whether they are vendor or community-related there are a plethora of options for all platforms and prices.
Some of the ones that I have a special place for can be found here, but I’ll specifically name a few below:
Maintenance / Performance Tools
- SSMS Boost
- sp_Blitz (Brent Ozar’s exploratory script on servers – highly recommend it)
- sp_BlitzIndex (Kendra Little’s Index Sanity Test)
- sp_Blitz App
- Glenn Berry’s Diagnostic Queries
Red Gate Tools
SQL Sentry Tools
One thing outside of the above I like to look at periodically are mentors. These morph over time and have a unique ebb and flow about them based on where you are at in your life, career, or journey. Solidifying some good mentors can become just as valuable an asset as a physical tool in your toolbelt.
Thank you, Mike for hosting this month!
What is T-SQL Tuesday
If you want to learn the what, when, how or why to T-SQL Tuesday you can click here for more information.