Microsoft® SQL Server® 2008 Internals
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:
- Architecture and Configuration
- Tracing and Event Tracking
- Databases and Database Files
- Logging and Recovery
- Indexes: Internals and Management
- Special Storage
- The Query Optimizer
- Plan Caching and Recompilation
- Transactions and Concurrency
- 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
Curriculum includes extensive demonstrations that illustrate
the details of SQL Server internals as well as performance tuning
Customized classes and shorter seminars are also
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
"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,
"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. :-)"