Welcome to Sign in | Help

Free SQL Server Tools

  •  11-30-2010, 1:59 AM

    Free SQL Server Tools

    Best Free Tool

    Editors' Best

    Gold: SP_WhoIsActive • Adam Machanic • sqlblog.com

    Silver: SSMS Tools Pack 1.9 • Mladen Prajdic • www.ssmstoolspack.com

    Bronze: SQL Server Maintenance Solution • Ola Hallengren • ola.hallengren.com

    Why It Won: SP_WhoIsActive is mentioned in the SQL Server community as the epitome of a fantastic free tool. Adam Machanic updates the tool frequently, it’s well explained and supported by great internal documentation, and its code is considered to be the best of the best.

    To say I like SP_WhoIsActive is an understatement,” SQL Server Magazine author Kevin Kline said in “SP_WhoIsActive” (June 2010, InstantDoc ID 125107). “This is probably the most useful and effective stored procedure I’ve ever encountered for activity monitoring. The purpose of the SP_WhoIsActive stored procedure is to give DBAs and developers as much performance and workload data about SQL Server’s internal workings as possible, while retaining both flexibility and security.”

    Community Choice

    Gold: SQL Server Maintenance Solution • Ola Hallengren • ola.hallengren.com

    Silver: SQL check 2.6 • Idera • www.idera.com

    Bronze: Tableau Public • Tableau Software • www.tableausoftware.com


    "Ola Hallengren's tools are justly famous."

    Other hot vote-getters in this year's survey …

    * Quest Software's Toad Data Modeler Freeware Edition
    * Red Gate Software's SQLSearch 1.0
    * LessThanDot's SQLCop



    Sursa: http://www.sqlmag.com/article/sql-server/2010-SQL-Server-Magazine-Editors-Best-and-Community-Choice-Awards/4.aspx

    +

    [1] SQL Sentry Plan Explorer
    [2] Toad for SQL Server FREEWARE


View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems