Administering and Monitoring Microsoft® SQL Server™ 2005

Description:
This course will enable database administrators experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:

Exploring SQL Server 2005 Administrative Tools
Monitoring SQL Server 2005
Maintaining Databases and Indexes
 
Objectives:
At the end of the course, students will be able to:
Use SQL Server 2005 administration tools.
Monitor SQL Server 2005.
Maintain databases and indexes in SQL Server 2005.
 
Modules & Lessons
Course Overview
Module Introduction
How To Use This Course
Course Information

Exploring SQL Server 2005 Administrative Tools
Module Introduction

Using SQL Server Management Studio
Lesson Introduction
Overview of SQL Server Management Studio
Registering a Server
Overview of Object Explorer
Using Transact-SQL in SQL Server Management Studio
Working with SQL Server Management Studio Solutions
Creating a Solution with Solution Explorer
Self Test

Using SQL Computer Manager
Lesson Introduction
Overview of SQL Computer Manager
Using SQL Computer Manager
Controlling Services Manually
Viewing and Changing Service Properties
Managing Server Network Connectivity
Managing Client Network Connectivity
Self Test

Using the sqlcmd Utility
Lesson Introduction
Overview of the sqlcmd Utility
Using sqlcmd Command-Line Switches
Working with the sqlcmd Utility
Executing Scripts Using the sqlcmd Utility
Using Variables with the sqlcmd Utility
Working with a Dedicated Administrator Connection
Self Test

Using the SQL Management Objects
Lesson Introduction
Overview of SQL Management Objects
Comparing SMO and SQL Server Distributed Management Objects
Creating an SMO Application and Retrieving Server Information
Using SMO to Back Up a Database
Using SMO to List and Create a Database
Self Test

Lab: Administering SQL Server 2005
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Monitoring SQL Server 2005
Module Introduction

Using SQL Profiler
Lesson Introduction
Understanding SQL Profiler Enhancements in SQL Server 2005
Saving a Trace as XML
Self Test

Using DDL Triggers
Lesson Introduction
Overview of DDL Triggers
Creating DDL Triggers
Managing DDL Triggers
Using a DDL Trigger to Audit Database Operations
Self Test

Using Event Notifications
Lesson Introduction
Overview of Event Notifications
Creating Event Notifications
Processing Event Notifications
Managing Event Notifications
Defining Event Notifications
Self Test

Using Metadata Views
Lesson Introduction
Querying Static Metadata
Querying Dynamic Metadata
Querying Metadata
Self Test

Lab: Monitoring SQL Server 2005
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary

Maintaining Databases and Indexes
Module Introduction

Managing Indexes
Lesson Introduction
Introducing New Index Features in SQL Server 2005
Creating an Index
Altering an Index
Disabling an Index
Dropping an Index
Managing Fragmentation
Self Test

Using the Database Tuning Advisor
Lesson Introduction
Overview of the Database Tuning Advisor
Using the Database Tuning Advisor
Viewing Results as XML
Tuning a Database for a Defined Workload
Self Test

Lab: Maintaining a Database
Lesson Introduction
Scenario
Exercises
Lab Review
Module Summary