Capital Area Central Texas User of SQL Server

PASS affiliated user group for Austin, TX

Contact us: Email: CACTUSS.SQL (at) (gmail) (dot) (com)

Upcoming Meeting Dates

Aug 2019 Tue 8/20/2019
Speaker: Mike Byrd
Topic: A Self-Tuning Fill Factor Technique for SQL Server
Sep 2019 Tue 9/17/2019
Speaker: Jay Falck
Topic: Setting up a test lab with Hyper-V
Oct 2019 Tue 10//21/2019
Speaker: Open
Topic: Submit Your Topic
Nov 2019 Tue 11/19/2019
Speaker: Open
Topic: Submit Your Topic


Meeting Location


  • Meeting dates: 3rd Tuesday of the month
  • Meeting starts: 5:30 pm with food and a QA session
  • Presentation: 6:00 pm and goes to 7:15 pm
  • Address
    • Quarry Oaks II
    • Microsoft Office
    • Suite 225
    • 10900 Stonelake Blvd.
    • Austin, TX 78759
      • * Free parking
      • * Coming from Braker, go right/straight at the traffic circle and it's the building on the left.
      • * The building is also across from the outdoor basketball court
      • * Not the building attached to the parking garage
      • * Inside the Microsoft office, go right, past the reception desk, to the far back and left
      • * If there is interest, there is sometimes an after-gathering at a local place to talk casually
    • Map:

Next Meeting




Precon for SQL Saturday Austin #461 - Creating a High Availability and Disaster Recovery Plan

1209 N IH 35
Round Rock, Texas 78664
Time: 09:00 - 16:30

Special Notes:


Title:   Creating a High Availability and Disaster Recovery Plan

Speaker: Ryan Adams

Abstract:  You have been tasked to configure a high availability and/or disaster recovery plan to ensure your company's systems are always up and running while able to withstand a disaster.  SQL Server offers several options, but how do you choose the right one to meet your business requirements?  I've been faced with this same problem.  I'll help you figure out how to choose the right technology.  We will start off with a solid foundation in backups and demonstrate how to configure them for initializing the various HA/DR technologies while also cutting your backup and restore time in half.  You will see how you can keep an offsite copy of your database in sync with your production system with mirroring.

You've read that several of the HA/DR solutions require Windows Failover Clustering, but you don't know anything about managing a complicated Windows cluster.  I'll show you how to setup and configure a Windows cluster and we'll build on that with SQL Server AlwaysOn Failover Clustering Instances that provide the 99.999% of up-time your management demands.  Lastly we'll dive into how to setup AlwaysOn Availability Groups to solve both HA and DR in one solution.  We will see how all these technologies work together by discussing a case study and developing a comprehensive solution just like you have to do when you return to the office. 

Here's what you will learn:

  • Planning a backup strategy to avoid a data disaster
  • Cutting your backup and restore time in half when initializing DBs for Mirroring or Availability Groups
  • Configuring mirroring to keep production in real-time sync with an offsite database copy
  • Learning configuration tips to increase throughput
  • Configuring a Windows Failover Cluster to meet that five 9s business requirement
  • Discovering how to properly configure a Windows Cluster quorum to support the AlwaysOn feature set
  • Implementing a SQL AlwaysOn Failover Cluster Instance
  • Creating a SQL AlwaysOn Availability Group to solve both your HA and DR requirements in one solution

Learning Objectives:

  • Learn how to design and implement a solid backup strategy.
  • Understand how to configure Windows Clustering and quorum design to support SQL Server HA and DR technologies.
  • How to install AlwaysOn Failover Clustering and AlwaysOn Availability Groups along with best practices.

Session Prerequisites:

  • Basic understanding of networking
  • Knowledge about different types of database storage

Bio:   Ryan Adams is a SQL Server MVP and has worked for Verizon for 17 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 is also a PASS Regional Mentor and holds the following certifications: MCP MCSA MCSE MCDBA MCTS MCITP.

Available Attachments:

Our monthly meetings are made possible by the generosity of these sponsors:

This month's sponsor:

(Feature coming soon)

Ongoing sponsors:


SQL Watchmen  

Back to Top