All articles

What is the most secure way to call an external job from an Oracle (pluggable) database?

I recently asked myself this question after having been confronted with a quite challenging situation, which will be been dissected in this post. Indeed, most of the DBA are aware about several mechanism offered by the Oracle database engine to(…)

PRGH-1030 when doing restore-node -g on ODA

Introduction Patching your Oracle Database Appliance from 19.20 or earlier release to 19.21 or newer release implies the use of Data Preserving Reprovisioning (DPR). Most of the time, and with an adequate preparation, the DPR works fine. But if something(…)

pgvector, a guide for DBA – Part3 AI agent and workflows

Introduction Nowadays, everyone in IT is well versed in using ChatGPT and other LLM-powered Chat to retrieve information like Google or try to learn something with it. The problem with those models is their accuracy. Current AI models only know(…)

PostgreSQL 18: More granular log_connections

Many of our customers enable log_connections because of auditing requirements. This is a simple boolean which is either turned on or off. Once this is enabled and active every new connection to a PostgreSQL database is(…)

Why Metadata Matters?

In today’s digital landscape, efficient Content Management is crucial for business productivity. While many organizations still rely on traditional folder-based file management. Modern solutions like M-Files offer a smarter way to store, organize, and retrieve information. The key differentiator?(…)

pgvector, a guide for DBA – Part2 indexes

Introduction In the last blog post we did setup a LAB with a DVDRental database mixed with Netflix data on top which we created some embeddings hosted on the same tables thanks to pgvector. In this second part, we(…)

Oracle Technology Roundtable for Digital Natives – Let’s have a look at AI, Cloud and HeatWave

Yesterday I participated to the Oracle Technology Roundtable for Digital Natives in Zurich. It was a good opportunity to learn more about AI, Cloud and HeatWave with the focus on very trendy features of this product: generative AI,(…)

M-Files Property Calculator

M-Files is a powerful product in itself, that enables businesses to organize, manage, and track documents efficiently.But we can even make it more powerful by extending the out of the box capabilities with Property Calculator, a really useful tool. Previously(…)

PostgreSQL: Unlogged tables and backups

Recently we faced the following situation and have been asked to analyze the issue: A dump was loaded into a primary instance of PostgreSQL, but the data did not reach the replica. Tables which have been added after the dump(…)

Starting with PowerShell 7 and parallelization

For the time being Windows PowerShell 5.1 is installed with Windows Server. It means that if you want to use or even test PowerShell 7 you need to install it by your own.To be honest, even if I’m using PowerShell(…)