MOC 6158: Updating your SQL 2005 skills to p g y Q SQL 2008

Contents

Module 1: Introduction to SQL Server 2008

• The Evolution of SQL Server
• Preparing for SQL Server 2008

Module 2: SQL Server 2008 Manageability Enhancements

• Configuration Servers
• Policy-Based Management

Module 3: SQL Server 2008 Performance Enhancements

• Managing Workloads with Resource Governor
• Monitoring Performance with the Data Collector
• Managing Performance with Plan Freezing

Module 4: SQL Server 2008 Security Enhancements

• Encrypting Databases
• Auditing All Actions

Module 5: SQL Server 2008 Database Development Enhancements

• Developer Tool Enhancements
• Data Type Enhancements
• Working with Spatial Data

Module 6: SQL Server 2008 Availability Enhancements

• Always On Technologies
• Transactional Peer-to-Peer Replication

Module 7: SQL Server 2008 Data Warehousing Enhancements

• ETL Enhancements
• Using Partitioned Tables
• Optimizing Data Storage

Module 8: SQL Server 2008 Reporting Services Enhancements

• Reporting Services Architecture and Management
• Authoring Reports
• Report Processing and Rendering

Module 9: SQL Server 2008 Analysis Services Enhancements

• Multidimensional Analysis with SQL Server Analysis Services
• Data Mining with SQL Server Analysis Services