I’ll be doing a precon for SQLSaturday #331 in Denver Colorado on September 19th, 2014 titled “A Day of High Availability and Disaster Recovery” . If you can make it, I would love to have you in the class. We are going to cover backups, windows clustering, AlwaysOn Failover Cluster Instances, AlwaysOn Availability Groups, and more. This class will take each of those technologies in a progressive order to build on each other. At the end of the day we will have a single solution built out in virtual machines on my laptop that use all of those technologies to build a comprehensive and real world high availability and disaster recovery architecture. Click the button below to register and I have included the session abstract as well.
Let’s spend a day looking at several High Availability and Disaster Recovery solutions for SQL Server. We’ll start off with a solid foundation as we look at backups and how to both configure and performance tune them. After we build our foundation, we’ll take a look at SQL Server Mirroring and why it’s still an important tool in our tool box. Since all of the HA/DR solutions we will be looking at either sit on top of or can be combined with Windows Failover Clustering, we’ll learn how to setup and configure a windows cluster to host these solutions. Next we’ll build on that platform by looking at SQL Server AlwaysOn Failover Clustering Instances. Last we’ll dive into how to setup SQL Server AlwaysOn Availability Groups. Once we have a firm understanding of all these technologies we’ll see how they all work together by discussing a case study together and developing a comprehensive solution. Here’s what you will learn:
SQL Server backup types
SQL Server recovery models
How to design a backup plan
How to performance tune your backups for free
How to configure mirroring
Mirroring configuration tips to increase throughput
Setup and Configure a Windows Failover Cluster
Discover how to properly configure quorum to support the AlwaysOn feature set
Setup and Configure a SQL AlwaysOn Failover Cluster Instance
Setup and Configure a SQL AlwaysOn Availability Group
UPDATE
I thought I would post an update after the event. The class went great and we had some excellent discussions! 5pm came up on us really fast and although I had covered all the material, I had some more demos. I offered to stay and go through them and about 7 of the 15 attendees decided to hang around. I kept going for another hour before we got kicked out of the facility. It was a fantastic day and I had an absolute blast. I had added a case study for us to go over and see how many ways we could solve the business requirements, but we simply didn’t have time for that. The feedback that I got was excellent and not a single negative thing was mentioned, in fact here is a testimonial from one of the attendees.
Testimonial
This past weekend was SQL Saturday #331 Denver. I always enjoy SQL Saturdays, but I was especially looking forward to this weekend because I was going to attend a SQL Saturday Pre-Con for the first time! The pre-con was fantastic! The Denver SQL Server User Group did an outstanding job, and it was a wonderful day of learning and networking.
I attended Ryan Adams’ session A Day of High Availability and Disaster Recovery. Ryan did an excellent job with this all-day session. You could tell that his agenda was carefully planned to build upon each module. Ryan’s first module was an in-depth tour of backups and restores, pointing out that these concepts were foundational to all High Availability (HA) and Disaster Recovery (DR) solutions. In his next module, Ryan expanded on backup/restores as he introduced us to mirroring. Ryan then walked us through the concept of Windows Server Failover Clustering (WSFC). Culminating in his module on AlwaysOn Failover Cluster Instances and Availability Groups, Ryan tied all the concepts together providing a holistic view of HA/DR. I would definitely recommend this all-day session to anyone looking to expand his or her knowledge of HA/DR. To find out more about Ryan Adams, you should check out his blog at ryanjadams.com.
Is there a discount code for the precon tickets?
The Denver SQL UG is hosting so you would have to ask them. They have not made me aware of any discount codes so I don’t believe there are.
Hi Ryan,
Just wanted to say thanks for the pre-con class…it was fun, and I really enjoyed doing some of the deeper dives that we’d never be able to do during a normal session on a SQL Saturday. The pre-con classes are a super idea, I hope you’ll be able to return for another one in the not-too-distant future.
Cheers,
Michelle (of the 20,000 VLFs)
Thanks Michelle! I had a blast doing it and I’m really glad you enjoyed it. The feedback was overwhelmingly positive.
Hi Ryan, Help, I’ve spent the last half hour clicking all over SLQ Saturday, events, pre-con events, Denver usergroup, and SQLPass websites trying to find your presentation. Can you send me the link from the pre-con? Thanks!
Hi Thane. You can click on “HA_DR Precon Materials” right at the top of my blog. The materials are only for attendees so you’ll need the password I provided during the class. If you no longer have the password you’ll need to send me an email. If you no longer have the business cards I handed out you can find my email on the “About Me” tab at the top of my blog. Here is a direct link to the materials as well…
https://www.ryanjadams.com/ha-dr-precon-materials/