SQL Server MCM Training Videos – Further Reading

INTRODUCTION

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

Websites


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

Websites


SQL AZURE

Blog Posts/Categories

Wikis/Community Articles

Websites


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