Main Content

SQL Server Storage Engine and MDF File Internals

A talk by Mark S. Rasmussen

About the Talk

September 6, 2011 9:00 AM

Trifork A/S, Margrethepladsen 4, 8000 Aarhus C

Trifork A/S, Margrethepladsen 4, 8000 Aarhus C

Join me for a journey into the depths of the SQL Server storage engine. Through a series of lectures and demonstrations we'll look at the internals of pages, data types, indexes, heaps, extent & page allocation, allocation units, system views, base tables and nightmarish ways of data recovery. We'll look at several storage structures that are either completely undocumented or very scarcely so. By the end of the day, not only will you know about the most important data structures in SQL Server, you'll also be able to parse every bit of a SQL Server data file yourself, using just a hex editor! There will be lots of hands on demos, a few of them performed in C# to demonstrate the parsing of data files outside of SQL Server.

Ratings and Recommendations

Avg. Rating

Average based
on 5 ratings

comments powered by Disqus