Database Administration & Monitoring

PostgreSQL 16: More flexibility for vacuum and analyze

Update 14-Dec-2022: Please see this post, the content here is not anymore up to date. While PostgreSQL 15.1 was released some weeks ago PostgreSQL 16 is already under active development. Two(…)

Azure SQL Managed Instance link feature overview

In one of my last blog-posts I spoke about Striim which is a data replication platform that can be used for migrations but also for offloaded reporting or even real-time analytics.A new Azure feature, currently on preview, named Link(…)

An introduction to OMrun – 2 – Working with parameters

In the last post we compared the list of databases in the same PostgreSQL cluster using OMrun. The setup for this was pretty simple: We’ve defined the environment using the PostgreSQL Data Adapter and created the(…)

An introduction to OMrun – 1 – A simple data comparison with the PostgreSQL Adapter

With the integration of OMIS into dbi services we also got a new product: OMrun. OMrun is all about data, especially comparing, validating and anonymizing data from various sources against various targets.

dbachecks: how to add your own checks

As a DBA I used more and more the dbachecks at customer place to validate environments. It became part of our DBA toolkit at the same place than its famous brother the dbatools.My colleague Steven Naudet did a(…)

Recreate a Patroni replica using pgBackRest

In my last blog we had a look on how to bootstrap a complete Patroni Cluster from pgBackRest. But there is also the possibility to recreate only one Patroni node using pgBackRest. In this blog we(…)

Patch a SQL Server instance automatically with PowerShell

In my last blog post I explained how to automatically download the last Service Pack and Cumulative Update for all versions of SQL Server.Here I will show you how to patch your SQL Server instances automatically with some cmdlets(…)

ODA : Do You Know The MOVE Table In MySQL DB Repository

By Mouhamadou Diaw During a consulting on a customer, we faced the following issue when trying to delete a dbhome Message:  DCS-10001:Internal error encountered: PRGO-2470 : Working copy “OraDB19000_home1” is involved in an incomplete move or upgrade operation The(…)

PostgreSQL: Dropping a table automatically if another table is dropped

Imagine the following use case: You have a table t1, and based on it’s contents you create another table t2. What you want to achieve is: If table t1 gets dropped, you want to have table t2 to be dropped(…)

Bootstrap Patroni Cluster from pgBackRest Backup

While preparing myself for the pgconf.eu in Berlin this week I made a lot of research regarding Patroni and pgBackRest. I was aware that it’s possible to recreate a replica from a pgBackRest backup. But I was also wondering, what(…)