Skip to content

Operating System

The Linux, Unix and Windows layer that every database and application depends on. Our consultants share what they set up and fix in the field: storage and filesystems, networking, virtualization, SUSE, and hardware such as the Oracle Database Appliance.

Oracle and btrfs snapshots

In my last blog post Snapshots with VirtualBox and btrfs we have seen some possibilities of btrfs snapshots. In this blog post we will see how we can use btrfs snapshots in combination with an Oracle database to clone PDBs. My colleague Marc Wagner has shown in his article the possibilities and the limitations of snapshot clones of a PDB.… 

Snapshots with VirtualBox and btrfs

Snapshot mechanism of VirtualBox With VirtualBox you can take snapshots of the current state (without snapshot functionality of a filesystem like btrfs) This kind of snapshot will create a kind of differential file and the original file will be untouched. Every changed block is written to this difference file in the Snapshot/ directory. If you will do tests with always… 

Setup an LDAP server for Oracle naming on Enterprise Linux 9

Introduction To centralise Oracle naming resolution, you can use an LDAP server. You can use the commercial products from Oracle like Oracle Internet Directory (OID) or Oracle Universal Directory (OUD). Alternatively, you can also use OpenLDAP from your Linux distribution. I have used this successfully with customers for many years. I now wanted to build a new test environment for… 

When tempdb write latency points below SQL Server

During a recent performance review on a SQL Server 2019 instance (AlwaysOn Failover Cluster Instance, bare-metal), one number stood out. This post follows the investigation: from a latency figure in a DMV, down the I/O path to a RAID controller setting nobody had ever chosen. The starting point: one number from a health check The I/O statistics of the instance… 

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 of parallelism waits accumulated in only 11 days of uptime.  Here are the questions that arise  The waits themselves were not… 

Customer experience – Certificat SSL on an SQL Server Reporting Services

Recently, I had to renew an SSL certificate on an SQL Server Reporting Services (SSRS) server. The task seemed straightforward: replacing an expired certificate with a new one containing the same configuration. However, once the change had been made, HTTPS wasn’t working anywhere — neither via the usual DNS names nor even when accessing the server directly. Only HTTP remained… 

Highly Available, Load-Balanced PostgreSQL with Patroni, HAProxy, and Keepalived

Patroni runs your PostgreSQL cluster and handles failover, promoting a replica the moment the primary dies and recording the change in its distributed store (etcd, Consul, or ZooKeeper). That part works on its own. Your applications still need one stable address to connect to, and they need writes to reach the primary while reads spread across replicas. HAProxy handles that… 

Upgrade RHEL from 9.6 to 10.1 (when running PostgreSQL/Patroni)

Upgrading from RHEL 9.6 to 10.1 is not just a routine update, it’s a major platform shift. When your server runs PostgreSQL compiled from source and a Patroni-managed cluster, the complexity increases significantly. System libraries change, Python environments break, ICU versions evolve, and your database binaries may no longer start after reboot. In this guide, I walk through a real-world… 

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

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 or relying on an external tool. The role of the API is deliberately limited: it receives a snapshot request, checks… 

SQL Server Snapshot Backup and Restore with Proxmox ZFS (1/4)

We are currently working with clients on migrations to SQL Server 2022 and SQL Server 2025. During a discussion with one client, we reviewed some of the benefits introduced in the latest SQL Server 2022 and 2025 releases. Among the available features, starting with SQL Server 2022, we have: Starting with SQL Server 2025: The customer’s environment consists of a… 

Overcoming RDP connection issues on Windows 11

The problem: I faced an issue today where one of my colleagues was struggling to remotely connect to a Windows server via RDP. He was using the default Remote Desktop app that comes standard with Windows 11 and everytime he’d connect, the application would hang at login. Something between 2 to 4 minutes, until he could finally type his password…