Free SQL Server Tools

At our monthly meetings we regularly feature free SQL Server tools to make your job as a database professional easier. Here's the full list:

 

  • SEPT
     
    2015

    Minion Reindex Fully automated reindexing solution that's intuitive to use, simple to customize, deeply configurable, and easy to report from Get it!

  • MAY
     
    2015

    sqlserverupdates.com Easy to use list reference of the most recent service packs and cumulative updates for SQL Server Get it!

  • MAR

    2015

    BIDS Helper A Visual Studio add-in with features that extend and enhance business intelligence development functionality in SQL Server 2005, 2008, and 2008 R2 BI Development Studio (BIDS) and SQL Server 2012 SQL Server Data Tools (SSDT). Get it!

  • FEB

    2015

    Red Gate SQL Search SQL Search is a free add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases. Find fragments of SQL in tables, views, stored procedures, functions, views, jobs, and more. Quickly navigate to objects wherever they happen to be on a server. Search across multiple object types and multiple databases. Find all references to an object. Search with booleans and wildcards. Get it!

  • SEP

    2014

    Statistics Parser Sometimes reading SQL Server ouput from Statistics IO and Statistics Time can be a total drag. Statistics Parser will help with that. Just paste in the output of Statistics IO and/or Statistics Time and press Parse. Your output will be formatted and totalled. Enjoy. Get it!

  • AUG

    2014

    Poor SQL Take pity on your SQL with instant, free and open-source, online formatting using the Poor Man's T-SQL Formatter library. If you like it, download the SSMS / Visual Studio plugin, the command-line bulk formatter, and/or the WinMerge plugin to integrate it into your workflow and use it offline - equally free. Get it!

  • JUL

    2014

    sp_Blitz® You've got a Microsoft SQL Server that somebody else built, or that other people have made changes to over the years, and you're not exactly sure what kind of shape it's in. Are there dangerous configuration settings that are causing slow performance or unreliability? sp_Blitz® is a fast, easy, free health check that flags common issues in seconds, and for each warning, gives you a link to a web page with more in-depth advice. Get it!

  • JUN

    2014

    Enterprise Policy Management Framework The Enterprise Policy Management Framework (EPM) is a solution to extend SQL Server Policy-Based Management to all versions of SQL Server in an enterprise, including SQL Server 2000 and SQL Server 2005. The EPM Framework will report the state of specified SQL Server instances against policies that define the defined intent, desired configuration, and deployment standards.. Get it!

  • MAY

    2014

    Ola Hallengren's Maintenance Solution Ola Hallengren's maintenance solution comprises a set of scripts for running backups, integrity checks, and index and statistics maintenance. The solution supports all editions of SQL Server 2005, 2008, 2008 R2, 2012, and 2014, and is based on stored procedures, the sqlcmd utility, and SQL Server Agent jobs. Get it!

  • APR

    2014

    SQL Server Management Studio SQL Server Management Studio (SSMS) is a comprehensive utility for managing SQL Server objects that combines an easy-to-use graphical interface with rich scripting capabilities. Management Studio can be used to manage Database Engine, Analysis Services, Integration Services, and Reporting Services. As of SQL 2012, the full version of SSMS is free to use without a license. Get it!

  • MAR

    2014

    SQLjobvis SQLjobvis is the SQL Server Agent history viewer with a difference. Use it to quickly identify Failures, Long-running jobs, and Multiple jobs running simultaneously...and all in an intuitive and visually appealing interface. Get it!

  • FEB

    2014

    ClearTrace ClearTrace imports SQL Server 2000, SQL Server 2005 and SQL Server 2008 trace and profiler files into SQL Server and displays summary performance information. It is designed to provide the same performance summary as Read80Trace but in a graphical environment and for SQL Server 2005 and SQL Server 2008. Get it!

  • JUL

    2013

    Glenn Berry's SQL Server Diagnostic Information Queries Troubleshooting and diagnostic queries that will help you quickly identify common performance and other issues you may run into with SQL Server Get it!

  • JUN

    2013

    sp_whoisactive Who is Active is a DMV-based monitoring stored procedure that uses 15 different views to show a large amount of data about what's running on your server. Who is Active was designed to be extremely flexible, and includes options to not only get different types of data, but also to change the output column list and sort order. Who is Active was designed with performance in mind at every step; users report that under normal conditions response times are generally subsecond, with slightly longer response times on servers that are extremely taxed. Who is Active is compatible with all versions of SQL Server after SQL Server 2005 RTM. It does require that the host database (generally master) is not set for SQL Server 2000 compatibility mode. Get it!

  • MAY

    2013

    SQL Power Doc SQL Power Doc is a collection of Windows PowerShell scripts and modules that discover, document, and diagnose SQL Server instances and their underlying Windows OS & machine configurations. SQL Power Doc works with all versions of SQL Server from SQL Server 2000 through 2012, and all versions of Windows Server and consumer Windows Operating Systems from Windows 2000 and Windows XP through Windows Server 2012 and Windows 8. SQL Power Doc is also capable of documenting Windows Azure SQL Databases. Get it!

  • APR

    2013

    SQL Sentry Plan Explorer SQL Sentry Plan Explorer builds upon the graphical plan view in SQL Server Management Studio (SSMS) to make query plan analysis more efficient. It is a lightweight standalone app that contains many of the plan analysis features introduced in SQL Sentry v6, and does not require a collector service or database. Get it!