Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose.
This week is Fundamentals of Index Tuning. To follow along with the labs this week & next week, you’ll need SQL Server 2017 or newer, with the most recent Cumulative Update, the most recent SQL Server Management Studio, and the 50GB Stack Overflow 2013 database (10GB 7z file, extracts with 7-zip.) You don’t have to follow along with the labs, but I highly encourage it.
- Oct 3 – How to Design Indexes for Equality and Inequality Searches
- Oct 4 – Lab: Design Indexes for WHERE and My Solution
- Oct 5 – How to Design Indexes for ORDER BY
- Oct 6 – Lab: Design Indexes for WHERE + ORDER BY and My Solution
- Oct 7 – How to Design Indexes for JOINs
Make sure to keep up – next week, we’ve got Fundamentals of Query Tuning coming fast & furious.
These are recordings of live classes. In the live class, the questions & chat take place over Slack. You don’t need to join the Slack – I only monitor that chat room during the live classes. (I’m on vacation in New York at the moment, heh.)
Eagle-eyed readers will note that this isn’t all of the modules from each class, nor is it all of my Fundamentals classes. That’s because this whole thing is a diabolical mind trick, dear reader. I aim to get you hooked on the quality of my online training, and then come November 1st, when my annual Black Friday sale starts, you’ll be ready to get out your wallet – or your boss’s wallet – to get a Recorded Class Season Pass: Fundamentals, or Mastering, or the Level 2 Bundle when they go on sale.
18 Comments. Leave new
Brent – love that you are doing this. Thank you. Just so you know, it looks like we can access the content for multiple days (instead of just today).
And looking ahead for tomorrow (since I already started watching that video), is it possible to get a copy of the lab so we can follow along?
Howdy! Read what’s on the page – the lab is there. Cheers!
At what time are those opening? I am from Finland
They’re already open. I am from the United States.
Mercy to reactivate the first session? 🙁
Nope. You snooze, you do the opposite of win.
Hi Brent – learning so much. Thank you for putting this out for free this month!!
ORDER BY labs are not open. I’ve just done the tutorial. I am from New Zealand 🙂
duh – tutorials are tomorrow
Ayup
I do not get the logic. Orderby class was available yesterday, but orderby labs are still not open. It would be nice to give exact dates and times so one do not have to go there many times to try if those are open
Vesa, lemme get this straight.
The list above shows exactly which days, which posts will be available.
Right now, it’s Oct 5, and the free training classes for both Oct 4 and 5 are both available, because I’m a nice guy.
You, Vesa, can take a long walk off a short pier. It’s people like you that make me want to shut down this blog, delete all the posts, and throw you a giant middle finger.
Beat it, you ungrateful jerk. You’re not welcome here. Goodbye.
Could there be some kind of timezone confusion here or do you operate a very broad definition of “6th October”.
Currently, in the UK, it’s 6th Oct and has been for over 8 and a half hours. I currently see the first course for 6th Oct open (the 1.5 minute “here is what you are going to do lab session”) but not the solutions. Is something triggered based upon a US timezone or similar?
Thanks
I set the previews when I wake up. I apologize deeply for sleeping in. I shall never let it happen again, Steve. Now, if you’ll excuse me, I’m going to go have a drink.
No need to apologise, especially sarcastically and spelled incorrectly 🙂 but a clarification on the page that the the courses might not be available until US daytime would remove some confusion for your “world outside north america” potential clients.
I hope you enjoy the free training, Steve. You’re welcome. Have a great day.
vesa, you can find the list of all resources if you click the Home button ( https://training.brentozar.com/p/fundamentals-of-index-tuning ). Everything with a red PREVIEW button is available. order by solutions not yet available.
When is the November sale starting from (Black Friday one) (If it is). Looking forward towards it
Keep your eyes peeled on the blog. Cheers!