Ever wonder what goes on under the hood of your SQL Servers? SQL Server is a complicated system. Understanding how your data is actually stored on disk can have a profound effect on the choices you make while designing and architecting a solution. In this session I'll show you how data is physically stored and how choices you make effect performance. We'll look at the structure of rows and data pages, index allocation maps, and the physical differences between heaps and clustered indexes.
Brandon is a veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he fell in love with SQL Server and database development and administration. Currently he manages 100+ SQL Servers for Network Health in Medford, Ma. He works closely with the development and infrastructure teams as well as management in and out of IT to make sure the needs of the business and its future goals are met.