Treffer: Getting Started With SQL Server Tools.

This article explains how to work with SQL Server using various tools. There are two classes of SQL Server tools: graphical and command-driven. In a way, the graphical tools are like power tools in woodworking, and the command-driven tools are like hand tools. Understanding when to use each is the mark of an accomplished professional. There are several tools included within the SQL server. One is Books Online. It contains the SQL Server's manual, help files, programming examples, and more. It is the first place you should stop because SQL Server does not come with other documentation. Another tool is the Enterprise Manager. This is the primary tool to interface with SQL Server. It uses Microsoft Management Console technology, which means that there are objects on the left that when clicked produced outputs on the right. If Enterprise Manager is a power tool, then Query Analyzer is a hand tool. Working with Query Analyzer requires more knowledge than simply pointing at an object and clicking it. Another tool is the SQL Server Profile. This tool allows you to watch the command SQL Server receives and how it handles them. There are also after-market tools. Together, these tools are used for maintenance of the database and ensured that it is secure. In addition, these tools enure that the database runs quickly.