Toad for SQL Server Pro

Manufacturer: Quest
Toad for SQL Server is a database development and administration tool that increases productivity and ensures optimal code quality for your SQL Server environment.
Toad for SQL Server Pro includes:
1 seat of TOAD for SQL Server, Debugger and Knowledge Xpert for SQL Server - sold per seat
See also Toad Tutorial - SQl Server .

Features Benefits
SQL Editor Accelerates stored procedure construction via an intuitive editor within built-in code snippets and function builders that minimizes key strokes and frees up time for more proactive tasks.

SQL Tuning
Automates the optimization process of your SQL statements by capturing poorly written SQL, generating every possible re-write, guaranteeing semantic equivalency and quickly discarding those of minimum benefit. The SQL Optimizer re-writes, benchmarks, and compares the fastest alternate statements to the original SQL and eliminates the current manual, trial-and-error rewrite process

T-SQL Debugger
Speeds T-SQL debugging through integration with the SQL Editor window which accepts parameters and uses color coded break-points to help step through code and speed SQL Server 2005, and 2000 T-SQL debugging.

Knowledge Xpert
Reduces the amount of time spent digging through manuals to comprehend the logic of SQL Server syntax with Toad's built in SQL Server knowledge base.

Compare and Sync
Compares the differences between Servers, Databases, and Data; highlights the additional and missing items, and generates a script to synchronize the two environments in order to ensure validity. Macro Record and Playback Gives users the ability to record and play back keyboard commands, enhancing usability and reducing manual effort.

Database Administration
Automates day-to-day database management and simplifies database administration tasks by simultaneously creating and managing database objects, SQL code, users, logins, and security across multiple servers. Log Reader Allows users to recover data stored in transaction log files by rolling back any operation and reconstructing transactions.

Service Broker Manager
Provides a GUI (graphical user interface) that reduces the complexity of managing and configuring the Service Broker.

SQL Modeler
Lets you quickly model a table and graphically see the dependencies and joins to other tables, ensuring a better understanding of the relationships.

Data Report Designer
Allows developers and administrators to quickly design and format reports on critical application data which can be saved and rapidly executed.