Infrastructure at your Service

Availability groups Archives - Blog dbi services

David Barbarin

SQL Server 2019 availability groups – Introduction to R/W redirection

By | Database Administration & Monitoring, Database management, SQL Server | 3 Comments

writeThis is a second write-up about SQL Server 2019 CTP2.0 and availability group new features. This time the interesting one is about READRWRITE redirection capabilities. A couple of months ago, I wrote about SQL Server 2017 and new read-scale capabilities and listener management challenges regarding the operating system. Indeed, there are some scenarios where including listener will not as easy as we did with common ones on the top of Windows operation system. A list of…

Read More
David Barbarin

SQL Server availability groups, SQL Browser and Shared Memory considerations

By | Database Administration & Monitoring, SQL Server | No Comments

Few weeks ago, my colleagues and me discussed availability groups and network considerations for one of our customers including disabling SQL Browser service and shared memory protocol. The point was disabling both features may lead to unexpected behaviors when creating availability groups. Let’s start with the SQL Browser service. It is not uncommon to disable this service at customer shops and to use directly SQL Server listen ports instead. But if you go trough the…

Read More
David Barbarin

First steps into SQL Server 2019 availability groups on K8s

By | Cloud, Database management, DevOps, SQL Server | No Comments

A couple of weeks ago, Microsoft announced the first public CTP version of next SQL Server version (CTP2). It is not a surprise, the SQL Server vNext becomes SQL Server 2019 and there are a plenty of enhancements as well as new features to discover. But for now, let’s start with likely one of my favorites: availability groups on Kurbernetes (aka K8s). As far I may see from customers and hear from my colleagues as well,…

Read More
David Barbarin

24 HOP French edition 2017 – Session videos are available

By | SQL Server, Technology Survey | No Comments

The 2nd edition of 24HOP French Edition 2017 is over and we had great sessions about SQL Server and various topics ( SQL Server 2017 new features, Azure, PowerBI, High Availability , Linux, Hyper-convergence , Modeling …) If you did not attend to this event, you now have the opportunity to watch the videos of the different sessions. From my side, I had the chance to present SQL Server and High Availability on Linux. Hope to…

Read More
David Barbarin

Prochaine édition des 24 HOP 2017 francophone

By | Technology Survey | No Comments

La prochaine édition du 24 Hours of PASS 2017 edition francophone se déroulera les 29-30 juin prochain. Pour rappel le format est simple: 24 webinars gratuits répartis sur 2 jours de 07:00 à 18h00 GMT et en Français. La seule obligation: s’inscrire aux sessions auxquelles vous assisterez. Cela vous permettra également de récupérer l’enregistrement vidéo si vous voulez la visionner à nouveau par la suite. Cette année il y en aura encore pour tous les goûts. Du…

Read More
David Barbarin

SQL Server 2017 AlwaysOn AGs and new read-scale architectures

By | Database Administration & Monitoring | 4 Comments

As you probably know Microsoft announced an official name for SQL Server vNext during the last Microsoft Data Amp event on April 19 2017. It becomes officially SQL Serve 2017. In my first blog post, I wrote about SQL Server on Linux and the introduction of availability groups features. At this moment the SQL Server release version was CTP 1.3. As a reminder, with previous CTP releases, listeners were unusable because they did not persist when…

Read More
David Barbarin

Speaking at the next SQL Nexus at Copenhagen 2017

By | Database Administration & Monitoring | No Comments

On May 2nd, I will have the chance to speak during the next SQL Nexus event in Copenhagen (1 -3 may) about SQL Server 2016 and availability groups and if I have enough time, you will see what is coming with the SQL Server vNext. This is also a good opportunity to attend to other sessions held by well-known people in the industry like David Klee, Edwin M Sarmiento, Wolfgang Strasser and Uwe Ricken  to name a…

Read More
David Barbarin

Introducing AlwaysOn availability groups on Linux

By | Database Administration & Monitoring | No Comments

A couple of days ago, Microsoft has rolled out the SQL Server vNext CTP 1.3 which includes very nice features and the one that interested me in the supportability of AlwaysOn availability groups on Linux. That is definitely a good news because we may benefit from new ways of architecting high-availability. There are a lot of new cool enhancements, which we’ll try to study when writing new blog posts. In this first blog, let’s learn…

Read More
David Barbarin

Dealing with WSFC 2016 quarantine state and availability groups

By | Database Administration & Monitoring, Operation systems | One Comment

I was playing with my lab environment which includes Windows 2016 and SQL Server 2016 and I noticed an interesting scenario while testing cluster node failures. After simulating some network outage scenarios, I was not able to bring back my cluster node online immediately by using traditional way. A quick look at the cluster manager led me to notice something new: A quarantined state value … interesting! But what does it mean exactly? In respect…

Read More
David Barbarin

Migrating your existing availability group infrastructure to 2016

By | Database Administration & Monitoring | One Comment

Have you already a plan to migrate your old SQL Server 2012 availability group infrastructure to windows 2016 and SQL Server 2016? In a previous post, I talked about distributed availability groups and cross-cluster migration scenarios but this time the game is not the same because we want to achieve an in-place upgrade of the existing AG infrastructure. This question will probably be a concern the next year and if we take a closer look…

Read More