How to Be a Senior DBA
- Instructor(s): Brent Ozar, Kendra Little
- Cost: $1,595
You’re a 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 two days of learning and adventure.
In 2014, join us to learn how size, architect, and maintain your SQL Servers:
Day 1: SQL Server Architecture for Production DBAs
Architecture Design for RPO/RTO -You can add in speed later with more CPUs or memory, but you can’t add in reliability. In this session, we’ll show you what questions to ask the business about RPO and RTO, and how to translate those requirements into clusters, mirrors, AlwaysOn Availability Groups, and more.
Hardware Sizing - Once you’ve decided what kind of architecture to build, how big should each node be? Do you need 64GB of memory or 128GB? If you’ve only got one set of SSDs, should you use them for log files or TempDB? We’ll explain the right server builds for common use cases.
How to Build an Enterprise Maintenance Strategy - You know maintenance is important, but you’re not sure what you should REALLY be running, or how often. In this session you’ll learn why index maintenance is generally overly-hyped– but can still be critically important to performance in some situations. We’ll discuss how to implement statistics maintenance and make sure backups and integrity checks are running regularly, as well as maintenance gotchas and pitfalls.
The Secret Meaning of Performance Counters - Most DBAs collect the wrong performance counters. Learn which performance counters matter, how to collect them, and how to use them to solve problems. Kendra will teach you the meaning of critical counters, which counters to avoid, and how to integrate performance counter data into your troubleshooting process. You’ll also learn which tools and scripts help collect SQL Server performance counter data more easily.
SQL Server Settings for Senior DBAs - Every software product has its gotchas. SQL Server has some settings and configurations which can cause major problems for performance and availability when changed– or when left to the default. Learn which settings that may be lurking in your environment could be a nightmare, and find out how to identify ‘em fast.
Test Your Knowledge: SQL Server Configuration and Maintenance - Can you spot the problem or find the answer in four maintenance and configuration scenarios? Learn about advanced features that impact performance and test your skills in this session.
Day 2: Specialize and Respond to Crisis
Virtualization Management & Troubleshooting - It’s easy to virtualize SQL Server – but it’s hard to get performance right afterwards. You’ll learn how to figure out if your SQL Server is configured correctly for VMware and Hyper-V, plus how to troubleshoot when you’re not getting the performance you want.
SANs and SSDs for SQL DBAs - Is your storage a black box? Do you put data in, and it doesn’t come out as fast as you want? Brent will explain Storage Area Networks (SANs), pathing, SSDs, and how to test your storage subsystem to find out if it’s as fast as it’s supposed to be.
What Every Senior DBA Must Know About Failover Clustering - Failover clustering has become integral to high availability in SQL Server. You’ll learn the strengths and weaknesses of failover clusters for SQL Server, and why clustering can no longer be ignored.
SQL Server First Responder Kit - When your SQL Server is critically injured you need a first responder kit to help you diagnose the problem and apply emergency aid. Learn tools and techniques to triage an emergency situation in your SQL Server quickly and effectively.
AlwaysOn AG Lessons Learned - The brochure says AlwaysOn is AlwaysEasy, but in reality, it’s chock full of nuts. Quorum questions, subnet surprises, and random replica reboots catch DBAs by surprise. We’ll share the nasty lessons we’ve learned and share what the best AG deployments have in common.
Pushing Boundaries: Stories from the Field - We’ve worked with some of the biggest, scariest SQL Servers out there. What happens when you have thousands of databases? Tens of terabytes in a single data file? Client names will be changed to protect the innocent, but the stories will remain the same. Learn these lessons long before you approach SQL Server’s limits.
Don’t take our word for it – here’s what some of our 2014 in-person attendees have said so far:
“Immediate practical use.”
“I’ve been pushed into the SQL world because of a slow third-party application. This class pulled together concepts I’ve heard about but not really understood, and introduced me to a lot more that will assist in the future.”
“Amazing sessions, interesting topics, entertaining speakers. 2 thumbs up.”
“It was extremely useful. Gonna go back and re-evaluate a lot of DBA goals and projects to reprioritize them with new knowledge I gathered. Thank you!”
“I figured out that my skillset is a little lower than I thought.”
Logistics: Hotels, Travel, and Restaurants
During the training, we provide you with breakfast, mid-morning breaks, lunch, and afternoon snacks. Dinner is on you, but during the training, we’ll organize Birds of a Feather groups so you can dine with fellow folks who share the same interests.
Here’s information about travel logistics:
You also get 2 hours of video training to prepare for the in-person training. We’ll cover how to prescribe the right database maintenance, how to set up database mail, how to find your business’s RPO and RTO goals, and how to choose the right high availability and disaster recovery methods for those RPO/RTO goals.
Why This Class?
For weeks (or maybe months or years!) you’ve watched free Brent Ozar Unlimited webcasts. You’ve checked out our online SQL Server training. Maybe you’ve even had the chance to see our award-winning sessions at conferences like the PASS Summit, Microsoft TechEd, SQLBits, and DevConnections. You like those – but you want more, and you want a long, in-depth series of sessions that will arm you for the real problems you face every day at work.
These sessions are all about solving your real pain points. It’s all killer, no filler – all knowledge that you can take back to work and look like a superhero.
The first 20 registrants at each event get a $200 discount plus a personalized, signed copy of Professional SQL Server 2008 Internals and Troubleshooting, the book Brent coauthored. SOLD OUT!
Can’t Wait for the In-Person Training?
Check out our related online courses that you can watch anytime:
- Virtualization, SANs, and Hardware for SQL Server - $299 for 6-hour online course - When you’re the one who has to plan, buy, set up, and troubleshoot production SQL Servers, you need to know about hardware, SAN storage, SSDs, virtualization, and more. Read more and watch a preview.
- How to Tune Indexes and Speed Up SQL Server – $299 for 6-hour online course - You want to become an expert at index tuning, but you can’t find a good start-to-finish training course. Kendra Little teaches you the basics, the gotchas, and the tricks of SQL Server indexing in 6+ hours of training. Read more and watch a preview.
- Developer’s Guide to SQL Server Performance - $299 for 6-hour online course - You’re a developer stuck with a database server that’s not going fast enough. You’ve got a hunch that the biggest bottleneck is inside the database server somewhere, but where? Read more and watch a preview.