SQL Server Management Studio Tutorial
Welcome to the Microsoft SQL Server Management Studio tutorial. Management Studio is a new tool for SQL Server database administrators and developers. Hosted inside Microsoft Visual Studio, it brings graphical tools for database management together with a rich development environment. Management Studio includes the functions of SQL Server 2000 Enterprise Manager, Analysis Manager, and SQL Query Analyzer in one tool, along with the ability to write 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 that were not available in Enterprise Manager.
What You Will Learn
The best way to get acquainted with Management Studio is through hands-on practice. This tutorial will teach you how to manage the components of Management Studio and how to find the features that you use regularly.
This tutorial is divided into four lessons:
- Lesson 1: Basic Navigation in SQL Server Management Studio
In this lesson you will learn how to use the components of Management Studio, how to reconfigure the environment layout, and how to restore the default layout.
- Lesson 2: Writing Transact-SQL
In this lesson, you will learn how to open Query Editor, how to manage code, and how to use the other new features of Query Editor.
- Lesson 3: Using Help
In this lesson you will learn how the new Help system functions, several ways to access Help, and how to manage the Help windows.
- Lesson 4: Working with Templates, Solutions, Script Projects, and Source Control
In this lesson you will learn how to use templates, manage solutions and script projects, and use Management Studio to integrate solutions with Microsoft Visual SourceSafe.
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 with the AdventureWorks sample database databases. To enhance security, the sample databases are not installed by default. To install the sample databases, see Running Setup to Install AdventureWorks Sample Databases and Samples.
- 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.