{"id":54,"date":"2013-11-13T00:00:00","date_gmt":"2013-01-01T00:00:00","guid":{"rendered":"https:\/\/www.sqlhammer.com\/blog\/ten-free-sql-server-tools-that-you-need-to-know-about"},"modified":"2026-03-18T21:50:44","modified_gmt":"2026-03-18T21:50:44","slug":"ten-free-sql-server-tools-that-you-need-to-know-about","status":"publish","type":"post","link":"https:\/\/sqlhammer.com\/index.php\/2013\/11\/13\/ten-free-sql-server-tools-that-you-need-to-know-about\/","title":{"rendered":"Quick Links:"},"content":{"rendered":"<p>Hello, I\u2019m happy to see that the buzz word \u201cFree\u201d did not fail to attract readers. NEVER FEAR! You will not leave this post disappointed.<\/p>\n<p>I\u2019m not going to try and do a better job than <a href=\"http:\/\/www.johnsansom.com\/\">John Sansom<\/a> has already done but I felt that this information needed to be widely distributed.<\/p>\n<p>On that note, I <strong>highly<\/strong> encourage you to check out his article <a href=\"http:\/\/www.johnsansom.com\/top-10-free-sql-server-tools\/\">here <\/a>and learn about the great\u00a0<strong>free<\/strong> tools available to us all.<\/p>\n<h1>Quick Links:<\/h1>\n<ul>\n<li><a href=\"http:\/\/www.sqlsentry.net\/plan-explorer\/sql-server-query-view.asp\">Plan Explorer<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/www.brentozar.com\/blitz\/\">sp_Blitz<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/www.brentozar.com\/blitzindex\/\">sp_BlitzIndex<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/sqlblog.com\/blogs\/adam_machanic\/archive\/2012\/03\/22\/released-who-is-active-v11-11.aspx\">sp_WhoIsActive<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dd939169(v=sql.100\">Management Data Warehouse (MDW)<\/a>.aspx)<\/li>\n<\/ul>\n<p>See one possible problem if this feature is over loaded in my <a href=\"http:\/\/feedproxy.google.com\/~r\/SqlHammer\/~3\/aHwHCcUqGho\/\">post here<\/a>.<\/p>\n<ul>\n<li><a href=\"http:\/\/sqlfool.com\/2011\/06\/index-defrag-script-v4-1\/\">Index Defrag Script 4.1<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/ssce.codeplex.com\/\">Compression Estimator<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/bb895144.aspx\">Central Management Server<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/www.scalesql.com\/cleartrace\/default.aspx\">ClearTrace<\/a><\/li>\n<\/ul>\n<ul>\n<li><a href=\"http:\/\/sqlserverperformance.wordpress.com\/2012\/07\/08\/sql-server-2012-diagnostic-information-queries-july-2012\/\">SQL Server 2012 Diagnostic Information Queries<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Hello, I\u2019m happy to see that the buzz word \u201cFree\u201d did not fail to attract readers. NEVER FEAR! You will not leave this post disappointed. I\u2019m not going to try and do a better job than John Sansom has already done but I felt that this information needed to be widely distributed. On that note, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":1,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":317,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/54\/revisions\/317"}],"wp:attachment":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}