Metadata and Object Search Tool for Microsoft SQL Server 2005 and 2008 Download Here

The original query analyzer object search tool in Sql Server 2000 was one of my favorite tools. It was great for quickly locating database objects and analyzing database content. Non-sql developers and analysts could easily examine metadata without having to actually write any sql. For some reason, Microsoft dropped the tool in the mssql 2005 and 2008 releases. I wrote this freeware program to do the exact same thing for the newer sql server releases. I've also added some features I find helpful. It's a work in progress so check back from time to time for updated versons.

Download the tool here.

---

SQL Spy

SQL SPY is a tool to display, monitor and report on valuable SQL Server information. This is a very handy tool.

---

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.

---