 |
|
| Home |
|
| Remote DBA Service |
|
| Consulting and Performance |
|
| Server Health Checks |
|
| Training |
|
| Resources |
|
| Calendar |
|
| What our Customers say |
|
| What our Students say |
|
| About SQLskills.com |
 |
|
 |
|
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
|
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
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
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
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
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
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
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
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
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
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
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
|
|
|