Module 1: Designing an Administrative Solution for SQL Server 2008
Overview of SQL Server 2008 Designing an Administrative Solution Developing and Deploying an Administrative Solution for SQL Server 2008 Implementing an Administrative Solution in SQL Server Management Studio (SSMS) Lab: Designing an Administrative Solution for SQL Server 2008 Designing an Administrative Solution Using SQL PowerShell to Automate SQL Server Configuration Creating SQL Server PowerShell Scripts Configuring FILESTREAM Support in SQL Server 2008
Module 2: Deploying SQL Server 2008
System Requirements for SQL Server 2008 Upgrading and Migrating to SQL Server 2008 Configuring Instances in SQL Server 2008 Lab: Deploying SQL Server 2008 Planning a SQL Server Upgrade Preparing for the Upgrade Upgrading to SQL Server 2008 Performing Post-Upgrade tasks
Module 3: Designing the Physical Structure of SQL Server 2008
Introduction to the Physical Structure of a Database Planning for Partitioning Planning for Full-Text Indexing Lab: Designing the Physical Structure of SQL Server 2008 Planning the Physical Structure of SQL Server 2008 Implementing the Physical Structure of a Database Configuring Partitions Configuring Full-Text Indexing
Module 4: Designing a Strategy for Maintaining a Database in SQL Server 2008
Designing a Strategy for Maintaining Statistics for a Database Designing a Strategy for Maintaining Indexes Designing a Strategy for Database Compression Lab: Designing a Strategy for Maintaining a Database in SQL Server 2008 Designing a Database Maintenance Strategy Maintaining Statistics Maintaining Indexes Implementing Database Compression
Module 5: Designing Solutions for Managing SQL Server 2008
Designing a Policy-Based Management Strategy Controlling Resource Usage by using Resource Governor Auditing Database Changes Lab: Designing Solutions for Managing SQL Server 2008 Designing a Management Strategy for SQL Server 2008 Configuring Policies by Using Policy-Based Management Governing Resources Consumption Implementing DDL Triggers Implementing CDC
Module 6: Automating the Database Management Strategy for SQL Server 2008
Managing SQL Server Agent Automating Administrative Tasks in SQL Server Monitoring Events in SQL Server Lab: Automating the Database Management Strategy for SQL Server 2008 Planning an Automated Database Management Strategy Using SQL Server Agent Creating Scripts to Automate Administrative Tasks Enabling Event Notification Setting up SQL Server Agent to Monitor Events
Module 7: Designing a Strategy for Securing SQL Server 2008
Securing SQL Server 2008 Instances Planning Database Security Managing Certificate and Keys in SQL Server 2008 Implementing Database Encryption Lab: Designing a Strategy for Securing SQL Server 2008 Designing a strategy for Database Security Configuring Security in SQL Server Enabling Database Encryption
Module 8: Designing a Strategy for Monitoring SQL Server 2008
Overview of Monitoring SQL Server 2008 Monitoring SQL Server Instances Monitoring SQL Server Databases Monitoring Multiple SQL Servers by Using Data Collection Lab: Designing a Strategy for Monitoring SQL Server 2008 Designing a Data Collection Architecture Monitoring SQL Server Instances Implementing Tracing in SQL Server 2008 Using DTA Monitoring Performance by Using Data Collection
Module 9: Designing a Strategy for Content Distribution in SQL Server 2008
Distributing Data in SQL Server 2008 Working with Distributed Queries Managing Distributed Content by Using Distributed Transactions Managing SQL Server Integration Services (SSIS) Packages Setting Up Scalable Shared Databases Lab: Designing a Strategy for Content Distribution in SQL Server 2008 Selecting a Content Distribution Technology Performing a Remote Query Monitoring an SSIS Package
Module 10: Designing a Strategy for Replication in SQL Server 2008
Designing a Database Replication Strategy Implementing Content Distribution by using Replication Configuring a High-Availability Solution by Using Replication Lab: Designing a Strategy for Replication in SQL Server 2008 Designing a Replication Strategy Setting up Snapshot Replication Setting up Peer-To-Peer Replication
Module 11: Designing a High-Availability Solution for SQL Server 2008
Introduction to High Availability Implementing Log Shipping Implementing Database Mirroring Implementing Failover Clustering Designing a High-Availability Strategy Lab: Designing a High-Availability Solution for SQL Server 2008 Designing a High-Availability Strategy Implementing Database Mirroring Designing a Failover Cluster
Module 12: Designing a Backup and Recovery Strategy for SQL Server 2008
Planning a Backup Strategy Planning a Recovery strategy Designing a Backup and Recovery Strategy Implementing a Repair Strategy Lab: Designing a Backup and Recovery Strategy for SQL Server 2008 Designing a Backup and Recovery Solution Backing up a Database Restoring a Database by Using Online Operations Restoring a System Database |