All articles

Oracle Database 26ai Client and SQLNET.EXPIRE_TIME

We have been facing one issue at one of our customer where the Oracle Client connections remained opened for days blocking some avaloq JobNetz. We have been doing some tests and we could fortunately find a solution resolving the problem(…)

Azure Bootcamp Switzerland 2026 edition

Today I attended the Azure Bootcamp Switzerland event in Bern. Here is a summary of what I saw and what I learned in the sessions. The opening keynote was about Azure Sovereign Architecture where the presenter gave us an(…)

Reduce downtime when refreshing your non-production databases using Multitenant

Introduction You probably refresh your non-production Oracle databases with production data from time to time or on a regular basis. Without Multitenant, the most common procedure to do this refresh is a DUPLICATE FROM BACKUP with RMAN. The drawback is(…)

OGG-08502 Path not found error from OGG Receiver Service

Recently, after a successful migration to GoldenGate 26ai, a customer complained that he was seeing a lot of the following error in the ggserr.log file of a GoldenGate deployment (I replaced the names for the purpose of this blog). 2026-05-18T14:32:35.948+0200(…)

What being an external consultant really changes

When people think about consultants, they usually focus on expertise. “They bring experience, frameworks, and best practices.”That’s true, of course. However, that is not the most impactful aspect of the role.The real shift happens somewhere less visible: positioning. As an(…)

Install and configure OEM plug-in for GoldenGate

If you are licensed for the GoldenGate Management Pack, using the Enterprise Manager plug-in for GoldenGate improves monitoring and management of your deployments. And after migrating to the Microservices Architecture, you should definitely update your plug-in and rediscover all targets.

Customer case study – automating SQL Server TLS Encryption with Ansible and Certificates (Architecture)

When working with SQL Server environments, securing client connections can become an important requirement, especially when TLS encryption must be implemented using certificates. In this context, a customer asked us to develop an Ansible playbook and role to automate the(…)

How Row Goal shapes your SQL Server query strategy by hunting for pierogis

Mastering SQL Server Row Goals and how TOP, EXISTS, and FAST N influence execution plans and how to avoid performance traps in your queries(…)

SQL Server Snapshot Backup and Restore with Proxmox ZFS – REST API with SQL Server 2025 (3/3)

The proposed architecture consists in adding a small internal REST API on the Proxmox server in order to expose a controlled ZFS snapshot operation. SQL Server 2025 can then call this API through sp_invoke_external_rest_endpoint, instead of running SSH commands directly(…)

SQL Server Snapshot Backup and Restore with Proxmox ZFS – Powershell implementation (2/3)

In the previous section, we discussed the drawbacks of running the commands manually. Indeed, the manual process was taking too much time and could directly impact the database state while the freeze was occurring. To address this issue, it is(…)