SQL Server Databaseology: A Deep Dive Into Database Internals
1720 West Rio Salado Pkwy
Tempe, AZ 85281
Please enter the North-East side of the building into the auditorium area as the main entrance (center on the North side) will be closed.
Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge that will allow you to build better and faster databases.
John Morehouse is currently a Consultant with Denny Cherry & Associates living in Louisville, Kentucky. John lead the Omaha SQL Server user group for 7 years and is now a leader of the Louisville SQL Server/Power BI user group. He is honored to be a Microsoft Data Platform MVP, 2016 Idera Ace, Friend of Red Gate since 2015, Sentry One PAC member & Community Ambassador. He is also a blogger, avid tweeter, and a frequent speaker at SQL Saturday’s as well as other conferences. In his spare time, you can usually find John on Twitter (@sqlrus) as well as chasing his two young sons around the house.
• 5:30-6:00pm: Sign-in & network
• 6:00-6:15pm: Announcements & Intro
• 6:15-7:15pm: Presentation
• 7:15-7:30pm: Q&A, wrap-up, clean-up