How SQL Server stores data on a binary level
You may think that there is much in SQL Server that appears to work as if by magic? And you would be right! But despite this magic, everything is actually quite easy to understand. This 500-level report contains information about the internal data storage format in SQL Server (MDF files), as well as about how you can work with the data using only a hex editor. You will learn about how SQL Server stores internal metadata for objects and about how you can find and read the data on the disk.