SQL Server Management Studio

 

SQL Server 2008 R2

Other Versions

26 out of 48 rated this helpful - Rate this topic

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.

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.

Requirements

---

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 AdventureWorks2008R2 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.

Lesson 1: Basic Navigation in SQL Server Management Studio

SQL Server 2008 R2

Other Versions

72 out of 97 rated this helpful - Rate this topic

Microsoft SQL Server Management Studio is a powerful and flexible tool. However, users new to Microsoft Visual Studio sometimes have trouble finding the quickest way to access the right feature. This lesson shows you how the windows work together to present a design surface that makes your work easier. At the end of this lesson, you will know how to clear unwanted windows out of your way, how to quickly bring up windows with the information you need, and how to configure the default surface to support the work you do most often.

This lesson contains the following topics:

• Starting SQL Server Management Studio
• Connecting with Registered Servers and Object Explorer
• Changing the Environment Layout
• Displaying the Document Window
• Showing the Object Explorer Details page
• Selecting the Keyboard Shortcut Scheme
• Setting the Startup Options
• Restoring the Default SQL Server Management Studio Configuration
• Summary