Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ryan Adams

Ryan Adams has worked for Verizon for 15 years. His primary focus is the SQL Server Engine, high availability, and disaster recovery. Previously he was a Senior Active Directory Architect and designed the company's worldwide Active Directory infrastructure. He serves on the Board of Directors for the North Texas SQL Server User Group and is President of the PASS Performance Virtual Chapter. He also serves as a Regional Mentor for PASS and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP.

HA and DR Precon in Denver

SQLSaturday Denver

 

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.

Eventbrite_Button

 

 

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

 

Comments

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

Loading comments...