LinkedIn
YouTube
GitHub

2018 Live Class Season Pass

$5,995.00

  • $0.00

SKU: c-SeasonPass2018 Categories: ,

Product Description

Season passes are great for people who want to cram in a lot of learning, all year long. You get access to all of Brent’s live online classes in 2018, including:

Each of the above classes is held at least four times per year, so you can find a set of dates that work for you. (It also includes admittance to the remaining 2017 dates for those classes.) If our normal dates fill up, we’ll add even more dates just for Live Class Season Pass holders to make sure you get your training in.

These are online classes – I (Brent) host it in GoToWebinar, live with me on webcam, taking questions as we go through the material together. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way. For more information, check out the Training Logistics PDF for our online classes.

You can watch recordings all year with Instant Replay – all during 2018, you can watch recorded versions of these classes via online streaming. Brush up on stuff you missed or revisit your favorite topics. It’s the best of both worlds: live training with Brent, plus reminders.

The fine print:

  • A Season Pass includes 2 sessions of each class. If you want to attend a class a 3rd or 4th time in 2018, you can, but there will be a $100 fee to cover your VM. (We give you folks nice fast virtual machines so you can rapidly test different indexes, file configs, etc.)
  • Season Passes are sold per-person, and cannot be shared between team members. For discounts on groups of 3 or more Season Passes, contact us.
  • Season passes only apply to Brent’s online classes, not classes taught by other folks, or held at other locations (like conferences or in-person events.)

Once your BrentOzar.com account has the Live Class Season Pass membership, you can register for the included classes for free. (If someone else bought the membership for you – like if the buyer’s email doesn’t match the student’s email – we have a little bit of manual work to do behind the scenes to set up your account.)

To register, log in, then go to the list of eligible classes, add the class/date you want to your cart, and check out. If you see anything about putting in a credit card, STOP, and make sure you’re logged in with the student’s account. No money should be changing hands here. Well, unless you wanna tip us, but in that case we’d suggest tequila, or XL t-shirts from your place of employment.

Cheating is a bad idea. If you try to register someone else, we will catch you when we audit the list the night before class, and we’ll have to send you a really sad email. (Trust me, I have to do this a few times a year. It’s stunning that people think they can still get away with that in the age of databases, but whatever.)

There are plenty of seats for Season Pass holders – don’t worry about registering ahead of time if you’re not sure if you’ll be in a class. The Season Pass gets you free entry into each class up to 2 times. (You can even attend a class more times than that, but then there’s a $100 fee to cover your VM.) Don’t panic and try to register for every class – there’s plenty of space for you, and once set, you don’t get a refund if you have to switch dates. (I have to rent your VMs in advance for dates, so if you don’t show up for a class, it doesn’t really matter – that money is gone.) When in doubt, wait it out – you can always register the week before a class. If it looks like a class is sold out, just shoot us an email and we’ll add a spot for you.

I would recommend doing the Mastering Indexes class first, then Mastering Query Tuning, then finally Mastering Server Tuning. That’s why I run the classes in that order, too – they alternate months 1-2-3, 1-2-3, 1-2-3. If you have to take ’em out of order, that’s okay – it’s just that in the Query Tuning class, I’m going to assume that you’ve already mastered the index tuning portion, so there will be some parts of the class that won’t make as much sense.

One of the tricky things about training classes is that they’re so theoretical. It’s all about example servers, databases, and queries. But how does the training relate to YOUR server?

That’s where another fun part of your Live Class Season Pass comes in. I’ll analyze the data from one of your production SQL Servers, tell you what we’d focus on, and tell you what parts of the training will be the most meaningful to you.

Pick just one SQL Server – the one you’re having the most problems with, or the one you’d like to learn about. Only pick one per quarter – analyzing this data takes us time, and we have to be fair to the other students.

To get our analysis, download our free utility to your desktop (not the SQL Server.) Extract it in an easy-to-find folder like C:\temp, and then open a command prompt, navigate to that folder, and type:

CriticalCareCollector.exe –s MYSERVERNAME

If you use SQL authentication to connect to the server, you can specify a username & password:

CriticalCareCollector.exe –s MYSERVERNAME –i MYUSERNAME –p MYPASSWORD

The Collector takes about 5-10 minutes to run a bunch of low-overhead, low-priority DMV queries like sp_Blitz, sp_BlitzIndex, and sp_BlitzCache, packages it up into a zip file, and sends it to us for analysis. It doesn’t change anything on your server or block queries – it just gathers metrics. It doesn’t need to be run during peak load – after hours is fine if you prefer.

Data that it sends to us includes server info (name, setup), database info (lists of databases, indexed fields, stats), and query info (top 10-20 execution plans.)

After it runs, email us with your server’s name so that we can match up your data to you (lots of clients & students send us data), and we’ll start digging into the diagnostics. We’ll tell you what we’d look at first, what you should focus on in the training classes, and how to get the most out of your Live Class Season Pass.

Related products

Menu