Please note: our site will be undergoing scheduled maintenance on April 21, 2019, starting at 07:00 UTC and ending at April 22, 2019 04:00 UTC. During this period, you will not be able to log in to your PASS account. To register for PASS Summit, select the Register as Guest option. If you require assistance, please email Thank you for your patience.



Thank you to our sponsors




All 24 Hours of PASS registrants will automatically become PASS members. (membership is free!)





BLITZ! 60 Minute Server Takeovers


Return to Session Listings

Presenter: Brent Ozar, Quest Software


Session 24 (11:00 GMT on May 20)

Session Details
You’re minding your own business in your corner office—well, since you’re a DBA, it’s just your cubicle—when somebody asks, “Did you know about this SQL Server over here?” Suddenly, you have to find out what the server’s doing, how it was set up, and whether things are working correctly. In this all-demo session, you’ll see how to take over a SQL Server and:

  • Quickly assess a server’s health using a set of scripts
  • Catch dangerous development issues that will haunt you later
  • Quickly put some basic measures into place to minimize your risk


About the Speaker

Brent Ozar—a SQL Server Domain Expert with Quest Software and a SQL Server MVP—has a decade of broad IT experience in SQL Server database administration; systems, SAN, and virtualization administration; and project management. In his current role, Brent specializes in performance tuning, virtual and cloud-based database servers, and disaster recovery. Previously, he spent 2 years at Southern Wine & Spirits, a Miami-based wine and spirits distributor. Brent conducts training sessions, has written several technical articles, and blogs prolifically at He coauthored Professional SQL Server 2008 Internals and Troubleshooting (Wrox).

Register now for 24 Hours of PASS!


Check out the speaker lineup!



Copyright 2013 by PASS | Terms Of Use | Privacy Statement | Login