Availability groups provide both high availability features and disaster recovery options, but they also have several areas you must be aware so you don't introduce more risk into your environment. The major advantage is availability groups allow for you to fail over more than one database at a time. In Episode 59 we talked about general data availability options and in this episode we focus on the new features of Availability Groups in 2016 and how data availability options have changed with our guest John Sterrett. John shares his experience getting a large database to a highly available situation along with some other ways to use availability groups.
Show notes for today's episode are available at http://sqldatapartners.com/2016/09/21/episode-63-high-availability/ Have fun on the SQL trail.
Episode 18: BIML
Episode 17: Partitioning
Episode 16 SQL Server Agent
Episode 15 Working at a University
Episode 14: SQL Server Clustering
Episode 13 Apply Yourself
Episode 12: Database Corruption
Episode 11: SQL Server Statistics
Episode 10: Test Anxiety and Test Preparation
Episode 09: Database Automation
Episode 08: Database Design
Episode 07: SQL Server Security
SQL Data Partners Podcast: Episode 06 Build Your Personal Brand
SQL Data Partners Episode 05: Principal of Least Privilege
SQL Data Partners Podcast Episode 04: Advanced Backup Options
SQL Data Partners Podcast Episode 03: Backup and Recovery
SQL Data Partners Podcast Episode 00: Who I Am and What the Podcast is About
SQL Data Partners Podcast Episode 02: Extended Events
Create your
podcast in
minutes
It is Free
Insight Story: Tech Trends Unpacked
Zero-Shot
Fast Forward by Tomorrow Unlocked: Tech past, tech future
The Unbelivable Truth - Series 1 - 26 including specials and pilot
Elliot in the Morning