Times and tech are changing quickly. Let’s get you up to speed on the latest developments to do your work more quickly with a series of free live webcasts.

How to Tune Indexes Faster – May 12 & 18 – Brent Ozar will show you how to use the latest features of sp_BlitzIndex to rapidly improve performance on an existing database. He’ll show you how to figure out quickly if you’ve got too many indexes or not enough, and then demonstrate how to get advice from AI on how to consolidate them in seconds.

How to Tune Queries Faster – May 14 & 20 – Brent Ozar will show you how to use the latest features of sp_BlitzCache to rapidly improve performance on an existing server. He’ll show you how to find your server’s top bottleneck, find the queries causing that bottleneck, and then demonstrate how to get advice from AI on how to tune them in seconds.

How to Gather Diagnostics Faster – June 2 – Whether you’re a consultant, a full time DBA at a big company, or just a lone sysadmin in a hurry, sometimes you need to gather a lot of diagnostic data, quickly, while SQL Server or Azure SQL DB is having a performance emergency. You wanna grab all this without running a bunch of time-consuming commands, and you want to be able to review the data later, at your leisure, to understand what was happening on the server. In this webcast, Brent Ozar will show you two ways to do it: by setting up Agent jobs to run the First Responder Scripts, and by using the Consultant Toolkit.

How to Get Daily Database Advice – June 4 – You’ve got a lot on your plate, and SQL Server is just one of the things trying to get your attention. You’re looking for a way to have someone else keep an eye on your servers to alert you about really important tasks that can’t wait. You’ve tried third party monitoring apps, but they’re constantly crying wolf, spamming your email in-box with warnings about things that don’t really matter. In this webcast, we’ll show you how to install the totally free SQL ConstantCare app, the kinds of things it warns you about, and explain our monitoring philosophy. If you’d like to get performance advice with the paid version, we’ll show you how that works, too.

All of the meetings start at the same time: 1PM Eastern, 10AM Pacific. If you can’t make the classes, we’ll send out recording links after the classes finish. The classes will be lecture-only – you don’t have to follow along on your machine, and you don’t have to install or configure anything.

Register here on the blog. See you in class!