Resources

SQL Internals Viewer Specific

SQL Internals Viewer feature on LearnSQLServer.com (Requires subscription)

SQL Server Central Article

Websites

Pages General

Books Online - Pages and Extents

SQL Server Storage Engine (Paul Randal) - What are pages?

SQL Server Storage Engine (Paul Randal) - What are extents?

SQL Server Magazine (Kalen Delaney) - Using DBCC PAGE (Requires subscription)

GAM, SGAM, and PFS Pages

Books Online - Managing Extent Allocations and Free Space

SQL Server Storage Engine (Paul Randal) - Under the covers - GAM, SGAM, and PFS pages

SQL Server Magazine (Kalen Delaney) - The New Space Management (Requires subscription)

SQL Server Magazine (Kalen Delaney) - Mixed Extent Usage (Requires subscription)

IAM Pages

Books Online - Managing Space Used by Objects

SQL Server Storage Engine (Paul Randal) - Under the covers - IAM chains in SQL Server 2000

SQL Server Storage Engine (Paul Randal) - Under the covers - IAM chains and allocation units in SQL Server 2005

DCM and BCM Pages

Books Online - Tracking Modified Extents

Table and Index Structure

Books Online - Heap Structures

Books Online - Clustered Index Structures

Books Online - Nonclustered Index Structures

SQL Server Storage Engine (Paul Randal) - Poking about with DBCC PAGE (Part 1 of -)

SQL Server Magazine (Kalen Delaney) - Get Into Index Structures (Requires subscription)

Books

Inside SQL Server 2005: The Storage Engine (Kalen Delaney)

This book is highly recommended and is the definitive source for information on SQL Server 2005 internals.

Inside SQL Server 2005: T-SQL Programming and T-SQL Querying (Itzik Ben-Gan)

Two excellent books on T-SQL.

The Guru's Guide to SQL Server Architecture and Internals (Ken Henderson)

SQL Server 2005 Practical Troubleshooting (Ken Henderson)

Blogs

In Recovery...

Microsoft PSS SQL Server Engineers

Tony Rogerson's ramblings on SQL Server

SQL Server Query Processing Team

SQL Server Storage Engine

adam machanic -- data manipulation for fun and profit

Bart Duncan's SQL Weblog

Bob Beauchemin's Blog

Craig Freedman's WebLog

Ian Jose's WebLog

Kalen Delaney

Ken Henderson's WebLog

Kimberly L. Tripp

Slava Oks's WebLog

SQL Programmability & API Development Team Blog

SQL Stuff - Chad Boyd