How about some completely free SQL Server training?
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.
To prep, block out a 30-minute window on your calendar, right now. Put a label on it, and bookmark this page. Each day, come back to this page, click on the day’s module, and get your learn on. Here’s what you’ll learn:
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
Fundamentals of Query Tuning
- Oct 10 – Building a Query Plan
- Oct 11 – How to Find the Right Queries to Tune
- Oct 12 – How Parameters Influence Cached Plans
- Oct 13 – Improving Cardinality Estimation Accuracy
- Oct 14 – Common T-SQL Antipatterns
Fundamentals of Columnstore
For this class, you don’t have hands-on labs, and you’re not meant to follow along with the demos. Columnstore is about bigger data, so I use the 2018-06 ~180GB copy of Stack Overflow (info page.) You definitely don’t need to grab that, but I’m mentioning it here in case you want to follow along with the demos.
- Oct 17 – How Columnstore Data is Stored
- Oct 18 – How Columnstore Data is Deleted, Updated, and Inserted
- Oct 19 – How Columnstore Data is Selected
- Oct 20 – How Columnstore Data is Rebuilt
- Oct 21 – Clustered Recap and Nonclustered Columnstore Indexes
Fundamentals of TempDB
For this class, you don’t have hands-on labs, but if you want to follow along with the demos, I’ll be using the same 50GB Stack Overflow 2013 database we used during the first two weeks.
- Oct 24 – How the Version Store Affects TempDB
- Oct 25 – How Temp Tables are Different from Regular Tables
- Oct 26 – How Table Variables Can Be Better Than Temp Tables
- Oct 27 – Temp Tables & Table Variables at Scale: PFS/GAM/SGAM Contention
- Oct 28 – How Memory-Optimized Table Variables Reduce Contention
- Oct 31 – How Execution Plans Use TempDB
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.
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.)
Now go block out a recurring 30-minute window in your calendar every weekday in October. See you in class!