All articles

Contained Availability Groups error

During my testing about the new SQL Server 2022 feature Contained Availability group I faced an issue during the creation of the system databases on the secondary instance. I used the wizard to create a new Contained Availability Group and(…)

Changing Fusion Middleware Forms and Reports repository database

I have been requested to migrate the Fusion Middleware repository database from one Linux server to a new one. Here are the steps followed to successfully do this. In the following of this document, the Fusion Middleware repository created using(…)

Get SQL Server database size with PowerShell

Introduction For various reasons, following the evolution of the data size of databases is interesting for a dba or for the application team. Most of the time, this is something built-in for monitoring tools – convenient to follow the evolution(…)

WebLogic Licence Compliance and Out of Memory Errors

Recently, at a customer site, I faced an issue of WebLogic Admin server which crashes because it reached Java Virtual Machine (JVM) limit. Xms and Xmx were set to 1Gb. Expected behavior is that Node Manager detects it and restart(…)

Reminder about SSMS

As you know, since SQL Server 2016, SQL Server Management Studio is not anymore part of the SQL Server ISO files and needs to be downloaded independently. If you want to have a complete list of all SSMS versions please(…)

Major PostgreSQL version upgrade in a Patroni cluster

Introduction One of my customer recently asked me to upgrade its PostgreSQL instance from version 9.6 to version 14.3. The infrastructure is composed of 4 servers : – DB02-04 – Ubuntu 20.04 – supporting PostgreSQL, Patroni, HAProxy and etcd–(…)

Ansible: Imagination is the Limit

As you might know, I have discovered Ansible 1 year ago. Since then, I am not using for its main purpose as wikipedia says: Ansible is an open-source software provisioning, configuration management,(…)

Facial recognition, between advanced biometrics and needs for privacy… – Part 2 of 4

Continuation of our series on facial recognition. After defining facial recognition among the biometric processes (see here), let’s see the techniques used for its application. State of the art of the techniques used for its application The(…)

Will ExaC@C change or kill your DBA job?

Introduction Exadata Cloud@Customer (ExaC@C) from Oracle is an hybrid solution for customer willing a Cloud-like platform without actually being in the public Cloud. Behind cloud’s concept is a high-level management of complex stuff, like provisioning homes and databases, patching, aso.

CIFS mounts no more compatible with ODA

Introduction Some of us are using CIFS mountpoints on the ODA. This is mostly for sharing files with Windows application servers. On ODA, as on other Linux setup, it works like a charm. But it ends working starting from patch(…)