[COPY] free SQL server resources

28 Oct


thanks for Aaron Bertrand’s sharing. I save this Original content for access easier.

>Free Upgrade Advisors / Best Practices Analyzers

These tools from Microsoft can be instrumental in cleaning up your systems and finding issues *before* the day of the upgrade.  I’m including the SQL Server 2005 versions, but if you’re just planning your upgrade to 2005 now, I’d suggest re-thinking toward 2008 or 2008 R2.  The last service pack for 2005 is due out later this year, and the next major version of SQL Server is probably about a year after that.  Note that there is no SQL Server 2008 Best Practices Analyzer, at least that I could find.

SQL Server 2005 Upgrade Advisor

SQL Server 2005 Best Practices Analyzer

SQL Server 2008 Upgrade Advisordownload x64download x86

SQL Server 2008 R2 Upgrade Advisor
download x64download x86

SQL Server 2008 R2 Best Practices Analyzerdownload x64download x86

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

Free Documentation

Books Online is the official documentation for SQL Server, but you don’t have to have a SQL Server license to use it.  You can choose to download the application (or install it as part of setup) and keep it up to date, or use the web-based version.

SQL Server 2005 Books Online – or download

SQL Server 2008 Books Online – or download

SQL Server 2008 R2 Books Online – or download

Free Feature Packs

Jason Howell has summed up the current set of feature packs (these are utilities provided by Microsoft to complement SQL Server tools and services):

Free Management Studio Add-Ins

Several authors have developed tools that plug into Management Studio, though I wouldn’t expect all of them to work flawlessly with SQL Server 2008 R2 – yet.

Mladen Prajdic’s SSMS Tools Pack:

Sean Price’s Snapshot add-in:

Jonathan Kehayias’ Extended Events Manager:

RedGate SQL Search

Daniel Gould’s Internals Viewer:

Free Community Resources

Looking for other SQL Server people to help you – for free?  The SQL Server community is, as a whole, one of the best free resource you’re likely to find in any industry.  I don’t think I’m going to try and list out all of the SQL Server blogs here… there are just too many.  But I can point out places where you can get free help online or – believe it or not – in person:

Twitter hashtag : #sqlhelp

Also see this great twitter primer from @BrentO:

SQL Server forums on MSDN:

Stack overflow:

Ask SQLServerCentral:


SQLServerPedia is like Wikipedia but for SQL Server:

Also look for a SQL Saturday coming to a city near you:

Or a local user group.  See this editorial by Brad McGehee:

Finally, PASS is free to join. Watch for free online training events and presentations via virtual chapters:

Free Blog Assistance

This one is kind of sitting in its own category, but I didn’t know where else it would fit.  This web form allows you to take T-SQL code and format it nicely – color coding and all – for various blog formats.  I have found it invaluable over the past few years in adding code samples to my posts:

Free Sample Databases

You can download a wide variety of sample databases (mostly in the AdventureWorks flavor):

If you want to load Pubs and/or Northwind on a 2005+ server, you can, I guess:

Free Maintenance / Performance Scripts

Adam Machanic’s Who Is Active? v.10.0:

Michelle Ufford’s Index Defrag Script, v4.0

Ola’s SQL Server 2005 and 2008 – Backup, Integrity Check and Index Optimization

Brent Ozar’s BLITZ! 60 minute SQL Server takeover script

Free Maintenance / Performance Tools

SQL Sentry Plan Explorer beta:

Confio IgniteFree:

Idera SQL Doctor beta:

PSSDIAG (for SQL Server 7.0 / 2000):

SQLNexus (for SQLDiag / PSSDiag):


SQL Load Generator:


Performance Analysis of Logs (PAL) Tool:

scaleSQL ClearTrace:


SQL Server Cache Manager:

SQL Server 2005 Performance Statistics Script:

SQL Server 2005 Performance Dashboard Reports:

SQL Server 2008 Performance Dashboard Reports:

SQL Server Health and History Tool (SQLH2):
Performance Collector:
Performance Reports:

SqlMonitoring Tool:

Log Parser 2.2:

DMVStats 1.01:

Tibor Karazsi’s utility procedures:

Free Configuration / Policy Tools

Quest Discovery Wizard beta:

Enterprise Policy Management (EPM) Framework:

Partition Management:
SQL Server Central Management System:

SQL Server Express Utility:

Free SQL Server IDEs

Various free (“community edition”) tools from Atlantis:

Toad for SQL Server has a freeware version:

Free SQL Server eBooks

I was really reluctant to list all of the eBooks I could find, because it is often difficult to asses the legality of many offers out there.  Here are a few that I know are legit, and I’ll let you search for others on your own.

SQL Server Crib-Sheet Compendium (Chris Massey):

SQL Server DMV Starter Pack (Glenn Berry, Louis Davidson, Tim Ford):

Defensive Database Programming (Alex Kuznetsov):

SQL Server Execution Plans (Grant Fritchey):

Introducing SQL Server 2008 R2 (Microsoft Press):

Brad’s Sure Guide to SQL Server 2008 (Brad McGehee):

Paul Randal’s DBA-myth-a-day series

Free SSIS Tools and Resources

SSIS Community Tasks and Components

Free PowerShell Tools and Resources


Free PowerShell IDE:

PowerShell Extensions (SQLPSX):

TechNet : Scripting with PowerShell:

Free PowerShell eBooks

An Introduction to Microsoft PowerShell

Effective Windows PowerShell!5A8D2641E0963A97!6930.entry?sa=58811724

PowerShell Workbook : server administration


1 Comment

Posted by on October 28, 2010 in SQL


One response to “[COPY] free SQL server resources

  1. Vishal Pawar

    December 17, 2011 at 14:43

    Very Nice information !


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: