Session Details

View all Conference Sessions

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

Peter Shore
75 minutes
100
Data Management
DBA, Database Developer, IT Pro
Database Administration
Perform
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.
None

cage-aids
cage-aids
cage-aids
cage-aids