All articles

SQL Server vs MongoDB: When the cloud is your adversary (Always Encrypted vs Queryable Encryption)

When the cloud admin is the threat: how SQL Server and MongoDB let you query encrypted data, and what each approach costs.

Wait stats and Sub-NUMA clustering 

During a healthcheck at a client’s site, we collected performance data from a SQL Server 2019 Enterprise instance hosting a BI / data warehouse workload. Two lines in the wait statistics report immediately caught the eye: hundreds of hours(…)

GoldenGate Extract Abending on NFS Trail: OGG-02897 / OGG-01668 Input/Output Error

While working on a client’s GoldenGate 26ai environment, I ran into a NFS-related replication issue that could have been serious, had it happened in production. Here is what happened and how the issue was fixed. The client’s GoldenGate(…)

Green SQL Server DBA Tips #3 – The hidden cost of forgotten databases

How many times have I found, during a migration, that I also have to clean up the databases no more used?Why keep them for so long if we’re not going to use them? This is something we often(…)

MongoDB OIDC Authentication with Okta

Since version 7.0.11, MongoDB natively supports OpenID Connect (OIDC) authentication. This move was part of MongoDB’s cloud strategy, since cloud environments use OIDC a lot for authentication and authorization. In version 8.0, MongoDB deprecated LDAP(…)

Oracle: Standard Edition 2 available with 23.26.3.?

When downloading Release Update 23.26.3., I could see this: As you can see in the Product info it also has “Oracle Server – Standard Edition”. However, I haven’t found anything official yet. I tried it and could(…)

PostgreSQL Snapshot Backup and Restore with Proxmox ZFS (4/4)

In the blog series I previously wrote, I did not answer all the customer’s questions. The last one was the following: Can this also be applied to PostgreSQL? In short, yes, it is possible. Let’s see(…)

SQL Server:  msdb is in Suspect State

This Monday morning, we begin our SLA Support with a customer call.He cannot do a select on a table in his database… After creating the Ticket, I connect to the instance and see that the msdb system(…)

Simplified Distribution Path Creation in GoldenGate 26.3

The 23.26.3.0.0 release update of GoldenGate 26ai (July 2026) ships a small but welcome usability change, listed in the New Enhancements section of the release notes: Bug 39415027: Generic – Simplified Distribution and Receiver Service Path Configuration(…)

Removing rpm with dnf implies removing systemd

On an Oracle Linux 8, I installed a new package and did not pay attention that dnf used an old Oracle Linux 7 repository. Trying to remove it again, I was getting following error: Error:Problem: The operation would result in(…)