SQL Internals Viewer is a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored.
All sorts of tasks performed by a DBA or developer can benefit greatly from knowledge of what the storage engine is doing and how it works. This tool has been designed to make database internals more accessible.
The Quick Start section gives a guide on how to use SQL Internals Viewer.
The Resources section lists articles and books with information on SQL Server internals.