I’m coming to Jacksonville, FL on May 2-3 and Raleigh, NC on May 16-17 for SQL Saturdays! In each city, I’m teaching a one-day pre-conference workshop on Friday.

Jacksonville Pre-Conference Workshop:
Mastering Query Tuning

You’ve been working with SQL Server for a few years, and you’re comfortable writing queries and reading execution plans.

In this 1-day session, Brent Ozar will use the same practical before-and-after techniques that he uses in his Query Challenges blog series in order to demonstrate what parts of your skills need to change as you modernize your databases.

You should be comfortable using SSMS to write multi-page queries, functions, and stored procedures. You should be comfortable identifying common query plan operators like index seeks & scans, key lookups, sorts, and parallelism, and comparing plans.

In this session, you’ll:

• Learn the difference between early and late estimation errors
• Learn how to choose between temp tables, CTEs, and table variables
• Learn the best query hints to apply quickly
• And more!

Register for SQLSaturday Jacksonville and the pre-conference workshop here.

Raleigh Pre-Conference Workshop:
Faster, Cheaper Cloud Databases

You’re managing databases that live in AWS, Azure, and Google, and you’re getting a lot of questions about slow performance and crazy costs. Your users want everything faster and cheaper, and you’re not finding good answers.

Join me, Brent Ozar, for a day of real-time demos, honest war stories, and practical fixes. I’ll tackle an Azure SQL DB Managed Instance in the morning, and then an Amazon RDS SQL Server in the afternoon. I’ll show how I use the First Responder Kit to assess the bottleneck, mitigate as much as I can with index and query tuning, and then write up a business case for management for better future budgeting.

Throughout the day, I’ll include real-life stories from my cloud clients, with names changed to protect the innocent. I’ll explain what worked, what didn’t, and what went up in expensive flames.

You’ll learn:

• How Brent uses the First Responder Kit to assess a cloud SQL Server’s wait types
• Why each cloud vendor’s VM quirks make performance tuning tricky, and how to adapt
• How to fix blocking, logging, and CPU issues when the hardware isn’t yours
• How to write a persuasive performance report for management to fairly lay out where the problem is, and what steps to take next

By the end of the day, you’ll be armed with real-world techniques for keeping your cloud databases faster, cheaper, and more future-proof.

This is a live in-person class. It will not be streamed live or recorded. The class will be May 16, 9AM-5PM at Duke Health, 1st Floor Auditorium, 14 Moore Dr, Durham, NC 27703. Register here.