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

Advertisements


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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