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

Explore the inner workings of SQL Server in this comprehensive conference talk from PASS Data Community Summit. Delve into SQL Server Internals to understand what happens when executing queries, applicable to Azure VMs, SQL DB, AWS, GCP, and on-premises environments. Discover the importance of data types, learn about pages and the storage engine, and gain insights into the query processor. Enhance your query writing and tuning skills by understanding the underlying mechanisms of SQL Server, regardless of your deployment platform.

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