MCM SQL Server 2008 reading list

Planning and Design

Infrastructure Planning and Design –

On-disk structures including new in 2008

On Disk Structures –

FileStream –

Spatial Indexes –

Sparse Columns –

Data Compression –

Data Compression : Strategy,Capacity Planning and Best Practices –

Data file maintenance, database snapshots  and tempdb

Shrink –

Database Snapshots –

Database Maintenance –

Working with Tempdb in SQL Server 2005 –

Physical Database Storage Design –

Logging, recovery and log file maintanence

Transaction Logging –

Index internals and fragmentation

Fragmentation –

Indexes from every angle –

Online indexing options in SQL Server 2005 –

Performance And Tuning Optimization

Query tuning through effective indexing strategies –


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s