All articles

Elastic Observability for Application Servers: From Monitoring to Troubleshooting Intelligence

Application servers such as WebLogic, JBoss EAP, WildFly, Tomcat, and WebSphere still run critical business applications in many enterprise environments. However, they are often monitored like basic infrastructure components: CPU, memory, disk, process status, and sometimes port availability. This is(…)

DB2 SQL1598N Licensing Error When Upgrading GoldenGate

While upgrading GoldenGate to 26ai for a DB2 z/OS source, I had to update the IBM Data Server Driver for ODBC and CLI (CLI Driver, in short) alongside it. Since I realized that DB2 driver(…)

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(…)