Tutorial: SQL Server Management Studio
Welcome to the SQL Server Management Studio tutorial. Hosted inside Microsoft Visual Studio, Management Studio brings graphical tools for database management together with a rich development environment. Management Studio enables you to access and manage the Database Engine, Analysis Manager, and SQL Query Analyzer in one tool, together with the ability to write Transact-SQL, MDX, XMLA, and XML statements.
This tutorial will help you understand the presentation of information in Management Studio and how to take advantage of the features.
This tutorial is intended for users who are not familiar with Visual Studio, but who are experienced database administrators and Transact-SQL developers who are familiar with database concepts and the Transact-SQL language. It is helpful to be familiar with the SQL Server 2000 tools.
Your system must have the following installed to use this tutorial:
SQL Server 2005 or SQL Server 2008 with the AdventureWorks sample database databases. To enhance security, the sample databases are not installed by default. To install the sample databases, see Considerations for Installing SQL Server Samples and Sample Databases.
Internet Explorer 6.0 or later.
Visual SourceSafe for portions of Lesson 4.
When reviewing tutorials we recommend that you add Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.