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.
I’m teaching the class two different ways: one with slides, and one completely in Management Studio. Both classes cover the same material, but the all-demo version lets me go off on interesting tangents based on your questions. I’d encourage you to attend the slide one first, then circle back for the demo one so that you can really soak in the material and get your questions answered. If you’re busy, and you can only do one, I totally understand!
Slide version, all April 2nd, Tuesday, links are to calendar invites:
- Morning: 9AM-11AM Eastern, 6AM-8AM Pacific
- Afternoon: 1PM-3PM Eastern, 10AM-Noon Pacific
- Evening: 5PM-7PM Eastern, 2PM-4PM Pacific
Demo version, all April 3rd, Wednesday:
- Morning: 9AM-11AM Eastern, 6AM-8AM Pacific
- Afternoon: 1PM-3PM Eastern, 10AM-Noon Pacific
- Evening: 5PM-7PM Eastern, 2PM-4PM Pacific
No registration required – just add the event to your calendar, and at the time of the event, hop into https://www.brentozar.com/training/live/ or my YouTube channel to watch the live stream. See you in class!
6 Comments. Leave new
Nice! I can’t really count anymore how many times I’ve attended this one over the years. I just know I never stop learning from it.
Aww, thanks!
This is a such a helpful and thought out presentation on SQL Server. Thank you.
Thanks for the kind words!
Thank you so much for the opportunity! I’m letting my co-workers know about this!
My pleasure! See ’em there!