All articles

PostgreSQL 19: pg_waldump can now read from archives

When PostgreSQL 18 introduced the ability to verify tar based (and compressed) backups with pg_verifybackup there was one limitation: The verification of the WAL files in the tars (or compressed files)(…)

SQL Server 2025 In-Memory: New Cleanup Features & SQLBits 2026 Insights

SQL Server 2025 finally allows dropping In-Memory filegroups, a breakthrough analyzed here alongside expert performance insights from SQLBits 2026.

The metadata trap

You know, metadata is the key of a nice Enterprise Content Management system. It is supposed to make work easier, promising order instead of chaos, findability instead of frustration, control instead of clutter. In the world of document(…)

Deployment removal failed in GoldenGate Configuration Assistant (INS-85038)

Recently, I wrote about deleting a GoldenGate deployment with the REST API, and when investigating this issue, I remembered a limitation of the configuration assistant, which I wanted to talk about. For more information about(…)

EM-90000 SSL Error With GoldenGate Targets in OEM

In this blog, I will explain what needs to be done when registering GoldenGate targets behind NGINX reverse proxy in the Enterprise Manager. More specifically, we will see how to avoid the EM-90000 error related to an SSLHandshakeException.

AutoUpgrade powered easy download and installation of Oracle AI Database 26ai on Linux

With latest versions of AutoUpgrade, downloading and installing Oracle AI Database 26ai on Linux x86 on-premise has become a very simple process. If you want to give a try to Oracle Database 26ai, building a test environment requires minimal effort(…)

Exascale new clone and snapshot capabilities

One of the most game changing capabilities of Exascale are the new clone and snapshot features compared to previous options available with ASM / ACFS. And since the business requirements for clones or snapshots to be made available rapidly and(…)

The hidden cost of “Quick Wins” in ECM projects

This is the fourth and final blog post in the series, that highlights the drawbacks of poor ECM implementation. In almost every enterprise content management (ECM) initiative, the phrase “Let’s get some quick wins” appears early, often with(…)

Delete a GoldenGate deployment when the password is lost

Recently, I was asked how to recreate a GoldenGate deployment if the password for the Security user (the first user created with the deployment) was lost. This is an interesting question that I figured was worth writing about.

Beyond TDE and TLS: Bridging the Data Security Governance Gap in Lower Environments

Why one layer is never enough, why dev environments are your biggest GDPR gap, and how to industrialize their governance.