Mastering SQL Server’s Core: A Deep Dive into Internals

John Morehouse

Are you the type who enjoys dismantling gadgets like toasters or alarm clocks to uncover their inner mechanisms? Are you intrigued by the internal operations of SQL Server databases? In this session we will delve into the intricate workings of a SQL Server database, peeling back the layers to reveal its secrets.

We will:
* Examine how rows are physically structured
* Explore the role of pages and extents
* Discover why database design matters

If you’ve ever been curious about how SQL Server works at its core level, this is the session for you. You will better understand how SQL Server stores data, allowing you to build better and faster databases.