T-SQL Tuning with Colin Chapman, Enzo Ferrari, and The Stig

Colin Chapman was a true Formula 1 pioneer whose innovations included the aerodynamic wing spoiler.  Enzo Ferrari once said, "Aerodynamics are for people who can't build engines."  The Stig, well, he never says anything out loud, but his actions speak volumes.

In this session, Brent will use quotes and lessons from racing icons like Chapman, Enzo Ferrari, and The Stig to illustrate SQL Server performance tuning concepts.  Find out how to "add lightness" to your database by using DMVs to eliminate unneeded indexes, how to get out of the pits faster with Database Mirroring, and why skipping performance monitoring is like overdriving your headlights.
Presented by Brent Ozar at SQLBits V
  • Downloads
    Video available WMV Video 177 MB
  • SpeakerBIO
    Brent Ozar makes SQL Server faster and more reliable. He's a Microsoft Certified Master of SQL Server, and he created sp_Blitz®, DBAreactions.com, SQLServerUpdates.com, and GroupBy.org.
    https://www.brentozar.com/ https://www.brentozar.com/feed/
  • Video