** IDPA-Des Moines will meet virtually in June 2021. There will be no meeting in-person until it is safe again after COVID-19 **

Join us at 17:30 CDT/22:30 UTC (aka 5:30 PM in Des Moines, IA) for social discussion, networking, etc.

A technical presentation by Peter Shore will follow at 18:00 CDT/23:00 UTC (6:00 PM)

Title: A Query Runs Through It: An Introduction to the SQL Server Engine
Level: 200

Summary:
A query is executed, results are returned. Have you ever wondered what happens behind the scenes once the query is started? Pull back the curtain with this introduction to SQL Server internals.

Abstract:
Have you ever wondered what happens inside SQL Server when you execute that query you wrote? This session will serve as an introduction to what is going on under the hood, commonly called SQL Server Internals. Whether writing queries or tuning them, SQL Server internals knowledge is highly valuable in Azure VMs or SQL DB, AWS, GCP, and on-premises as the SQL Server engine is the same. Together we will dip into why data types matter, ponder pages, sample the storage engine, and ponder the query processor as we see what happens when your query runs.

Speaker Bio:

Peter is a seasoned IT professional with over 25 years of experience, a frequent speaker at SQL Saturday, User Groups, and other conferences. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.
Additionally, Peter is the president of CBusPASS in Columbus, Ohio and co-organizer of SQL Saturday Columbus.