Updating Your SQL Server 2005 Skills to SQL Server 2008

Prepare for SQL Server 2008.

Configuration Servers

Policy-Based Management

Creating a Configuration Server

Creating and Applying a Policy

After completing this module, students will be able to:

Create and use a configuration server.

Create and use policies.

Managing Workloads with Resource Governor

Monitoring Performance with the Data Collector

Managing Performance with Plan Freezing

Using Resource Governor

Using the Data Collector

After completing this module, students will be able to:

Manage workloads with Resource Governor.

Monitor performance with the Data Collector.

Manage performance with Plan Freezing.

Encrypting Databases

Auditing All Actions

Using Transparent Data Encryption

After completing this module, students will be able to:

Encrypt databases.

Audit all actions.

Developer Tool Enhancements

Data Type Enhancements

Working with Spatial Data

Using Date and Time Data Types

Using Spatial Data

After completing this module, students will be able to:

Describe the developer tool enhancements in SQL Server 2008.

Use the data type enhancements in SQL Server 2008.

Work with spatial data.

Always On Technologies

Transactional Peer-to-Peer Replication

Configuring Peer-to-Peer Replication

Adding a Replication Node

After completing this module, students will be able to:

Describe the SQL Server 2008 always on technologies.

Implement transactional peer-to-peer replication.

ETL Enhancements

Using Partitioned Tables

Optimizing Data Storage

Using Change Data Capture

Using the MERGE Statement

Working with Partitioned Data

After completing this module, students will be able to:

Describe the ETL enhancements in SQL Server 2008.

Use partitioned tables.

Optimize data storage.

Reporting Services Architecture and Management

Authoring Reports

Report Processing and Rendering

Creating a Report with Report Designer

Managing Reporting Services

After completing this module, students will be able to:

Describe the Reporting Services architecture and management.

Author reports.

Understand report processing and rendering.

Multidimensional Analysis with SQL Server Analysis Services

Data Mining with SQL Server Analysis Services

Implementing Multidimensional Analysis

Implementing Data Mining

After completing this module, students will be able to:

Implement multidimensional analysis.

Implement data mining.