Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

The best things in life are free

Greg Gonzalez (blog | twitter) of SqlSentry, last night released a very cool new and free product.  Plan explorer is a tool for examining query plans and overcomes many of the limitations of viewing plans within Management studio.  If you view plans a lot i would recommend that you give it a try.

This is by no means the only free product available for SqlServer,  in no particular order here are some others that I use on a regular (and not so regular) basis.

Mladen Prajdic  (blog | twitter)  has produced the wonderful SSMS ToolPack which extends the functionality of management studio and can be a real life saver.

For large trace files , being able to see the wood for the trees, can be hard.  ClearTrace normalizes a trace file to help you analyse the the calls to procedures and adhoc statements.

Codeplex is a Microsoft site where anyone can release software.  Some of these are by Microsoft support staff to aid them with their roles and although not fully supported are still well worth a look at.  Notable packages are

One other Microsoft package that you should look at are Performance Dashboard reports.

Another company who is heavily involved in the SqlServer community is Red Gate.  They have a free SQLSearch tool which is a SSMS plugin to aid text searching through procedures , triggers , table structures etc.  As well as producing tools they also have a number of other resources available to download.  To pick just three , Defensive Database programming by Alex Kuznetsov (blog|twitter), SqlServer Execution plans by Grant Fritchey (blog|twitter) and the DMV Starter Pack

If you need to find all the Sqlserver installs at your site, Quest Software have Discovery Wizard for Sql Server currently available as free beta release.

Before releasing software live , its always wise to test the scalability.  To that end, you may want to use Adam Machanic’s (blog|twitter) Sql Query Stress tool.  Also from Adam is his WhoIsActive ? script.  Other scripts which I find useful are Michelle Ufford’s (blog|twitter)Index Defrag and Brent Ozar’s(blog|twitter) Blitz Script for when you have just been handed a server you knew nothing about.

Finally get involved in Twitter,  its a fabulous resource with many of the best SqlServer professionals regularly using it.  Brent has a simple all you need to know about twitter guide here.

Disclaimer : This is all for information only, I cannot be held responsible if any tool does not operate as expected.

Comments

Posted by Jason Brimhall on 21 October 2010

Great stuff - thanks for sharing.  I think I will download and play with it now.

Posted by Dukagjin Maloku on 22 October 2010

Thanks for group sharing things here!

Posted by TheSQLGuru on 22 October 2010

Ola.hallengren.com has an AMAZING free, flexible and DOCUMENTED suite of maintenance scripts - by far the best out there IMNSHO!

Posted by Anonymous on 22 October 2010

Pingback from  @davebally posts SQL Server Central | The best things in life are free | sqlmashup

Posted by Anonymous on 26 October 2010

Recently Dave Ballantyne posted a list of free resources for SQL Server, entitled " The best things in

Posted by Anonymous on 18 March 2011

Pingback from  Database Tools Follow-up | SQL RNNR

Leave a Comment

Please register or log in to leave a comment.