SQL Server freebie: TOAD for SQL Server

Most SQL Server development is done using SQL Server Enterprise Manager or Query Analyzer. The former provides a nice, hierarchical view of the entire server and its attendant database objects, but has many limitations. The latter provides the power of a command line, but is strictly for experts only since it provides nothing like a query builder or object explorer.

Quest Software Inc.'s TOAD for SQL Server was written to address many of these problems and solve a few others for good measure. TOAD is a development environment for SQL Server that also works as an object explorer, dependency checker and object manager.

The interface is patterned loosely after Microsoft Visual Studio. One can explore several servers and databases at once through a tabbed interface; another layer of tabs lets you explore the different types of objects in each database. An additional tab brings you to the Toad Online portal, which provides program tips and information about the full version of the product.

When you bring up a table (or any other object), you can explore all the properties of that table through a set of tabs: columns in the table, the

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server Database Modeling and Design Top tips and tricks for SQL Server database development Managing the development lifecycle with Visual Studio Team System 2008 A first look at Visual Studio Team System 2008 Database Edition Testing transaction log autogrowth behavior in SQL Server Top 10 SQL Server Tips of 2008 Tutorial: SQL Server indexing tips to improve performance Tutorial: Learn SQL Server basics from A-Z SQL Server database design disasters: How it all starts Can you shrink your SQL Server database to death? Physical data storage in SQL Server 2005 and 2008 SQL Server Management A first look at Microsoft SQL Server 2008 R2 Maintaining high availability of SQL Server virtual machines Creating fault-tolerant SQL Server installations Using Microsoft Hyper-V for SQL Server consolidation Scaling up vs. scaling out with SQL Server 2008 Migrating to SQL Server 2008 and leveraging new features Testing a SQL Server environment before an upgrade Does upgrading to SQL Server 2008 fit your business? Meeting business needs with SQL Server full-text search Using dynamic management views to improve SQL Server index effectiveness

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary binary tree  (SearchSQLServer.com) block  (SearchSQLServer.com) data structure  (SearchSQLServer.com) DDBMS  (SearchSQLServer.com) entity-relationship model  (SearchSQLServer.com) initial extent  (SearchSQLServer.com) primary key  (SearchSQLServer.com) segment  (SearchSQLServer.com) tablespace  (SearchSQLServer.com) view  (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

data itself, constraints, triggers and object dependencies in both directions. You can also generate scripts for the object with many different options (to check for the object's existence, object permissions, foreign and primary keys, etc.). The Object Search function lets you find any object by name, regardless of what it is or which database it may be in.

The free version of TOAD is fully functional, but it expires after 90 days and must be reinstalled. The commercial version includes advanced features such as tuning and modeling functions, a powerful stored procedure debugger and more. A single-seat license is $470 and includes a year of maintenance.

About the author: Serdar Yegulalp is editor of the Windows Power Users Newsletter. Check it out for the latest advice and musings on the world of Windows network administrators -- and please share your thoughts as well!

More information from SearchSQLServer.com