SQL Server MCM Training Videos – Further Reading

INTRODUCTION

(Edit 2017: Some of these resources may be quite far out-of-date, as this list has not been maintained since 2012 when the MCM program was cancelled by Microsoft.)

This web page contains links to further study aids for each of the training videos to help you study for the Microsoft Certified Master – SQL Server 2008  and 2012 certifications. These blog posts, Whitepapers, and other recordings are from a variety of sources that we trust and recommend to our customers. Note that there are no references to SQL Server 2008 Books Online – an MCM candidate should be able to find appropriate BOL topics. Also note that this is not an exhaustive list.

This is just a small taster of what you need to know. We offer a comprehensive online and in-person training program that will help you towards your MCM/MCSM certification, as well as provide any DBA with a wealth of knowledge that can immediately be put to use.

Thanks, Paul and Kimberly


DATABASE STRUCTURES

Books

  • SQL Server 2008 Internals – Ch 3, 5 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Blog Posts/Categories


NEW DATABASE STRUCTURES IN 2008

Books

  • SQL Server 2008 Internals – Ch 7 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Whitepapers

Blog Posts/Categories


DATA FILE INTERNALS AND MAINTENANCE

Books

  • SQL Server 2008 Internals – Ch 3 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Whitepapers

Blog Posts/Categories


LOG FILE INTERNALS AND MAINTENANCE

Books

  • SQL Server 2008 Internals – Ch 4 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Blog Posts/Categories

Magazine Articles

Community Articles


INDEX INTERNALS

Books

Blog Posts/Categories


CLUSTERED INDEX DEBATE

Books

  • SQL Server 2008 Internals – Ch 6 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Blog Posts/Categories

Whitepapers


STATISTICS

Books

  • SQL Server 2008 Internals – Ch 8 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)
  • SQL Server 2008 Query Performance Tuning Distilled – Ch 7 (APress, Apress, Grant Fritchey and Sajal Dam)

Blog Posts/Categories

Whitepapers


INDEXING STRATEGIES

From the video:

Blog Posts/Categories


INDEX ANALYSIS

Whitepapers

Blog Posts/Categories

Other Links


LOCKING

Books

  • SQL Server 2008 Internals – Ch 10 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)
  • SQL Server 2008 Query Performance Tuning Distilled – Ch 12-13 (APress, Apress, Grant Fritchey and Sajal Dam)

Blog Posts/Categories


SNAPSHOT ISOLATION

Whitepapers


INDEX FRAGMENTATION

Books

  • SQL Server 2008 Internals – Ch 6 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)
  • SQL Server 2008 Query Performance Tuning Distilled – Ch 8 (APress, Apress, Grant Fritchey and Sajal Dam)

Whitepapers

Blog Posts/Categories


BACKUP INTERNALS & RESTORE INTERNALS

Whitepapers

Blog Posts/Categories

Magazine Articles

Community Articles


CONSISTENCY CHECKING

Books

  • SQL Server 2008 Internals – Ch 11 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Blog Posts/Categories

Websites


DATABASE SNAPSHOTS

Books

  • SQL Server 2008 Internals – Ch 3 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Whitepapers

Blog Posts/Categories


PARTITIONING/PARTIAL DATABASE AVAILABILITY/PIECEMEAL RESTORE

Resource List

Whitepapers

Books Online (Yes I know I said no BOL, but this is the only place it’s described in detail)


OPTIMIZING STORED PROCEDURES

Books

  • SQL Server 2008 Internals – Ch 9 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Whitepapers

Blog Posts/Categories

Community Articles


SPARSE COLUMNS

Books

  • SQL Server 2008 Internals – Ch 7 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Blog Posts/Categories


WAITS AND QUEUES

Whitepapers

Blog Posts/Categories

Wikis/Community Articles

Websites


EXTENDED EVENTS

Books

  • SQL Server 2008 Internals – Ch 2 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Whitepapers

Blog Posts/Categories

Magazine Articles


BENCHMARKING AND BASELINING

Books

  • Professional SQL Server 2008 Internals and Troubleshooting – Ch 9-13 (Wiley/WROX, Christian Bolton, Brent Ozar, et al)
  • SQL Server 2008 Query Performance Tuning Distilled – Ch 2 (APress, Apress, Grant Fritchey and Sajal Dam)

Whitepapers

Blog Posts/Categories

Wikis/Community Articles

Websites


XML

Books

  • Pro SQL Server 2008 XML (APress, Michael Coles)
  • A Developer’s Guide to SQL Server 2005 – Ch 9-10 (Addison-Wesley, Bob Beauchemin and Dan Sullivan)
  • Essential XML Quick Reference (Addison-Wesley, Aaron Skonnard and Martin Gudgin) Note: not SQL Server-specific
  • The Art of XSD – SQL Server XML Schema Collections (Red Gate Books, Jacob Sebastian)

Whitepapers

Blog Posts/Categories

Wikis/Community Articles


SQL CLIENT

Books

  • A Developer’s Guide to SQL Server 2005 – Ch 13-14 (Addison-Wesley, Bob Beauchemin and Dan Sullivan)

Whitepapers

Blog Posts/Categories


CLR

Books

  • A Developer’s Guide to SQL Server 2005 – Chapters 2-6 (Addison-Wesley, Bob Beauchemin and Dan Sullivan)
  • Customizing the Microsoft .NET Framework Common Language Runtime (Steven Pratschner)
  • Expert SQL Server 2005 Development – Chapter 6 (APress, Adam Machanic, et al)

Whitepapers

Blog Posts/Categories

Magazine Articles

  • Create a User-Defined Data Type (Dan Sullivan, SQL Server Magazine, May 2004)

CHANGE DATA CAPTURE

Books

  • Inside Microsoft® SQL Server® 2008: T-SQL Programming, Ch 15 (Microsoft Press, chapter by Greg Low)

Whitepapers

Blog Posts/Categories

Magazine Articles


CHANGE TRACKING

Books

  • Inside Microsoft® SQL Server® 2008: T-SQL Programming, Ch 15 (Microsoft Press, chapter by Greg Low)

Blog Posts/Categories

Magazine Articles

Websites


FULL-TEXT SEARCH

Whitepapers

Blog Posts/Categories

Websites


CLUSTERING

Books

  • Pro SQL Server 2008 Failover Clustering (APress, Allan Hirt)

Whitepapers

Blog Posts/Categories


SQLOS

Books

  • SQL Server 2008 Internals – Ch 1 (Microsoft Press, Kalen Delaney, Paul S. Randal, Kimberly L. Tripp, et al)

Whitepapers

Blog Posts/Categories


DATABASE MIRRORING

Books

  • Pro SQL Server 2008 Mirroring (APress, Ken Simmons and Robert L. Davis)

Whitepapers

Blog Posts/Categories

Websites


DESIGNING AN AVAILABILITY STRATEGY

Books

  • Pro SQL Server 2005 High Availability (APress, Allan Hirt)

Whitepapers

Blog Posts/Categories


SECURITY: EXECUTE AS

Books

  • Writing Secure Code (Microsoft Press, Michael Howard, David LeBlanc)

Tools

Blog Posts/Categories

Community Articles


SPATIAL

Books

  • Beginning Spatial with SQL Server 2008 (APress, Alastair Aitchison)
  • Inside Microsoft® SQL Server® 2008: T-SQL Programming, Ch 14 (Microsoft Press, chapter by Ed Katibah and Isaac Kunen)

Whitepapers

Blog Posts/Categories

Magazine Articles


POLICY-BASED MANAGEMENT

Books

  • Pro SQL Server 2008 Policy-Based Management (APress, Ken Simmons, Colin Stasiuk, Jorge Segarra)

Whitepapers


RESOURCE GOVERNOR

Whitepapers


SERVICE BROKER

Books

  • The Rational Guide to SQL Server 2005 Service Broker (Rational Guides, Roger Wolter)
  • Pro SQL Server 2008 Service Broker (APress, Klaus Aschenbrenner)
  • A Developer’s Guide to SQL Server 2005 – Ch 11 (Addison-Wesley, Bob Beauchemin and Dan Sullivan)

Whitepapers

Blog Posts/Categories


REPLICATION

Books

  • Pro SQL Server 2005 High Availability (APress, Allan Hirt)

Whitepapers

Blog Posts/Categories


SQL AZURE

Blog Posts/Categories

Wikis/Community Articles


SECURITY – ALL MODULES

Whitepapers

Blog Posts/Categories

Articles

Websites


VIRTUALIZATION

Books

  • Virtualizing Microsoft Tier 1 Applications with VMware vSphere 4 (Sybex, Charles A. Windom et al)

Whitepapers

Blog Posts/Categories

Wikis/Community Articles

Websites


CONSOLIDATION

Whitepapers

Websites


IO

Whitepapers

Blog Posts/Categories

Wikis/Community Articles

Websites