How to Think Like the SQL Server Engine: Demo Version (Afternoon)

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.

[@mortezasafaee6981]

Hi brent if is it possible make video for how to think like postgresql...

[@romanzaytsev5527]

Hi Brent, it looks that you are not famous enough yet for Google Gemini to know what you think about it. But keep on good work ! And thanks for the informative and entertaining videos.

[@BrentOzarUnlimited]

Glad you liked it!

[@arkayerdota2462]

Sir, i would like to know if you have an idea on how to monitor the 25 servers that are already merged/replicated? What I'm only using is the Replication Monitor. SQL Server 2019

[@BrentOzarUnlimited]

I don't do replication, unfortunately.