Microsoft SQL Server Administration Update to 2008

Audience

This course is for database administrators responsible for the migration and support of SQL Server from version 2005 to the new 2008 release.

Prerequisites

Delegates should be experienced SQL Server administrators. Attending our SQL Server 2005 Administration class or equivalent knowledge is essential.

Duration

3 days. Hands on.

Course Objectives

This course will upgrade the delegates’ skills to SQL Server 2008 so that they can support, configure, and maintain enterprise SQL Server 2008 databases and servers. On completion of the course delegates will be able to:

• Install SQL Server 2008.
• Use the new administration tools and utilities.
• Maintain the database.
• Complete backup and restore functions.
• Implement data availability solutions with mirroring and clustering.

Course Content

SQL Server 2008 Overview and Installation
New administration tools and utilities
New features in SQL Server 2008
Installing SQL Server 2008
Upgrading to SQL Server 2008
Unsupported, Discontinued and Deprecated Features
New Data Types and FILESTREAM
Table Valued Parameters
New features in Analysis Services, Reporting Services and Integration Services

Administration Tools
SQL Server Management Studio
Using SqlCmd
SQL Server Management Objects
Query Editor IntelliSense
PowerShell Provider

Database Monitoring
SQL Profiler
DDL Triggers
Event Notification
SQL Server Extended Events
Metadata views

Database Maintenance and Indexes
Managing Indexes
Filtered Indexes and Views
Full-text Indexing Improvements
Data and Indexes Compression
Partitioning and Partition Switching

SQL Server 2008 Security
Overview
Managing Security
Permissions
Certificates
Extensible Key Management
Encrypting Databases Using Transparent Data Encryption
SQL Server Audit

Policy-Based Management
Designing and Using Policies
Importing and Exporting Policies
SQL Server Group Management - Central Management Servers

Backup and Recovery
Backup and Restore Operations
Backup Compression
Snapshots

Troubleshooting and Performance Tuning
Activity Monitor
SQL Profiler
Data Collector
Database Engine Tuning Advisor
Optimizing Workloads Using Plan Guides
Resource Governor
MERGE Statement
Change Tracking and Change Data Capture
StreamInsight Overview

Introduction to High Availability
High Availability Solutions Overview (Clustering, Mirroring, Backups, Log shipping)
Upgrading High Availability Setups

Replication
New types of Replication
Configuring and Managing Replication

Optional topics:
Any part of Microsoft SQL Server 2008 System Administration course can be included into this course on demand.