The first class is my How to Think Like the Engine class. It’s already free online in both video and blog post formats, but this fall I’m updating and expanding it to a 3-hour version. You could totally start watching the recorded version now, but…I know how it is. Some folks prefer watching live because they can ask questions as I go along:
- Oct 12: How to Think Like the Engine (Europe-friendly time)
- Oct 13: How to Think Like the Engine (America-friendly time)
Now, we start getting to the fun stuff – things that normally cost $89 for each class’s recordings. These are all-day classes. On Tuesdays, I’m teaching them in Europe-friendly times, and on Wednesdays, I repeat the same class in America-friendly times.
- Oct 19: How I Use the First Responder Kit (Europe-friendly time)
- Oct 20: How I Use the First Responder Kit
- Oct 26: Fundamentals of Index Tuning (Europe-friendly times)
- Oct 27: Fundamentals of Index Tuning
- Nov 2: Fundamentals of Query Tuning (Europe-friendly times)
- Nov 3: Fundamentals of Query Tuning
- Nov 16: Fundamentals of Columnstore (Europe-friendly times) – Prerequisites
- Nov 17: Fundamentals of Columnstore – Prerequisites
- Nov 23: Fundamentals of TempDB (Europe-friendly times)
- Nov 24: Fundamentals of TempDB
Register here to attend all of those, for free. The Americas-friendly classes will be 9AM-5PM Eastern US time, and Europe-friendly classes will be 8:00-16:00 UTC. (How to Think Like the Engine is only a half-day class though.)
After you’re registered for class, set up your server.
All of the Fundamentals courses except Fundamentals of Columnstore have the same prerequisites. Set yourself up a SQL Server:
- SQL Server 2017 or newer, either Developer Edition or Evaluation Edition. Download pages are linked from SQLServerUpdates.com. Express Edition, Azure SQL DB, and Amazon RDS won’t work, unfortunately.
- Use the default collation during install, SQL_Latin1_General_CP1_CI_AS (don’t get fancy with binary collations)
- Apply the latest Cumulative Update
- Install the most recent SQL Server Management Studio
To follow along with the demos, download the 50GB Stack Overflow 2013 database (10GB 7z file). I’ll be using the medium-sized 50GB StackOverflow2013 database, and it’s vital that you use the same one. Query tuning and parameter sniffing is all about getting different behavior based on your query’s parameters, so I need you to have the exact same data distribution that I’ll be working with onscreen.
Fundamentals of Columnstore has more ambitious prerequisites because columnstore is about bigger data. You don’t have to follow along with the class demos at all – it’s totally optional, and you can just watch me do them on the screen – but if you do want to follow along, here are the columnstore prerequisites.
Register now – attendance is limited to the first 1,000 students who get in. See you in class!