All articles

Why UUIDv7 does not reduce fragmentation in SQL Server

UUIDv7 places its timestamp first, but SQL Server compares uniqueidentifier values starting from the last bytes. Measured on 25,000 inserts: no gain over NEWID().

M-Files AI: from Intelligent Metadata to AI Agents

For years, the primary role of artificial intelligence in enterprise content management (ECM) has been to analyse documents. This involved extracting information, classifying documents, suggesting properties, and identifying similar content or patterns. To be honest, that was(…)

MongoDB DMK 2.6.0 : pymongo integration and new features

In this blog, I will present the new features introduced with the latest release (2.6.0) of the MongoDB DMK. The DMK is a set of standardized tools that aims at easing the work of DBAs by having dbi’s(…)

AWS Summit Zurich 2026 Edition

New AWS Summit, new day to learn new stuff and deepen my knowledge of this cloud provider. As a starter, I attended the Keynote. The various speakers explained to us the benefits of AWS for startups, how they(…)

Rename a GoldenGate Extract Without Missing Transactions

Throughout my consulting missions, I have often been asked to rename GoldenGate extracts. While this is not a difficult task, it should still be done correctly to avoid missing transactions. In this blog, I will explain how to rename(…)

The forgotten power of relationships in ECM

In many people’s minds, an Enterprise Content Management System (ECM) is just a shared folder on steroids: enhanced security, lifecycle tracking, and more efficient search capabilities. This is broadly true and can encourage user adoption by explaining what(…)

GoldenGate DB2 z/OS Upgrade Checklist

Upgrading GoldenGate when the source is DB2 for z/OS is not quite the same exercise as upgrading a GoldenGate installation for Oracle. Most of what I described in my generic blogs about planning a GoldenGate(…)

Fixing ORA-00904 on Oracle hidden columns during SSMA data migration

SSMA fails with ORA-00904 on Oracle SET UNUSED columns. Fix it with a custom select aliasing NULL, no source DDL required.

NGINX Secured Distribution Path with GoldenGate REST API

In a previous blog, I presented how to set up a distribution path between two GoldenGate deployments both secured with NGINX. The method I used there was purely through the Web UI. But GoldenGate also(…)

GoldenGate 26ai out-of-place patching with Python

I already covered out-of-place patching from the web UI, but patching tasks should be automated, and clicking through the same screens for every deployment can get repetitive. Let’s do the exact same out-of-place patch of(…)