Aaron Bertrand : Some new free tools enter the SQL marketplace

"Useful, free resources for SQL Server"

company's commercial tools will now be free. You can now download any of the following products at atlantis-interactive.co.uk:

• SQL Everywhere
• Schema Inspector
• Data Inspector
• Data Space Analyser
• Data Surf
• Schema Surf

Qure Workload Analyzer ("QWA")

Fellow SQL Server MVP Ami Levin at DBSophic (twitter)
http://www.dbsophic.com/qure-workload-analyzer/

SQL Server 2005 Upgrade Advisor

SQL Server 2005 Best Practices Analyzer

SQL Server 2008 Upgrade Advisor - download x64 - download x86

SQL Server 2008 R2 Upgrade Advisor - download x64 - download x86

SQL Server 2008 R2 Best Practices Analyzer - download x64 - download x86

(For some advice about the R2 BPA install, see this post from August)

Mladen Prajdic's SSMS Tools Pack:
http://ssmstoolspack.com/

Sean Price's Snapshot add-in:
http://sqlblogcasts.com/blogs/seanprice/archive/2007/07/15/sql-management-studio-snapshot-add-in.aspx

Jonathan Kehayias' Extended Events Manager:
http://extendedeventmanager.codeplex.com/

RedGate SQL Search
http://www.red-gate.com/products/SQL_Search/

Daniel Gould's Internals Viewer:
http://internalsviewer.codeplex.com/

http://blogs.msdn.com/b/jason_howell/archive/2010/10/25/list-of-sql-server-feature-packs.aspx

You can download a wide variety of sample databases (mostly in the AdventureWorks flavor):
http://msftdbprodsamples.codeplex.com/

If you want to load Pubs and/or Northwind on a 2005+ server, you can, I guess:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=06616212-0356-46a0-8da2-eebc53a68034

Free Maintenance / Performance Scripts

Adam Machanic's Who Is Active? v.10.0:
http://sqlblog.com/files/folders/release/entry29675.aspx

Michelle Ufford's Index Defrag Script, v4.0
http://sqlfool.com/2010/04/index-defrag-script-v4-0/

Ola's SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization
http://ola.hallengren.com/

Brent Ozar's BLITZ! 60 minute SQL Server takeover script
http://www.brentozar.com/sql/blitz-minute-sql-server-takeovers/

Kimberly Tripp's sp_helpindex2:
http://www.sqlskills.com/blogs/kimberly/post/Updates-%28fixes%29-to-sp_helpindex2.aspx

Tibor Karazsi's utility procedures:
sp_indexinfo: http://www.karaszi.com/SQLServer/util_sp_indexinfo.asp
sp_tableinfo: http://www.karaszi.com/SQLServer/util_sp_tableinfo.asp

Aaron Bertrand : Some new free tools enter the SQL marketplace