How to Think Like the SQL Server Engine: Slide Version (Morning)

You’re comfortable writing queries to get the data you need.
But you’re UNcomfortable if someone asks you how it works, how SQL Server and Azure SQL DB turn your queries into results. You know there are execution plans, but … you’re uncomfortable reading them. You know queries need indexes, but you’re not sure which columns to put in order, or how SQL Server chooses between them.
I’d like to teach you How to Think Like the SQL Server Engine for free.
In a 2-hour live session, you’ll learn the differences between clustered & nonclustered indexes, why seeks aren’t necessarily good and scans aren’t necessarily bad, why queries run so much faster in development than production, and much more. I wanted to design the most important concepts you could learn in your first 2-hour training session - whether you’re a developer, report writer, sysadmin, or DBA.

[@musicxfiascos]

Brent, you are an excellent teacher! I wish I'd found you when I first started learning SQL. Thank you so much for putting together these resources!

[@BrentOzarUnlimited]

You're very welcome!

[@ahappierworld8819]

Great topic! I also like the analogies used in making things easier to understand 😅

[@BrentOzarUnlimited]

Thanks, glad you liked it!

[@lucasshipsides1510]

super appreciative for you and all of the content you produce. many thanks Brent!

[@BrentOzarUnlimited]

My pleasure!

[@ManishKaushik-be5mu]

The joke about the temp = Public toilet, oh my God :)

[@BrentOzarUnlimited]

Hee hee!

[@JacobHorwath]

It was two minutes, five minutes ago!

[@BrentOzarUnlimited]

Hahaha, I love that scene.