Fast Guide: Free SQL Server tools

As a SQL Server DBA or developer, you have many routine tasks that can often take up more time and energy than you'd like to admit. This collection of free tools will help automate some of those repetive database tasks. For our complete collection of tools, visit our Windows IT Downloads Library.

Working with a great SQL Server tool or script? Tell us about it and we'll enter you to win a new SQL Server DBA or developer book.

TABLE OF CONTENTS
  Backup and recovery
  Database development
  Database administration and monitoring

Backup and recovery

Return to Table of Contents

Download: SQL Backup
SQL Backup creates smaller, safer, faster backups of SQL Server databases.

Download: TimeData
TimeSpring's TimeData continuous data protection (CDP) software allows SQL Server 2005 Customer Technology Preview (CTP) users to test and migrate real-time production data from SQL Server 2000 without shutting down, slowing down or exporting data.

Download: LiteSpeed 2005
LiteSpeed is advanced backup and recovery software for Microsoft SQL Server 7, 2000 and Yukon that provides integrated high performance compression technology.

Database development

Return to Table of Contents

Download: DDL Archive Utility
The DDL Utility is a freeware utility that lets a database programmer create SQL Server 2000 DDL scripts that can be imported into a Microsoft Visual SourceSafe repository.

Download: PromptSQL
PromptSQL is an add-on application that provides auto-complete functionality as you type for programs used to create SQL statements. It works with QA, UltraEdit32, Visual Studio.NET 2003, Visual Studio 2005 and SQL Server 2000 Enterprise Manager.

Download: TOAD for SQL Server
TOAD for SQL Server improves the productivity of developers and administrators by providing an easy-to-use database and T-SQL code development environment.

Database administration and monitoring

Return to Table of Contents

Performance tuning freebies to add to your favorites
You may already be working with the typical SQL Server performance tuning tools, but are you using all the features available in each tool? Don't miss out on these must-have tools.

Download: SQLPing
SQLPing can be used to discover detailed information about the connectivity of SQL Server 2000 installations without authentication of any kind

Download: Apex SQL Report
SQLPing can be used to discover detailed information about the connectivity of SQL Server 2000 installations without authentication of any kind

Download: SmartDBA Cockpit
SmartDBA Cockpit is an interactive database productivity tool that allows data base administrators to manage their enterprise databases from any computer with an Internet browser.

Download: SQLcheck
SQLcheck investigates, organizes and explains critical diagnostic information about your server's hardware, operating system and SQL Server.

Download: SQLcheck
SQLcheck investigates, organizes and explains critical diagnostic information about your server's hardware, operating system and SQL Server.

Download: myLittleAdmin For SQL Server
myLittleAdmin for SQL Server is a web-based SQL Server and MSDE Database administration tool. It is intended to handle the administration of SQL Server and MSDE databases over the WWW. It allows you to fully manage your databases even when you don't want or cannot use MS Enterprise Manager.

Download: Transaction Manager
Transaction Manager is a long transaction handler designed for Microsoft SQL Server 2000. The Gnosis Transaction Manager can perform long transactions of virtually unlimited duration, size and complexity.

Download: Teratrax Performance Monitor
Teratrax Database Manager enables you to manage all versions and editions of SQL Server from one interface.

---

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Microsoft SQL Server Performance Monitoring and Tuning SQL Server Mailbag: CALs, witnesses and unwanted changes SQL Server Mailbag: Data restoration and DB property management Working with IntelliSense in SQL Server 2008 Management Studio SQL Server Mailbag: Stored procedures, triggers and SSRS reports Troubleshooting Distributed Transaction Coordinator errors in SQL Server Clearing the Windows page file and its effect on server performance Optimizing SQL Server indexes –- even when they're not your indexes Performance implications of transaction log autogrowth in SQL Server The short course on how SQL Server really works Determining the source of full transaction logs in SQL Server Microsoft SQL Server Tools and Utilities Microsoft SQL Server Tools Guide How SQL Server 2008 components impact SharePoint implementations SQL Server Mailbag: Data restoration and DB property management SQL language crash course (just enough to be dangerous) Setting up SQL Server Service Broker for secure communication Microsoft SQL Server 2008 Resource Governor primer The sqlcmd utility in SQL Server Performance analysis tools for SQL Server Software security tools to improve your skills in a single day Surface Area Configuration and other security tools in SQL Server 2005

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary contiguity  (SearchSQLServer.com) contiguous  (SearchSQLServer.com) drilldown  (SearchSQLServer.com) hashing  (SearchSQLServer.com) hybrid online analytical processing  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary