Live online · Registration open through Nov 30
Four live class weeks of SQL Server performance tuning, with me answering questions as we go. Registration closes Nov 30; after that, it’s recordings only until next year.
2d 23h 07m Until the live classes start · Nov 2, 9 AM Pacific
$4,395
$995
Black Friday price
Live Class Season Pass 2027 · Save $3,400
Plus a Monday roundup of my favorite database news from around the web.
Find out free with sp_Blitz and the First Responder Kit — trusted by DBAs everywhere.
Download the kitNeed hands-on help? SQL Critical Care® — my 2-day server assessment that finds the root cause and hands you the fix.
See consultingHugo Kornelis is a database consultant in the Netherlands. Here are a few of his sites that you might recognize: SQLServerFast.com - his useful and insightful blog The Execution Plan Reference - the only exhaustive, detailed explanation I'm aware of for every execution plan operator, well above and beyond Microsoft's documentation Hugo's execution plan classes…
Let's say you're working with a big copy of the Stack Overflow database, and you wanna get all the users, like for a data export. SQL Server doesn't parallelize this query, not even if you use the query hint that asks for a parallel plan:
[crayon-6ae468c7e0375728358237/]
I just got done with another rotation of my Mastering classes, so if you've got a membership to those recordings, it's time to head in and watch the changed modules. This is especially true if you've got an annual subscription, and you're planning on canceling this November before your renewal hits - get in there now and watch the new stuff before your membership expires!
The winter rotation of my live online classes starts next week:
Fundamentals Week - Nov 2-6
Mastering Index Tuning - Nov 30-Dec 4
Mastering Query Tuning - Jan 11-15
Mastering Server Tuning - Feb 8-12
