Data in SQL Server is stored on pages, but what does that mean? What are pages and how are they structured? What are the different types of pages and how are they used to organize data? What are extents and how are they used to organize pages?

This session is a dive into SQL Server storage fundamentals and how this knowledge can be used to make better decisions with regards to files, filegroups, tables, indexes, and more! What starts as a review of pages and their function will quickly evolve into viewing (and understanding) the contents of pages. Also discussed will be corruption, what causes it, and how knowledge of SQL Server data storage can assist in resolving corruption!