Microsoft® SQL Server® 2008 Internals
by Kalen Delaney -
The definitive guide to the internals and architecture of the Microsoft SQL Server 2008 relational database engine.

Offering the guidance developers and database administrators need to understand how SQL Server internal structures affect application development and functionality.

Get the practical guidance needed to understand and maximize the SQL Server architecture, including information about logging and recovery, indexes, tables, transactions and locking, and security.

This complete reference offers numerous code samples, table examples, and practical advice.

Table of Contents:

  1. Architecture and Configuration
  2. Tracing and Event Tracking
  3. Databases and Database Files
  4. Logging and Recovery
  5. Tables
  6. Indexes: Internals and Management
  7. Special Storage
  8. The Query Optimizer
  9. Plan Caching and Recompilation
  10. Transactions and Concurrency
  11. DBCC Internals

Kalen Delaney teaches the most advanced SQL Server courses in the world. Her 5-day course "SQL Server Internals and Tuning" is designed for advanced SQL Server professionals who want to know how SQL Server really works, in order to take maximum advantage of its potential. The course includes extensive demonstrations that illustrate the details of SQL Server internals as well as tuning techniques.

SQL Server Internals and Tuning will be presented on SQL Server 2008 and cover features specific to that version, but much of the information is relevant to SQL Server 2005 as well.

Topics to be covered include: SQL Server Architecture and Metadata Physical Storage Structures Index Design and Tuning Query Processing and Query Plans Optimization and Recompilation Concurrency Control: Locking, Blocking and Row Level Versioning Query Tips and Techniques Troubleshooting Tools

Curriculum includes extensive demonstrations that illustrate the details of SQL Server internals as well as performance tuning techniques.

Customized classes and shorter seminars are also available.

For SQL server consulting or performance tuning services, contact Kalen directly.

What Are People Saying?

Nothing says more about Kalen's instruction, services and seminars like client testimonials:

Paul Nielsen Author Trainer Consultant,
Paul Nielsen Consulting, Inc
www.SQLServerBible.com

"Kalen is the compleat* SQL Server guru. She is ever precise and thorough in her research and explanations. When I have a question regarding SQL Server internals, there's no one I'd rather ask than Kalen. She is always professional, well-spoken, well-spoken of, and one of the best speakers on the SQL Server speaker circuit.

* not a misspelling: Compleat (adj.) 1. with everything included; entire, total. 2. quintessential."

Cindy Gross Support Engineer,
Microsoft Corporation

"Kalen has a gift for explaining complicated things in a simple way. Her demos are very good at showing her point and her way of saying things makes new concepts easy to understand. She's also an all around good person. :-)"