Database Administration & Monitoring

Reminder about SSMS

As you know, since SQL Server 2016, SQL Server Management Studio is not anymore part of the SQL Server ISO files and needs to be downloaded independently. If you want to have a complete list of all SSMS versions please(…)

A 7 year journey, my longest employment ever

It has been an amazing ride: 1st of May 2022 I have been with dbi services for exactly seven years. This is by far the longest employment in my career. When I started way back in 2015 most of my(…)

First look at SQL Server 2022 Contained Availability Groups

Introduction SQL Server 2022 introduces the new concept of Contained Availability Groups. This is something that DBAs have been waiting for since Availability Groups were introduced 10 years ago. Contained Availability Groups enhance the Availability groups by providing the(…)

SQL Server 2022 Parameter Sensitive Plan optimization

Introduction The Intelligent Query Processing (IQP) feature family is extended with SQL Server 2022.One of the most anticipated features is the Parameter Sensitive Plan optimization. I started to test this new feature. In this post, you will find some(…)

SQL Server 2022 public preview available

This is a small blog post to share that the SQL Server 2022 public preview is available for download. The Microsoft announcement blog post and a summary of the new feature are available here : Announcing SQL Server 2022(…)

Helvetia used AWS SCT & DMS to migrate to AWS RDS for PostgreSQL

One of our long term-time customers, Helvetia, successfully migrated on-prem Oracle databases to AWS, not only because of the licenses, but more importantly: to deploy faster, innovate faster, and use the state-of-the-art open source(…)

Installing MySQL InnoDB Cluster in OKE using a MySQL Operator

During previous months, I've had some time to satisfy my curiosity about databases in containers and I started to test a little bit MySQL in Kubernetes. This is how it all began...

How to upgrade Patroni

It's been a while since I wrote the blog post about PostgreSQL 13 and Patroni 2.0. On this blog I received a comment, if it's possible to explain, how to upgrade from Patroni 1.6 to 2.

How to setup a Consul Cluster on RHEL 8, Rocky Linux 8, AlmaLinux 8 part 2

Within the first part I have described the setup of Consul as replacement for ETCD. Here now the setup ob keepalived, haproxy and patroni. The needed packages I have installed within the first part, so let’s start with the(…)

Configure Data Guard between 2 DB Systems with Oracle 21c

By Mouhamadou Diaw In this previous blog, I have configured 2 DB systems with Oracle 21c in an ODA 19.14. Now let’s continue and show how we can configure a Data Guard between these 2 servers.