All articles

RAG, MCP, Skills — Three Paradigms for LLMs Talking to Your Database, and Why Governance Changes Everything

Introduction Throughout my RAG series, I’ve explored how to build retrieval-augmented generation systems with PostgreSQL and pgvector — from Naive RAG through Hybrid Search, Adaptive RAG, Agentic RAG, and Embedding Versioning (not yet released)(…)

MongoDB DMK 2.4.0 : new features

In this blog, I will present the new features introduced with the latest release (2.4.0) of the MongoDB DMK. The DMK is a set of standardized tools that aims at easing the work of DBAs by having dbi’s best practices(…)

Database upgrade to AI Database 26ai (23.26.1) for Linux x86-64 upgrade from 19C in 3 steps using gold images.

This is first from 3 Articles: Database upgrade to AI Database 26ai (23.26.1) for Linux x86-64 upgrade from 19C in 3 steps using gold images. Clusterware / ASM upgrade to 26ai for HAS single instance configuration from 19c. Oracle RAC(…)

Commercial PostgreSQL distributions with TDE (2) EDB Postgres Extended Server (2) TDE

In the last post we’ve looked at how you you get EDB Postgres Extended server installed on your system. In contrast to the version provided by Fujitsu, TDE needs to be enabled when you initialize a(…)

Automate encryption-in-transit for SQL Server

Encryption-in-transit is part of the essential security baseline for SQL Server.Without TLS, TDS packets travel in clear text across the network, making them vulnerable to interception or modification by an attacker attempting to gain access to the system.This is why(…)

OGG-08116 when creating a connection with GoldenGate REST API

When playing around with the GoldenGate REST API, you might have encountered the OGG-08116 error. It happens when using the Create Connection REST API call, with the following endpoint given in the GoldenGate documentation. The OGG-08116(…)

Commercial PostgreSQL distributions with TDE (2) EDB Postgres Extended Server (1) Setup

We’ve already briefly looked at Fujitsu Enterprise Postgres (here and here) when it comes to TDE (Transparent Data Encryption) in PostgreSQL. In this and the next post we’ll look at(…)

ECM Cost Optimization & ROI: How to maximize your M-Files project

Enterprise Content Management (ECM) projects often start with good intentions: reducing chaos, improving compliance, and streamlining processes.Yet many companies underestimate one crucial aspect: the financial impact. The project is often driven solely by the cost of licenses and implementation, such(…)

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

Deploying Azure Terraform code with Azure DevOps and a storage account as remote backend

Why this blog? While I was working for a customer, I was tasked to create an Azure infrastructure, using Terraform and Azure DevOps (ADO). I thought about doing it like I usually do with GitLab but it wasn’t possible with(…)