After running through the prep-guide (looking through a pair of SQL Server 2005 glasses), I identified a couple of topics worth giving a closer look. The topics are derived from the prep-guide, my comments about the topic added in blue italics and the bulleted list refers to (mostly) BOL-resources. This post is based on the prep-guide for 70-432 with published date June 11, 2008
Installing and Configuring SQL Server 2008 (10 percent) Configure additional SQL Server components. This objective may include but is not limited to: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), replication. Not that I expect this to be really different from SQL Server 2005, but if your background is just DBA (MCTS/MCITP) it may be your first encounter with the BI-components. Considerations for Installing Integration Services Considerations for Installing Analysis Services Considerations for Installing Reporting Services Maintaining SQL Server Instances (13 percent) Implement the declarative management framework (DMF).This objective may include but is not limited to: create a policy; verify a policy; schedule a policy compliance check; enforce a policy; create a condition. Administering Servers by Using Policy-Based Management Entry page, includes tutorial. Oh, DMF = Policy-Based Management... stupid MS-Name-Game. Back up a SQL Server environment. This objective may include but is not limited to: operating system-level concepts. I don't expect a lot of fireworks, but the operating system-level concepts made me curious. Planning for Disaster Recovery Actually, I'm still curious what is meant by operating system-level concepts. This link from BOL is actually my best shot at a document where some broader considerations are presented. Managing SQL Server Security (15 percent) Manage transparent data encryption.This objective may include but is not limited to: impact of transparent data encryption on backups. Database Encryption in SQL Server 2008 Enterprise Edition General overview of encryption, how TDE fits in and some remarks on how backup is affected. Since the topic says "not limited to", consider the whole article to be valuable. Maintaining a SQL Server Database (16 percent) Back up databases.This objective may include but is not limited to: full backups; differential backups; transaction log; compressed backups; file and filegroup backups; verifying backup. Only compressed backups is to be classified as new. Backup Compression (SQL Server) Performing Data Management Tasks (14 percent) Implement data compression.This objective may include but is not limited to: sparse columns; page/row. Using Sparse Columns Using Column Sets Maintain indexes.This objective may include but is not limited to: create spatial indexes; create partitioned indexes; clustered and non-clustered indexes; XML indexes; disable and enable indexes; filtered index on sparse columns; indexes with included columns; rebuilding/reorganizing indexes; online/offline. Spatial and filtered indexes on sparse columns are of interest here, along with "is not limited to" which could be indexes on hierarchyid columns. Working with Spatial Indexes (Database Engine) Entry Page Filtered Index Design Guidelines Using hierarchyid Data Types (Database Engine) includes Tutorial Optimizing SQL Server Performance (10 percent) Implement Resource Governor. Managing SQL Server Workloads with Resource Governor Entry page, includes How-To Use Performance Studio. Data Collection Entry page, includes How-To Again, Performance Studio, also an MS-Name-Game, what you're really looking for is Data Collection... and trying to get that confirmed, I found this webcast by Bill Ramos (62 minutes).
Installing and Configuring SQL Server 2008 (10 percent)
Configure additional SQL Server components. This objective may include but is not limited to: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), replication. Not that I expect this to be really different from SQL Server 2005, but if your background is just DBA (MCTS/MCITP) it may be your first encounter with the BI-components.
Maintaining SQL Server Instances (13 percent)
Implement the declarative management framework (DMF).This objective may include but is not limited to: create a policy; verify a policy; schedule a policy compliance check; enforce a policy; create a condition.
Back up a SQL Server environment. This objective may include but is not limited to: operating system-level concepts. I don't expect a lot of fireworks, but the operating system-level concepts made me curious.
Managing SQL Server Security (15 percent)
Manage transparent data encryption.This objective may include but is not limited to: impact of transparent data encryption on backups.
Maintaining a SQL Server Database (16 percent)
Back up databases.This objective may include but is not limited to: full backups; differential backups; transaction log; compressed backups; file and filegroup backups; verifying backup. Only compressed backups is to be classified as new.
Performing Data Management Tasks (14 percent)
Implement data compression.This objective may include but is not limited to: sparse columns; page/row.
Maintain indexes.This objective may include but is not limited to: create spatial indexes; create partitioned indexes; clustered and non-clustered indexes; XML indexes; disable and enable indexes; filtered index on sparse columns; indexes with included columns; rebuilding/reorganizing indexes; online/offline. Spatial and filtered indexes on sparse columns are of interest here, along with "is not limited to" which could be indexes on hierarchyid columns.
Optimizing SQL Server Performance (10 percent)
Implement Resource Governor.
Use Performance Studio.
The rest, well it is all too familiar from SQL Server 2005. Sure, I'll look for some "What's new" resources, but I think the above pretty much covers what I need to familiarize my self with.