All articles

Oracle to PostgreSQL Migration with Flink CDC

Introduction When wanting to migrate from the big red to PostgreSQL, most of the time you can afford the downtime of the export/import process and starting from something fresh. It is simple and reliable. Ora2pg being one of the(…)

Common queries on a SQL Server environment for a DBA

This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation.. For this blog, you will only need SSMS and sysadmin(…)

Avoid CORS requests in development mode with Vite

When developing a modern web application, it’s common to use a frontend (Vue, React) that communicates with a backend (Nest.js) via REST APIs. Often, the two projects live in parallel, requiring them to be run in development mode. Without(…)

Benachrichtigungen in M-Files

Was sind Benachrichtigungen in M-Files In M-Files besteht die Möglichkeit, Benachrichtigungen, sogenannte Zuweisungen, auf Basis von Ereignissen zu automatisieren. Die M-Files Benutzer werden zum einen direkt in M-Files mittels Zuweisungen informiert und zum anderen per(…)

M-Files Workspaces: Context First

In one of my previous blog I announced a big improvement in M-Files: the Workspaces. Following a period of discovery and experimentation that spanned multiple weeks, the logic behind this enhancement is now apparent.

Customer experience – How to change ip address in a fully clustered environment

If you have a clusturized environment already up and running, but you want or need change the complete ip adress of your wall with minimal downtime (full downtime during operation: 3 min). You’re in the right place, I(…)

Exascale Infrastructure : new flavor of Exadata Database Service

Oracle unveiled Exadata Database Service on Exascale Infrastructure in summer 2024. In this blog post, the first of a series dedicated to Exascale, we will dive into its architecture after a brief presentation of what Exascale is. Introduction Exadata(…)

OGG-00423 when performing initial load with GoldenGate 23ai

Very quick piece of blog today to tackle the OGG-00423 error. There is not much information online on the matter, and the official Oracle documentation doesn’t help. If you ever stumble upon an OGG-00423 error(…)

SQL Server 2025 release

Microsoft has announced the release of SQL Server 2025. The solution can be downloaded using the following link: https://www.microsoft.com/en-us/sql-server/ Among the new features available, we have: The introduction of the Standard Developer Edition, which offers the same(…)

ORA-44001 when setting up GoldenGate privileges on a CDB

I was recently setting up GoldenGate for a client when I was struck by a ORA-44001 error. I definitely wasn’t the first one to come across this while playing with grants on GoldenGate users, but nowhere could I find(…)