Free SQL Server Tools

B_gd_n[ ]Sahlean — Mon, 29 Nov 2010 23:59:56 GMT

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

Diverse

Free SQL Server Tools