Inside Microsoft SQL Server(TM) 2005: The Storage Engine

Understanding the internals of storage in SQL Server helps database developers and administrators to better create, maintain, and mine information from enterprise data. This practical, hands-on book focuses on the SQL Server 2005 Storage Engine and delves deep into the structures used for storing data, including files, tables, indexes, and data types. Topics also include security details, with coverage of the new SQL Server 2005 security model, and data protection through the backup and restore algorithms. With pragmatic advice, best practices, extensive code samples, and table examples, developers and database administrators will find the guidance they need to better understand how to build powerful, efficient databases.

Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California. She worked for Sybase in the technical support department and then for five years with the training organization. Kalen was an independent trainer and consultant from 1992 until she helped form Solid Quality Learning in 2002, where she is the CFO and a Principal Mentor. As a consultant, she has worked with both Microsoft Corporation and Sybase Corporations to develop courses and provide internal training for their technical support staff. Kalen has taught Microsoft Official Curriculum courses, as well as her own independently developed courses, to clients around the world. In addition, she has been writing regularly about SQL Server since 1995. She has written two previous versions of INSIDE MICROSOFT SQL SERVER for Microsoft Press. Kalen is also a contributing editor and columnist for SQL Server Magazine and has been a SQL Server Most Valuable Professional since 1995.