SQLskills
SQL MCM
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
Microsoft Certified Master
SQLskills SQL Server Online Training - Links and Study Aids


Introduction

Thank you for watching the online training modules!

This web page contains links to further study aids for each of the online training modules to help you study for the Microsoft Certified Master - SQL Server certification. 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.

SQLskills provides 4 weeks of training that can help you prepare for the MCM certification, as well as provide any DBA with a wealth of knowledge that can immediately be put to use. Details of the training classes we provide are here.

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 More Webcasts 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 & 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 & 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 Tracking, CDC, iFTS

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 Websites 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 DDM Tool
  • The DDM tool from the demos is available here
  • .
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

Whitepapers 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

Books
Whitepapers Blog Posts/Categories Wikis/Community Articles Websites
SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































SQLskills Insider

Become a SQLskills Insider for lots of exclusive content and we'll send you a sticker!


"Overall, I think anyone who works professionally with SQL Server should come to this training, even if they have to pay for it themselves."

Eric Maibach



Quick Links

Paul’s Blog
Kimberly’s Blog
Jonathan’s Blog
Joe’s Blog
Bob's Blog

Follow us on Twitter!

Immersion Events Schedule









































Privacy Policy.
All Rights Reserved.
Copyright 2011 SQLskills.com
sqlskills.com
Events in Seattle Washington