All articles

AI Isn’t Your Architect: Real-World Issues in a Vue project

In my previous article I generated a Rest NestJS API using AI. Today, I will create a small UI to authenticate users via the API. I will use this simple case to show the limits of coding with(…)

The truth about nested transactions in SQL Server

Nested transactions in SQL Server don’t provide real isolation; @@TRANCOUNT rises, but only the main transaction controls locks.

MongoDB DMK 2.3: new features

The latest MongoDB DMK release (2.3.1) introduces a lot of new features and important changes, which I will describe here. dbi services provides the DMK (Database Management Kit) to its customers for multiple technologies:(…)

What is Forgejo and getting it up and running on FreeBSD 15

In recent customer projects I had less to do with PostgreSQL but more with reviewing infrastructures and give recommendations about what and how to improve. In all of those projects GitLab is used in one(…)

How effective is AI on a development project?

In this article, I will try to evaluate the benefits of AI on a development project and what concrete changes it makes to our development practices. The test case and the approach I chose a familiar environment for(…)

OGG-10556 when starting extract from GoldenGate 23ai web UI

Another day, another not-so-documented GoldenGate error, this time about the OGG-10556 error, which I had when setting up replication on a new GoldenGate installation. After making changes from the web UI in an extract, I ended with the following(…)

Understanding XML performance pitfalls in SQL Server

A deep dive into how SQL Server processes XML, the performance impact of XQuery methods, and why proper indexing matters.

Two days at the KCD Suisse Romande

The 4th and 5th december, I attended KCD Suisse Romande in Geneva. It was a great event in a great place with great people. I really enjoyed the talks and the workshops. First Day: the workshops After(…)

How to patch your ODA to 19.29?

How to patch your Oracle Database Appliance to 19.29(…)

Extend Session Timeout in GoldenGate Microservices Web UI

If you start using the GoldenGate web UI after installing it, you might end up thinking that extending the session timeout would be nice. Since there is no clear Oracle documentation on that matter, here are multiple ways(…)