Please follow us on twitter to learn about upcoming events: @MainePASS
Please RSVP via Eventbrite!
Do you 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, Brandon will show you how data is physically stored and how choices you make affect performance. We will look at the structure of rows and data pages, index allocation maps, and the physical differences between heaps and clustered indexes.
About Brandon:Brandon is a senior DBA and veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he quickly fell in love with SQL Server database development and administration. Currently he is a senior DBA for SurveyMonkey. He works closely with the development, infrastructure, and management in and out of IT to make sure the needs of the business and its future goals are met.