Skip Main Navigation
Page Content
This event has ended

SQL Saturday #331 Denver Pre-Con w/Ryan Adams

Denver SQL Server User Group

Friday, September 19, 2014 from 9:00 AM to 5:00 PM (MDT)

SQL Saturday #331 Denver Pre-Con w/Ryan Adams

Ticket Information

No tickets available.

Who's Going

Loading your connections...

Share SQL Saturday #331 Denver Pre-Con w/Ryan Adams

Event Details

Title: A Day of High Availability and Disaster Recovery

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
Speaker: Ryan Adams

Speaker Bio:






Ryan Adams has worked for Verizon for 16 years. He is the sole SQL Server DBA for his group. His primary focus is the SQL Server Engine, high availability, and disaster recovery. Prior to becoming a SQL DBA, he was a Senior Active Directory Architect and Identity Management Consultant where he architected the company's worldwide Active Directory infrastructure supporting over 250k users.  He enjoys being involved in the SQL community and 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.

Have questions about SQL Saturday #331 Denver Pre-Con w/Ryan Adams? Contact Denver SQL Server User Group

When & Where

Cherry Creek Presbyterian Church - Community Life Center
10150 E. Belleview Ave.
Englewood, CO 80111

Friday, September 19, 2014 from 9:00 AM to 5:00 PM (MDT)

  Add to my calendar


Denver SQL Server User Group

SQLSaturday #441 is being held on Saturday, September 19th at The Summit Event Center, registration to Saturday is separate from these pre-cons and is required if you plan to attend the Saturday sessions. Please register at


The Denver SQL Server User Group is organized to bring professionals of all career levels that work with Microsoft's SQL Server, together to learn and network with others. There is no charge to attend and you are encouraged to bring your co-workers. Through our sponsors, we provide food and refreshments.

We meet every third Thursday of each Month at Microsoft DTC (7595 Technology Way, Suite 400, Denver, CO 80237).

Visit for more information and to create a free account.

  Contact the Organizer
SQL Saturday #331 Denver Pre-Con w/Ryan Adams
Englewood, CO Events Class Science & Tech

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.