Most Active Speaker

Brent Ozar

Brent Ozar

I make Microsoft SQL Server go faster.

Las Vegas, Nevada, United States

Actions

I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. Las Vegas, US. He/him.

Badges

  • Most Active Speaker 2025

Area of Expertise

  • Information & Communications Technology

Topics

  • sql server
  • T-SQL
  • performance
  • Database
  • SQL Server DBA
  • Database Administration
  • Database Development
  • Databases

20 Years of the Cloud: What Changed, What Didn’t, and What’s Next

It’s been roughly 20 years since “the cloud” started entering mainstream IT—and in that time, it’s been declared both the future of everything and the cause of countless late nights.

In this panel discussion led by Brent Ozar, experienced data professionals reflect on two decades of real-world cloud adoption: what genuinely improved, what simply became a different kind of difficult, and which problems stubbornly refuse to go away. None of the panelists work for cloud vendors, and the conversation is grounded in firsthand experience building, operating, and troubleshooting systems that had to work under real business constraints.

The panel will look back at early cloud promises, examine today’s realities, and then look forward to the next 20 years. What challenges are likely to persist no matter how platforms evolve? Which current trends feel foundational, and which may turn out to be short-lived? How should teams design systems today that they’ll still have to live with a decade from now?

This session isn’t about selling cloud platforms or predicting the next hype cycle. It’s about sharing honest lessons learned, recognizing patterns that keep repeating, and helping attendees develop realistic expectations for what the cloud can and can't solve as it continues to mature.

Identifying and Fixing Parameter Sniffing

You swear nothing changed - but suddenly your SQL Server has ground to a halt. Queries are slow across the board. You restart the server, rebuild indexes, or update statistics, and magically the problem goes away - but what really happened, and how do you fix it faster and more permanently?

Brent Ozar will explain what parameter sniffing is, show it happening live, explain why most people fix it the wrong way, and give you options to fix it long term.

Blocking: How to Find and Fight LCK* Waits

When you’re facing lock waits and blocked queries, it’s tempting to just slather NOLOCK all over the queries. Thing is, this won’t necessarily fix it, and there are much better ways to track, diagnose, and cure blocking issues. You’ll learn them here.

Dynamic SQL: Pro Tips for Building and Tuning It

Dynamic SQL is one of the most powerful tools in the database developer's arsenal. When you need a complex search stored procedure that takes all kinds of parameters (price, category, location, color), dynamic SQL can run extremely quickly by leveraging better indexes. However, when done wrong, it's extremely painful to troubleshoot.

I'm Brent Ozar, a Microsoft Certified Master who's been working with dynamic SQL for over a decade. I'll show you how to use sp_executesql, sp_BlitzCache, and my favorite tricks for easier debugging and commenting.

SQLBits 2026 Sessionize Event

April 2026 Newport, United Kingdom

SQL Saturday Houston 2025 Sessionize Event

November 2025 Houston, Texas, United States

SQL Saturday Boston 2025 Sessionize Event

September 2025 Burlington, Massachusetts, United States

SQLBits 2025 - General Sessions Sessionize Event

June 2025 London, United Kingdom

Data Saturday Croatia 2025 Sessionize Event

June 2025 Zagreb, Croatia

SQL Saturday Raleigh 2025 Sessionize Event

May 2025 Durham, North Carolina, United States

SQL Saturday Jacksonville 2025 Sessionize Event

May 2025 Jacksonville, Florida, United States

2024 Data.SQL.Saturday.SD (SQLSatSD) Sessionize Event

September 2024

SQL Saturday Boston 2023 Sessionize Event

October 2023 Burlington, Massachusetts, United States

Data Saturday Oslo 2023 Sessionize Event

September 2023 Oslo, Norway

Data Saturday Gothenburg 2023 Sessionize Event

August 2023 Göteborg, Sweden

Data.TLV Summit Sessionize Event

September 2022

SQLBits 2022 Sessionize Event

March 2022 London, United Kingdom

PASS Data Community Summit 2021 Sessionize Event

November 2021

Data Saturday Holland Sessionize Event

October 2019 Utrecht, The Netherlands

Techorama Netherlands 2019 Sessionize Event

October 2019 Ede, The Netherlands

Techorama Belgium 2019 Sessionize Event

May 2019 Antwerpen, Belgium

Techorama NL 2018 Sessionize Event

October 2018 Ede, The Netherlands

Brent Ozar

I make Microsoft SQL Server go faster.

Las Vegas, Nevada, United States

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top