Data File Autopsy

Understanding how SQL Server organizes your data can seem like a daunting task. But we will make it fun by telling humorous stories from my past as we explore the guts of a SQL Server database.

You’ll hear how these concepts tie into your work as a DBA or developer. You’ll get to see the concepts in action through demos and learn how you can use this knowledge to design better solutions. We will also demo and look at some neat tools to help you dig in and learn further.

We will cover the following:
• The three basic types of storage in SQL Server (Allocation Units)

• The physical structure of rows and pages

• Differences in how SQL Server works with heaps and clustered indexes

• How pages are allocated and tracked

• How to use various tools to continue your learning

Time: 12:15 – 12:35

Room: Backstage

Session format: Thrash Metal (20 Minutes)

Session level: Debut Album (200)

Head back to Homepage

Brandon Leach

Microsoft Data Platform MVP

A Microsoft Data Platform MVP, Brandon is a senior member of the Database team for financial company x functioning as a SQL Server Infrastructure Architect/SME. Having worked in data estates of several petabytes across thousands of servers, he puts a high focus on performance tuning and automation at scale. He is a frequent speaker at events like conferences and user groups.