How to Think Like the SQL Server Engine: Demo 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.

[@gauravtiwari6392]

Hello Brent,
Really nice videos you've got there. You're a great orator.
I really wanted to know based on your overall years of experience, can you create a pie chart for creating distribution of most important points (as labels) and their weightage (as percentage) when it comes to performance tuning and optimization?
Also, if I am asking too much over here, then please reply over here in comment section like the following.
Indexes : 25%, statistics : 35% and so on ....
Thank you for the work that you put in. :)

[@BrentOzarUnlimited]

Howdy! thanks, glad you like my work. I don't really have a chart like that, but best of luck on your tuning!

[@shubhamshah349]

Can we have a video explaining SQL server pricing and differences/use-cases of different editions?

[@BrentOzarUnlimited]

For unrelated questions, check out: pollgab.com/room/brento/