# Tuesday, 17 June 2008

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.

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.

  • 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.

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.

  • 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).

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.

Technorati tags: , ,
Monday, 14 July 2008 00:50:21 (W. Europe Daylight Time, UTC+02:00)
Great write up. I'm going through the prep-guide as well and your links are very useful. I suspect operating level concepts could be related to the new Filestream data type that store large files in the NTFS file system instead of in the actual database files: http://msdn.microsoft.com/en-us/library/bb933993(SQL.100).aspx
Thursday, 17 July 2008 14:45:35 (W. Europe Daylight Time, UTC+02:00)
Thanks Magnus,

Well after having sat the exam, I'm still in the dark about operating system-level concepts. Though I can tell it has nothing to do with FILESTREAM... I didn't get any questions on FILESTREAM.

What I do want to add is two topics I overlooked when preparing:
Creating and Managing Audits with Transact-SQL (http://msdn.microsoft.com/en-us/library/cc280665(SQL.100).aspx, http://msdn.microsoft.com/en-us/library/cc280526(SQL.100).aspx)
DBCC CHECKDB EXTENDED_LOGICAL_CHECKS (http://msdn.microsoft.com/en-us/library/ms176064(SQL.100).aspx)

For the rest, some useless questions regarding system stored procedures and system views. Like would you know from the top of your head the differences (and overlap) between xp_msver, sp_server_info and @@VERSION. I don't and can honestly say I'd look xp_msver and sp_server_info up in BOL.
Comments are closed.