Podcasts about availability groups

Microsoft constantly releases new features and products in the data platform space. Many of us have seen the SQL Server product grow in new ways, some of which are very useful to us. As an example the changes from log shipping to clustering to Availability Groups has improved our HA/DR options as well as the capabilities available to us in different situations. With that in mind, I saw someone recently that wanted to deploy SQL Server on Kubernetes, which is something that could be a very interesting way of managing your different systems. However, this individual wanted to know when Microsoft would release their own supported solution with a Microsoft operator to manage the instance. There is guidance from Microsoft, but no official operator. Read the rest of Do You Want a Microsoft Solution?

We're back with another SQL Server 2022 feature—Contained Availability Groups.  Have you ever failed over to a secondary node and then found a job or login missing?  This new Enterprise-only feature aims to solve this problem by ‘containing' all the objects—master, msdb, AND the availability database all in one group so you can manage everything you need when you have to fail over.  Brandon Leach returns after more than 200 episodes to give us the lowdown on this new feature and walk us through where you should start planning your upgrade. The show notes and video for today's episode can be found at https://sqldatapartners.com/2023/02/15/episode-260-contained-availability-groups. Have fun on the SQL Trail!

היום דיברנו על חודש מאי שהיה, על ענייני Availability Groups וסנכרון ג'ובים, וגם על דברים שמצפים לנו בהמשך! קישורים רלוונטיים למידע נוסף: Always On Availability Groups in Standard Edition Automatically Enable or Disable Jobs based on HADR Role Control SQL Jobs based on HADR Role - Taking it to the next level Synchronize Logins between Availability Group replicas Data Platform Meetup - Israel DbaTools Madeira Free Live Webinars

In this video we are going through the high availability options you have for the mission critical services running within the SQL Server Big Data Clusters. Find out more here:High AvailabilityHigh Availability for HDFS and Spark[00:00] - Introduction[01:00] - Storage recap for Big Data Clusters[02:47] - High Availability options[04:34] - High Availability for SQL Server master instance[06:18] - Availability Groups in Big Data Clusters[07:07] - High Availability for HDFS[07:51] - High Availability for Spark[08:27] - Demo: configuring High Availability in Big Data Clusters[10:55] - Getting started[11:25] - Summary and wrap-up

In this video we are going through the high availability options you have for the mission critical services running within the SQL Server Big Data Clusters. Find out more here:High AvailabilityHigh Availability for HDFS and Spark[00:00] - Introduction[01:00] - Storage recap for Big Data Clusters[02:47] - High Availability options[04:34] - High Availability for SQL Server master instance[06:18] - Availability Groups in Big Data Clusters[07:07] - High Availability for HDFS[07:51] - High Availability for Spark[08:27] - Demo: configuring High Availability in Big Data Clusters[10:55] - Getting started[11:25] - Summary and wrap-up

Chris and Chris return with an active-passive approach to all things High Availability; they talk Log Shipping, Replication, Clustering, Mirroring and Availability Groups. In the news we hear the latest Microsoft announcement along with our regular Data Breach round-up. Reminiscing about his time at PASS Summit in Seattle, Chris has an Un-win whilst enjoying a can of Pike IPA. So, grab yourself a beer and tune in - cheers!

Guy is back from New Zealand. we talk a little bit about his trip, SQL Server 2019, pagination techniques and performance, projections in Vertica, lessons learnt from Availability Groups performance case, and more

Show Notes:  How to Set Up Availability Group with a Domain Account How to Start SQL Server Without Tempdb? Auto-Commit vs. Implicit Transactions What's between Corruption and Blocking? What Machine Learning Can Do?

One of the newer features in SQL Server is availability groups, which can help solve a number of business problems.  As administrators, availability groups introduce some complexity as we are tasked to make sure the Recovery Point Objective (RPO) and Recovery Time Objective (RTO) can be meet for these servers.  The complexity comes because we have different instances that must work together, but they don't always see eye to eye.  In this episode, we chat with Tracy Boggiano of channeladvisor about how they go about monitoring their availability groups and the pros and cons of the out of the box tools.  Our discussion touches on process of  the availability group process and Tracy has posted her scripts on her bog for you use as you look at reviewing your environments.  I think you will enjoy this discussion. The shownotes for today’s episode is found at http://sqldatapartners.com/2017/06/29/episode-102-monitoring-availability-groups/ and have fun on the SQL trail.

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. 

Have you ever wondered what the best option is for making your data available in your environment? Listener Chris Hendon asked us to talk about differences between Availability groups, mirroring, log shipping, and replication. Today on the SQL Trail Steve and I chat with Andy Mallon and Mariano Kovo about these topics. We cover each topic in detail and explain the positives and negatives of each one.  Join us, for another great episode. The show notes for today's episode are available at http://sqldatapartners.com/2016/08/24/data-availability/

Clustering is a now tried and true technology to help increase the availability of your SQL Server environment.  I talk with Paul Popovich about his experiences with clustering and how his approach has changed as the technology has evolved.  If you are looking for a good introduction to some concepts of clustering, this episode is for you!  It should be noted this episode does not include the new feature of Availability Groups. You can view the show notes for this episode at http://sqldatapartners.com/2015/10/03/clustering/