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.

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.

Click here for full course description »

SQL Tuners, LLC specializes in Microsoft RDBMS technologies. We have made our careers in delving into all aspects MS SQL Server and are now making our experience available to the many businesses that choose MS SQL Server as their RDBMS platform of choice. Our fields of expertise include:

  • Storage Engine/Query Optimization/Indexing strategies
  • Performance Architecture for OLTP|DSS design
  • Database Administration

We are dedicated to recruiting, training and providing the best SQL Server expertise in the world: no ASP, C#, or Java - we are pure SQL Server and we do what we do extremely well.