Description
Update 2020: I no longer sell this class. Some things get better with age, like fine wine, but not training courses. I no longer do production database administration – backups, cluster design, Availability Groups troubleshooting – and this class’s material has gradually gotten out of date. Existing customers with access to it are welcome to continue to view the recordings until their subscription expires, at which point it’ll be taken offline.
You’re a SQL Server DBA who is ready to advance to the next level in your career but aren’t sure how to fully master your environment and drive the right architectural changes. That’s about to change in ~16 hours of online learning and adventure with Brent Ozar.
- 1.1 Intro and DBA Skills Quiz (33m)
- 1.2 Building and Testing Reliable SQL Servers Part 1 (25m)
- 1.2 Building and Testing Reliable SQL Servers Part 2 (21m)
- 1.3 Architecture for HA and DR Part 1 (25m)
- 1.3 Architecture for HA and DR Part 2 (15m)
- 1.4 Design Quorum for Failover Clusters (23m)
- 1.5 Triaging Failure in Availability Groups (32m)
- 1.6 Recovering from Failover Part 1 (40m)
- 1.6 Recovering from Failover Part 2 (12m)
- 1.7 Building an Inventory and a Support Matrix (39m)
- 2.1 Database Mirroring Field Medic Guide (40m)
- 2.2 Transaction Log Shipping Tips and Tricks (45m)
- 2.3 Troubleshooting Backup and Restore Problems (35m)
- 2.4 Optimizing DBCC CHECKDB (53m)
- 2.5 Availability Group Backup and CHECKDB Part 1 (8m)
- 2.5 Availability Group Backup and CHECKDB Part 2 (32m)
- 2.6 Cloud for the Senior DBA (38m)
- 2.7 Homework: Deciding Between Availability Solutions Part 1 (11m)
- 2.7 Homework: Deciding Between Availability Solutions Part 2 (27m)
- 3.1 Shared Storage Part 1 (28m)
- 3.1 Shared Storage Part 2 (32m)
- 3.2 Advanced SAN Features – Storage Tiering and Snapshots (31m)
- 3.3 Virtualization Management and Troubleshooting (61m)
- 3.4 Server Hardware Sizing (36m)
- 3.5 Homework Part 1 (11m)
- 3.5 Homework Part 2: Answers (28m)
- 4.1 How to Triage SQL Server Emergencies Part 1 (16m)
- 4.1 How to Triage SQL Server Emergencies Part 2 (44m)
- 4.1 How to Triage SQL Server Emergencies Part 3 (43m)
- 4.2 Index Maintenance for Enterprise Environments (43m)
- 4.3 Patches (25m)
- 4.4 Recap and Q&A (28m)
Sharon Lafferty –
It was awesome!? I learned a lot and brought back some tasks to work on and areas? to embark on, such as AG.
Joshua McIntyre –
Now I have a lot of work I need to do…
Keith Harvego –
It was excellent.? I am actually in the process of putting together a presentation for our next team meeting based on the day 1 concepts of Stress Free IT and documenting our processes and requirements better.? Also I can not stress enough the value of in-person training.? Our company is pushing for more online training, but the value you get from interacting with random peers, is something that cannot be replaced online.
Graham Logan –
Epiphany inducing course work illustrating the depth of knowledge required to be a senior DBA.
Matt Hanson –
Best training I’ve ever done. For years I’d been sent to conferences, and the way breakout sessions are scheduled, with some timeslots having overlapping sessions I’m interested in, and others having nothing I’m interested in, a lot of my time was always wasted. Not so here; it was 4.5 solid days of well-paced, on-point material. The size of the class made it easy to get questions answered that would be very awkward in a large conference setting.
Rich Hansell –
It was fun and informative.? Totally worth it. Also- there is some stuff we do great and also some things we probably want to revisit.
Michael Orechoff –
This is one of the better classes that I have taken. Brent has a ton of knowledge and the questions/answers for real life situations is a great benefit. Having other DBAs asks questions about their environments is also a great benefit.
Slava Davidchuk –
very very impressed
Phil Imbesi –
Excellent class.
Sasan Fakharpour –
It was excellent.
Doug Williams –
The class was very good and well organized. Provided a good view on what a Senior DBA should be focusing by covering the areas of storage, virtualization, hardware, licensing , high availability, disaster recovery, backups, maintenance and troubleshooting . Also, provided good scenarios of how complex availability groups can become when recovering or troubleshooting.? The group participation and interaction was great in regards to helping class members open up which provide a balance between lecture.
Steve Moss –
It was great, the best class I’ve IT class that I have ever taken.
Kevin Anderson –
KEEP DOING THIS! you have a great way of teaching complicated concepts to people and you make learning it fun. It is a joy to attend your classes.
Carrie Jeffries –
It was great!? I loved seeing Brent show enthusiasm about sql server topics.
Steve Bates –
Good.? Wish I knew more about hardware side before attending.