Improve consistency, readability, and standardization with SQL formatting
Convert SQL into a variety of popular client programming languages
Automatically update all dependent database objects on renaming or changing columns and parameter
Streamline your database design by replacing one or more relationships with associative tables
Automatically highlight unused parameters and variables while typing
Red Gate's SQL Search 1
Red Gate Software's SQL Search is an add-in for SQL Server Management Studio (SSMS) that fills in SSMS’s missing search capabilities by finding all occurrences of a database’s object. SQL Search is free, and it’s also a part of the SQL Developer Bundle and will be incorporated in a future version of SQL Prompt.
SolarWinds' Free Database Monitor
SolarWinds' Free Database Monitor (formerly Confio IgniteFree), shows performance bottlenecks deep inside your SQL Server instance. The tool allows you to find problem queries, waits, and server resources.
SQL Sentry's Plan Explorer
SQL Sentry’s Plan Explorer helps you to better analyze the graphical plan view that SQL Server Management Studio (SSMS) query plan analysis produces. Plan Explorer adds color coding to highlight potential problem areas. It is a lightweight, standalone app that contains many of the plan analysis features introduced in SQL Sentry v6, and does not require a collector service or database.
SQL Server Maintenance Solution
Always a favorite, Ola Hallengren's SQL Server Maintenance Solution creates scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, and SQL Server 2014.