SQL Server 2008 Course Outline Module 1: Introduction to SQL Server 2008 (0900 – 0945) The Evolution of SQL Server Preparing for SQL Server 2008 Module 2: SQL 2008 Manageability Enhancements (0950 – 1045) Configuration Servers Policy-Based Management Lab: Managing SQL Server 2008 Creating a Configuration Server Creating and Applying a Policy Module 3: SQL 2008 Performance Enhancements (1100 – 1230) Managing Workloads with Resource Governor Monitoring Performance with the Data Collector Managing Performance with Plan Freezing Lab: Optimizing SQL Server 2008 Using Resource Governor Using the Data Collector Module 4: SQL 2008 Security Enhancements (1330 – 1445) Encrypting Databases Auditing All Actions Lab: Securing a SQL Server 2008 Database Using Transparent Data Encryption Module 5: SQL 2008 Availability Enhancements (1500 – 1600) Always On Technologies Transactional Peer-to-Peer Replication Lab: Maintaining High Availability Configuring Peer-to-Peer Replication Adding a Replication Node