Hide Notes 

Slide 1: Microsoft Certified Master: SQL Server 2008 Recommended Pre-Reading List for Attendees Last Updated: March 5, 2009 The Microsoft Certified Master: SQL Server 2008 program covers the comprehensive SQL Server platform. It is a very demanding course and will challenge the limits of most candidates. In order to ensure that candidates are best prepared we provide this list of pre-reading material. It is not a conclusive set of reference material but rather it is intended as a list of pre-readings which provide a baseline for the topics covered during the training rotation. For many, items contained here within will be review. However, each applicant is encouraged to inspect the entire list to ensure they are up to date with the information represented, as it will be needed as a starting basis and referenced throughout the training. ID 1 2 Topic / Resource Planning and Design Infrastructure Planning and Design (SQL Server 2008) Completed? (Y/N) On-disk structures / New on-disk structures in SQL Server 2008 On-disk structures FILESTREAM Spatial Indexes Sparse Columns Data Compression 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Data file maintenance, database snapshots, tempdb Shrink Database Snapshots Database Maintenance Working with Tempdb in SQL Server 2005 Physical Database Storage Design Logging, Recovery, log file maintenance http://www.sqlskills.com/BLOGS/PAUL/category/Transaction-Log.aspx Index internals and fragmentation Fragmentation Indexes from every angle Microsoft SQL Server 2000 Index Defragmentation Best Practices Online Indexing Operations in SQL Server 2005 Performance Tuning and Optimization (PTO) 1|Page
Slide 2: ID 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 Topic / Resource Query Tuning through effective indexing strategies Statistics Used by the Query Optimizer in Microsoft SQL Server 2005 Batch Compilation, Recompilation, and Plan Caching Issues in SQL Server 2005 Database Engine Tuning Advisor (DTA) in SQL Server 2005 SQL Server 2005 Row Versioning-Based Transaction Isolation Partitioned Tables and Indexes in SQL Server 2005 Completed? (Y/N) Backup and Restore Restore internals and procedures CHECKDB from every angle Corruption IO Subsystems Backing Up and Restoring Databases in SQL Server Benchmarking and Baselining – Prerequisites SQL Server Profiler Performance monitoring concepts Pre-deployment IO Best Practices Waits and Queues – Prerequisites SQL Server 2005 Waits and Queues Troubleshooting performance problems in SQL Server 2005 SQL IO Overview of FAT, HPFS, and NTFS File Systems SQL Server 7.0, SQL Server 2000, and SQL Server 2005 logging and data storage algorithms extend data reliability Description of using disk drive caches with SQL Server that every database administrator should know Files and Filegroups Architecture Flash Disk Opportunities for Server Applications RAID Levels and SQL Server Microsoft Support for iSCSI XML XML Support in Microsoft SQL Server 2005 2|Page
Slide 3: ID 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 Topic / Resource XML Options in Microsoft SQL Server 2005 Completed? (Y/N) SQL Client C# Tutorial ADO.net Tutorial (Lessons 1-7) SQL CLR Using CLR Integration in SQL Server 2005 Database Administrator’s Guide to SQL Server Database Engine .NET CLR Environment Spatial Introduction to New T-SQL Programmability Features in SQL Server 2008 Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet Resource Governor / Policy Based Management Introducing Resource Governor Managing SQL Server Workloads with Resource Governor Resource Governor Concepts Replication Replication: SQL Server Replication Replication: Replication Publishing Model Overview Replication: Types of Replication Overview Replication: Replication Agents Overview Service Broker SQL Server Service Broker Overview (Service Broker) What Does Service Broker Do? Typical Uses of Service Broker Security Securing SQL Server Setting Up Windows Service Accounts Security Considerations for a SQL Server Installation High Availability High Availability Solutions Overview 3|Page
Slide 4: ID 63 64 65 66 67 68 69 70 71 72 Topic / Resource Selecting a High Availability Solution Database Mirroring Overview Log Shipping Overview Completed? (Y/N) TempDB Optimizing tempdb Performance Capacity Planning for tempdb SSIS SQL Server Integration Services Security Overview (Integration Services) Integration Services Packages Support for Data Transformation Services (DTS) in SQL Server 2008 Creating Package Configurations 4|Page