SQL Training

Forget Mission Impossible–This is Mission Critical: High Availability for SQL Server 2008 and 2012

Whether your business hours are 9 to 5 or 24x7x365, your systems need to be up when you need them. How you get to the availability you need is a combination of people, process, and technology. At the end of the course, you will have real-world knowledge based on actual implementations, not just theory, that you can go back and use immediately.

This three-day course with Microsoft MVP and high availability guru Allan Hirt will dive into the new features and enhancements within SQL Server 2012 (as well as 2008), including the enhanced multi-site failover clusters and AlwaysOn availability groups. Windows 8 Server and Server Core will also be discussed as they relate to highly available SQL Server deployments.



Instructor: Allan Hirt

Dates: TBD

Location: Your City?

Course Detail PDF Download of: Forget Mission Impossible–This is Mission Critical: High Availability for SQL Server 2008 and 2012

Download the course details for yourself or your employer!

Day 1

  • Mission Critical Basics: Ensuring that your SQL Server databases are reliable, available, and highly performing takes much more than just technology or a single feature in SQL Server. Your overall strategy should encompass people and processes, both of which will be covered.
  • Windows Deployment for SQL Server: One of the challenges that many DBAs face is ensuring that the underlying Windows builds are done correctly. Topics such as deploying SQL Server 2012 on Windows Server Core will be covered, as well as the Windows portion of failover clustering from a SQL Server perspective. Windows 8 Server will also be covered in some capacity.
  • SQL Server Failover Clustering: Besides understanding the Windows portion of clustering, it is essential to know the SQL Server component as well. Learn how to plan, deploy, and administer clustered instances of SQL Server, including multi-site clusters using SQL Server 2012.

Day 2

  • SQL Server Failover Clustering: Continued from Day 1
  • Database Mirroring, Log Shipping, and Replication: These three features have been in SQL Server for quite some time and are remain valid options for part of your overall SQL Server availability strategy. Each feature will be explored, and you will learn the most important aspects for planning, deployment, and administration, including the best scenarios for when to use them.
  • AlwaysOn Availability Groups: A key new feature of SQL Server 2012 is AlwaysOn availability groups. Learn how to implement and administer this new feature, which is built upon a foundation of Windows failover clustering as well as database mirroring.

Day 3

  • Backup and Restore: Arguably the most important aspect of any availability strategy is implementing a solid backup and restore design. This step will be discussed in detail.
  • Day-to-Day Administration to Enhance Uptime: Keeping servers, instances, and databases running is more than deploying one of the features covered in this course. There is routine maintenance to consider, as well as periodic patching/upgrading that must occur. Not only are there tasks, but you also need to keep on top of things by monitoring to see when things are a problem–or will be a problem. The top things that you must do to remain up will be covered.
  • Solution Design: Last but certainly not least: It isn’t enough to simply understand the technologies individually. You need to bring all of the requirements–both technical and non-technical, platform and administration–together and design the right solution for your deployment. You will learn how to approach this challenge and balance the different requirements and factors to produce an actionable plan, not just something that will live in a document.

Intended Audience

This course is perfect for SQL Server DBAs eager to get an early understanding of SQL Server 2012 and what is means for creating and maintaining mission-critical database systems.


All those interested in SQL Server high availability and the changes within SQL Server 2012 are encouraged to attend, although at least one year of DBA experience is suggested. Some basic experience with Windows and hardware, as they relate to the database, is also recommended.

What You Will Learn

  • High availability
  • SQL Server 2012 enhancements
  • Windows deployment for SQL Server
  • Database mirroring
  • Replication
  • AlwaysOn availability groups
  • Failover clustering
  • Backup and restore
  • Windows 8 Server/Server Core

Instructor Bio:

Allan Hirt

Allan Hirt is a Microsoft MVP and SQL Server veteran dating as far back as 1992. After years of working with enterprise companies like Microsoft and Avanade, Allan founded SQLHA, a solutions-based high availability consulting firm, whose clients these days include JPMorgan Chase and Timberland. These days, his focus is all about mission-critical infrastructure and what SQL Server 2012 brings to the table in this area.
Allan is a seasoned speaker and trainer, having taught high availability and clustering all over the world. He is well-known as the author of Pro SQL Server 2008 Failover Clustering (Apress, 2009) and several articles and whitepapers for Microsoft and SQL Server Magazine. His next book, Mission Critical SQL Server 2012, is due out in spring 2012.

Location: Your City?

Registration: TBD Click here to request this course

Visa, MasterCard, Discover, American Express, PayPal, eCheck, Check, Purchase Order

Data Educaiton accepts Visa, MasterCard, Discover, American Express, PayPal, eCheck, personal & business checks and purchase orders.

Course Dates: TBD (3 Days)
Course Time: 9:00 AM - 5:00 PM
Course Detail PDF Download of: Forget Mission Impossible–This is Mission Critical: High Availability for SQL Server 2008 and 2012 Download the full course details in a convenient PDF

Using a Purchase Order or Check?

If a purchase order is required for invoice, please send us the P.O. number using our contact form. Be sure to indicate the course title and attendee name(s) in your message.

We accept personal and business checks for course registrations up to 15 business days before the start date of the desired course. If paying by check, remember that it can take up to 5 business days to arrive at our office through postal mail depending on your location. Please include a note telling us the course title and attendee name(s), and make your check payable to:

Data Education
15 Lincoln Street
Suite 226
Wakefield, MA 01880

Refund & Cancellation Policy

If Data Education cancels the course, you will receive a 100% refund. Registration is fully transferable to a course of the same or lesser value within one year’s time of the initial course. If you cancel your registration with more than 30 days notice, Data Education will refund the fee minus $250 for processing. If you cancel your registration with between 16 and 30 days notice, Data Education will refund 75% of the fee. If you cancel your registration with between 7 and 15 days notice, Data Education will refund 50% of the fee. Cancellations unfortunately will not be allowed as of 6 days before the beginning of the course.