PreCon: Performance Tuning in 21 Demos - Brent Ozar

*************************************************************************************
Register at this link: https://www.brentozar.com/product/performance-tuning-in-21-demos/
*************************************************************************************

Session Details:

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.”

Prerequisites: In one demo-filled day with me, Brent Ozar, you’ll see SQL Server 2017 and 2019 make questionable lifestyle choices. They’ll 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. I will show you how to coach the database engine into better performance and less problems.

You should be comfortable writing queries, but not at all comfortable with making them go faster.

If you want to follow along on your own computer, get the free Stack Overflow 2013 database https://www.brentozar.com/archive/2015/10/how-to-download-the-stack-overflow-database-via-bittorrent/

Some of the demos will only work on specific SQL Server versions, like 2019 or 2017 – we’ll note that where applicable

Speaker:

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.

Special Notes

You will also be required to buy a pay-by-plate daily parking permit ($5) on the day of the event. You may do this online or at one of the kiosks located in the garage. Kiosk map and pay by plate instructions. https://bit.ly/2QHjQRa

*************************************************************************************
Register at this link: https://www.brentozar.com/product/performance-tuning-in-21-demos/
*************************************************************************************