Faster, Cheaper Cloud Databases
For Microsoft databases in AWS, Azure, and Google.
What you will get:
- Watch on any Device
- 1 sections
- lectures
- of video
Last updated: 05 March 2021
Your Instructor
I make Microsoft SQL Server go faster. I've been working with SQL Server since the late 1990s, and I'm one of the rare Microsoft Certified Masters of SQL Server. I love teaching, travel, and laughing. I live in Las Vegas, Nevada.
Course Description
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. Upcoming dates:
- May 16, 2025 - SQL Saturday Research Triangle, NC. The class will be 9AM-5PM at Duke Health, 1st Floor Auditorium, 14 Moore Dr, Durham, NC 27703.