MCM SQL Server 2008 reading list

Planning and Design

Infrastructure Planning and Design – http://www.microsoft.com/en-us/download/details.aspx?id=732

On-disk structures including new in 2008

On Disk Structures – http://www.sqlskills.com/blogs/paul/category/on-disk-structures/

FileStream – http://www.sqlskills.com/blogs/paul/category/filestream/

Spatial Indexes – http://www.sqlskills.com/blogs/paul/sql-server-2008-spatial-indexes/

Sparse Columns – http://www.sqlskills.com/blogs/paul/category/sparse-columns/

Data Compression – http://blogs.msdn.com/b/sqlserverstorageengine/archive/tags/data+compression/default.aspx

Data Compression : Strategy,Capacity Planning and Best Practices – http://sqlcat.com/sqlcat/b/whitepapers/archive/2009/05/29/data-compression-strategy-capacity-planning-and-best-practices.aspx

Data file maintenance, database snapshots  and tempdb

Shrink – http://www.sqlskills.com/BLOGS/PAUL/category/Shrink.aspx

Database Snapshots – http://www.sqlskills.com/BLOGS/PAUL/category/Database-Snapshots.aspx

Database Maintenance – http://www.sqlskills.com/BLOGS/PAUL/category/Database-Maintenance.aspx

Working with Tempdb in SQL Server 2005 – http://technet.microsoft.com/en-us/library/cc966545.aspx

Physical Database Storage Design – http://technet.microsoft.com/en-us/library/cc966414.aspx

Logging, recovery and log file maintanence

Transaction Logging – http://www.sqlskills.com/BLOGS/PAUL/category/Transaction-Log.aspx

Index internals and fragmentation

Fragmentation – http://www.sqlskills.com/BLOGS/PAUL/category/Fragmentation.aspx

Indexes from every angle – http://www.sqlskills.com/BLOGS/PAUL/category/Indexes-From-Every-Angle.aspx

Online indexing options in SQL Server 2005 – http://technet.microsoft.com/en-us/library/cc966402.aspx

Performance And Tuning Optimization

Query tuning through effective indexing strategies – http://www.sqlskills.com/BLOGS/KIMBERLY/category/Indexes.aspx


Microsoft SQL Server Advanced Skills

Having said that Microsoft Master Certifications are retired, this is an interesting page – http://www.brentozar.com/sql-mcm/

Day 3 mentions some interesting skills –

On-disk structure knowledge
Index tuning knowledge
C#/VB knowledge
Stored procedure knowledge
XML parsing knowledge
Backup & recovery knowledge