SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

HA and DR Precon in Baton Rouge

SQLSaturday Baton Rouge

I’ll be doing a precon for SQLSaturday #324 in Baton Rouge Louisiana on August 1st, 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.

Eventbrite - SQL Saturday #324 Baton Rouge Pre-Con with Ryan Adams


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

Ryan Adams

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud. Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.


Leave a comment on the original post [www.ryanjadams.com, opens in a new window]

Loading comments...