Top 10 Free SQL Server Tools

SQL SPY 2011 Live Monitoring

SQL SPY the monitoring tool that's FUN to use!  How many productive tools thay you use can you say that about? For me, SQL SPY is one of those tools, if not the only tool that I I would describe this way.  SQL SPY is a tool to display, monitor and report on valuable SQL Server information. This is a very handy tool that I use all the time.  The download requires registration which is fast and simple, but if you don't have the 5 minutes it takes you can use this login and password.

Login: JOHNNY1NY                               Password: aoeu

EMS SQL Manager 2005 Lite for SQL Server

EMS SQL Manager 2005 Lite for SQL Server is a tool for Microsoft SQL Server administration. It allows you to browse and edit table data and procedures, manage database objects, run SQL queries, manage users and more. The program provides a modern, easy-to-use interface; the Lite version is designed for users who are new to MS SQL server and need only it`s basic functionality.

SSMS Tools Pack

SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Microsoft SQL Server Management Studio Express.

CASE Studio 2

CASE Studio 2 is a highly professional and customizable database modeling tool that allows database designers and developers to visualy create and maintain Entity Relationship Diagrams (ERD) and Data Flow Diagrams (DFD) and generate SQL scripts for various databases automatically.

DBDesigner 4

DBDesigner 4 is a visual database design system that integrates database design, modeling, creation and maintenance into a single, seamless environment. It combines professional features and a clear and simple user interface to offer the most efficient way to handle your databases.

SQLIO

SQLIO is a tool provided by Microsoft which can also be used to determine the I/O capacity of a given configuration.

ClearTrace

ClearTrace is a program that I always wanted to write but just never had the time. It imports profiler trace files into SQL Server and displays summary performance information. It normalizes SQL statements to eliminate differences and allow group analysis of benchmarks. For example, the following statement:

Select * From SQLTable Where NewsletterID=19

is normalized to:

SELECT * FROM SQLTABLE WHERE NEWSLETTERID={##}

RAC (Relational Application Companion)

Visual GUI eases the writing of complex, data manipulation sql statements. RAC uses a common framework that can be manipulated to summarize data, perform pivoting operations including crosstabulations, character operations including string replacement, splitting, concatenation and processing hierarcharical data.

Sql Beautifier

Online sql formatter tool and free downloadable tool

Omega.MSSQL

Omega is a browser based tool that allows database administration over the internet. It requires you point your internet connection to the directoy you install the produce into. Oname allows you to create/alter/drop tables, connect to SQL Server 2008, 2005 & 2000 databases, extract information about the objects contained in your database, search for objects contained in your database, create and store documentation about objects in your database, create report about the all or selected objects contained in your database, create and execute SQL queries against your database.The beta version is free to use.