Free Tools for SQL Server Professionals

Free Tools Recommendations from Leaders in the SQL Server Community

This fall at the Dev/IT Connections Conference in Las Vegas I moderated a panel of speakers taking part in the SQL Server track and the question arose around our favorite free tools for SQL Server. Since you all could not be at the conference it seemed like a valuable topic to share here. Many of us shared the same favorites or had those “Ah Ha!” moments when someone brought up a great free application or set of scripts.  We didn't take good notes during the panel discussion so I reached out to the panelists after the fact via email and included their responses here.

I’ll take advantage of my position as the author here to include a few more along the way that didn’t end up getting mentioned that I think are also worth a look… because I can.

On Just About Everyone's List

The tools that seemed to be on the lists of those specializing in database administration were from Adam Machanic (sp_whoisactive), Ola Hallengren (SQL Server Maintenance Solution) and SQL Sentry (SQL Server Plan Explorer): 

Additional DBA-Centric Free Tools

Grant Fritchey also reminded us that Ola Hallengren has competition on the index maintenance free scripting front, in particular from Michelle Ufford (download her Index Defrag Script here.)  I can attest that her scripts definitely do the trick having used them over the years before moving to Ola’s when incorporating backups and DBCC CHECKDB when I backed off of the “rolling my own solution for maintenance” roller coaster. Grant, always the master of getting right to the point commented:

To be fair Grant also suggested that there were a variety of free tools that his employer, Red Gate Software, provides to the SQL Community as well but he didn't want to throw bias into the mix.  I'll happily do so though as I do believe that my first foray into the "Free SQL Tools" environment came from use of their SQL Prettifier that was around back in the early stages of my accidental DBA days and is still around to this day.  Red Gate has quite an assortment of free tools for the DBA and developer alike.  They can all be accessed here.

One tool that came up that I was unaware of on the DBA side of SQL was this suggestion from Jes Borland

Allen White, ever the lover of Powershell of course brought that platform into play with his suggestion for Kendal Vandyke’s SQL PowerDoc:

 David Klee joined us this year at DEV/IT Connections and if you’re not aware of the name you should be - particularly if you’re virtualizing your SQL environments using VMWare. Aside from being a voice of authority in the SQL Server space when it comes to storage and performance; he’s also a VMWare vEXPERT. He’ll be joining many of the people cited in this article aboard the Caribbean SQL Cruise in February as well. David takes the angle of discussing a free tool hooked into analyzing IO:

Business Intelligence-Related Free Tools Options

It’s convenient being in charge of selecting the speakers for the Connections Conferences’ SQL Server track because I can ensure that all aspects of SQL Server are covered. While I’m familiar with most free tools offerings on the DBA and Developer side of the equation I don’t have that familiarity in the BI and BA space. Thankfully we had representation in the panel for those topics from Rafael Salas and Tim Mitchell.

The Free Gifts That Keep on Giving

I think it's absolutely fantastic that so many share their knowledge with this community and that so many companies provide free tools with no strings attached.  It's one of the things that sets the #SQLFamily appart from other technical groups. 

In the United States we're about to celebrate Thanksgiving - a day set aside to give thanks for what we've been given and have achieved in life.  I'd like to say that among other things I'm thankful for all those who take time out of their lives to share with their peers.  You elevate us all with your contributions.  No matter where you are when you're reading this and whether you celebrate Thanksgiving in your area of the world or not I hope you too have much to be thankful for this year and all the years to come.