Monday, February 07, 2011

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

No comments: