SQL Saturday Sacramento Precon - Brent Ozar

Event Information

Share this event

Date and Time

Location

Location

Patrick Hays Learning Center

2700 Gateway Oaks Dr. Suite 2600

Sacramento, CA 95833

View Map

Event description
Performance Tuning in 21 Demos

About this Event

You're a developer or DBA who wants to tune indexes and queries to make your application go faster. You don't like learning by watching slides or reading white papers - you want to jump right into the code and see what happens. You're the kind of person who loves watching YouTube videos that start with, "Hold my beer and watch this."

In one demo-filled day with Brent Ozar, you'll see SQL Server 2019 make questionable lifestyle choices. It will wildly underestimate the work required with a query, pick the wrong indexes, and jump off the roof into the pool while holding the TV - all in an effort to deliver the right query results. Brent will show you how to coach the database engine into better performance and less problems.

Prerequisites: You should be comfortable writing queries, but not at all comfortable with making them go faster. If you bring a laptop running SQL Server 2016 or newer, you can follow along with the demos - but you don't have to. Brent will lend out the Stack Overflow 2013 (50GB) database on USB drive during class for you to restore.

About Brent:

Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com.

Share with friends

Date and Time

Location

Patrick Hays Learning Center

2700 Gateway Oaks Dr. Suite 2600

Sacramento, CA 95833

View Map

Save This Event

Event Saved