Microsoft SQL Server Tools Guide
Need help with a SQL Server task? Want to make managing SQL Server easier? We've compiled a list
of nifty tools – several that are free – that can help with a plethora of DBA tasks – from
performance tuning to security to business intelligence.
Keep in mind this guide merely scratches the surface of SQL Server tools, and we'll update it
regularly as new tools become available and old tools are improved.
Got a great tool that's not listed here? Email us at
SQL SERVER DATABASE TOOLS FOR:
| Installation and management tools
- Free! SQL Server FineBuild (CodePlex)
Installs SQL Server -- and best-practice configurations -- with one click. Download SQL Server FineBuild.
- Free! SQL Job Manager (Idera)
Streamlines the process of cross-server SQL Server job management, reducing job failure rates and
the amount of time spent on job management activities. Download SQL Job
- RazorSQL (Richardson Software)
SQL query tool, database browser, SQL editor, and database administration tool for Windows, Mac OS
X, Linux, and Solaris. Download
- SQL Partition Manager (DonWellSoft)
Ideal for large databases, simplifies partitioned table maintenance by automating management tasks.
Download SQL Partition Manager.
- Free! YourSQLDba (Société GRICS)
Script file of T-SQL stored procedures that automate routine database maintenance. Download
- Free! Object Search (Microsoft)
Built-in feature in SQL Server Management Studio 2008 that helps find objects in a particular
on Object Search.
| Monitoring and performance tuning
- SQL admin toolset (Idera)
Set of 24 administration tools for monitoring, troubleshooting, administering, and reporting
including Password Checker, Job Editor and Patch analyzer. Microsoft MVPs receive a free license.
Download SQL admin
- myLittleAdmin (myLittleTools)
Web-based application that administers SQL Server and Desktop Engine databases over the internet.
- Free! SQL Permissions (Idera)
Moves logins and applies permissions across all databases on the target server or single database.
- Event Manager (SQL Sentry)
A scheduling, alerting and response system for SQL Server jobs and other events that impact
performance that allows problems to be solved as they arise. Download
- Performance Advisor (SQL Sentry)
An advanced performance dashboard that deliver Windows and SQL Server metrics in a single view
along with details regarding heavy SQL blocking, deadlocks and disk bottlenecks. Download
- Free! Performance Studio (Microsoft)
Built-in administrative console that helps monitor speed and efficiency of databases, and collects
real-time performance data from multiple databases and stores them in a central repository. More
on using Performance Studio.
- Free! Data Collector (Microsoft)
Component of SQL Server 2008 that collects data and provides one central point for data collection
across database servers and applications. More on Data Collector.
- Performance Monitor (Teratrax)
Low-footprint technology that collects performance information, which can bedanalyzed by an
easy-to-understand user interface. Free for SQL Server Express Edition. Download Performance Monitor.
- Free! SQL Check (Idera)
Monitors performance and pulls together numerous statistics in a single screen. Functions as a
secure screen saver. Download SQL
- Spotlight on SQL Server Enterprise (Quest Software)
Detects and diagnoses performance issues across a SQL Server environment and provides an overview
of enterprise performance. Download Spotlight.
| Backup and recovery tools
- SQL Backup (Red Gate)
Creates smaller, safer and faster backups of SQL Server databases. Download SQL Backup.
- LiteSpeed (Quest Software)
Backup and recovery software that provides integrated high performance compression technology. Download LiteSpeed.
- TimeData (DoubleTake Software)
Continuous data protection software that provides data recovery at any point in time, and allows
workflow to resume without having to recover from tape. Download
- SQL safe Backup (Idera)
Accelerates, compresses and encrypts database backups. Download SQL safe
- Free! SQL safe Freeware Edition (Idera)
Based on Idera's SQL safe product, includes a high-performance backup and recovery engine, a
scriptable interface and can backup and compress any size and any number of databases. Download SQL safe
- SQL virtual database (Idera)
Allows SQL Server backup files to be attached, queried as real databases and data to be accessed in
SQL Server backup files without restoring. Download SQL
- Free! SQL Server Database Copy Tool
Copies a SQL Server database from one instance to another by backing it up, copying the backup file
to the destination server and restoring the database. Download SQL Server Database Copy Tool .
- AppDetective (Application Security)
Network-based, vulnerability assessment tool that locates, examines, reports and helps fix security
- NGSSquirrel (Next Generation Security Software)
Vulnerability assessment tool available for SQL Server 2000 and SQL Server 2005. Download
- Metasploit (Metasploit)
Penetration testing and exploit tool. Download
- QualysGuard (Qualys)
Vulnerability assessment tool that combines vulnerability management service with an IT compliance
- Free! SQL Encryption Assistant (Devenius)
Manages encryption keys and certificates inside SQL Server, directly inside SQL Server Management
Studio. Download SQL
- SQL Compare (Red Gate)
Compares and synchronizes database changes quickly and simply. Download SQL Compare.
- Toad (Quest Software)
Management and development toolset designed to bridge the gap between SQL Server Management Studio
and Visual Server. Download
- Performance Advisor for Analysis Services (SQL Sentry)
Monitors and optimizes SQL Server Analysis Services performance, and provides insight related to
memory, storage systems, aggregation usage, queries and processing. Download
Performance Advisor for Analysis Services.
Third-party set of CLR assemblies and stored procedures that let you leverage Twitter in your SQL
Server 2005 and up databases. More on
- Free! T-SQL Debugger (Microsoft)
Built-in tool that includes all the core debugging features -- the Locals, Watch, QuickWatch and
Output windows – in addition to the ability to set breakpoints to stop execution. More on
working with T-SQL Debugger.
- Free! IntelliSense (Microsoft)
An auto-completion system supported in SQL Server Management Studio 2008 that provides easy access
to language elements as you write your queries. More on
- Apex SQL Report (Apex)
Data driven, web-reporting solution for SQL Server. Download APEX SQL Report.
- SQL Prompt (Red Gate)
Add-on application that provides auto-complete functionality while typing for programs used to
create SQL statements. Download SQL Prompt.
- Free! ApexSQL Code (Apex)
Generates code from C# or VB.NET code templates. Free for a limited time. Download ApexSQL Code.
- Free! ApexSQL Refactor (Apex) Formats SQL code
for improved readability and to conform to team coding standards. Download ApexSQL Refactor.
- Free! Instant SQL Formatter
Online tool that cleans-up SQL code, formats SQL into HTML and translates SQL code into other
program languages like Java. Use
Instant SQL Formatter.
- Free! SQLinForm
Automatic web-based SQL code formatter. Access SQLinForm.
- SQL Scripter (SQL Scripter)
Data export and scripting utility for SQL Server. Packages and transports table data. Download SQL Scripter.
- More SQL
Server security tools
Check out the best places to find security tips and countless security tools.
SQL injection is a security exploit in which the attacker adds SQL code to a Web form input box to
gain access. These tools automate testing of SQL injection.
- Top SQL Server products of 2008/2007
SQL SERVER DATABASE TOOLS FOR:
This was first published in September 2009