Database management

Lost access to SQL Server. Now what ?

In this blog we will explain what to do to regain the access to your SQL Server instance. Here is our scenario : – You have by accident removed all logins in SQL Server instance – Your sa account by(…)

Oracle Database Backup Cloud Service

In a previous blog I demonstrated how to migrate an Oracle database from AWS to Oracle OCI using Data Guard. But what if you want to migrate to the Oracle Cloud, but don’t have a direct connection between the(…)

Unplug/Plug PDB in TDE Environment

By Mouhamadou Diaw In an oracle environment with Transparent Data Encryption (TDE) the transfer of PDB may require additional steps. In this blog we will see some steps which may be required when doing Unplug and Plug  of pluggable(…)

Flexible Server for PostgreSQL, Status March 2023

As many know about a year ago I wrote some critical posts about Microsofts Flexible Server for PostgreSQL, now it is time to take a look again. At first, many promised functions where delivered with a latency of about one(…)

Starting PostgreSQL logical replication for some tables based on a dump

Recently at a customer we faced a somehow strange issue: We’ve setup logical replication from a public cloud managed PostgreSQL service to a PostgreSQL instance on a VM hosted by the same public cloud provider. For most of the tables(…)

SHELL SCRIPTING: improve DBA scripts readability using J2 templates

Quering database's by using SQL in shell scripts can make the whole script unreadable. Very oftent the query is unredable too, due to the variable usage. This situation make the script debugging a pain. Templating simplify the script by taking(…)

More compression options for pg_dump in PostgreSQL 16

The last releases of PostgreSQL already introduced new options for compression, see here and here. PostgreSQL 16 will build on top of that and will come with LZ4(…)

Oracle TDE part II : Encrypting Data

By Mouhamadou Diaw In the first part of this blog, we activate TDE in the database, in this part we will see how we can encrypt data. I am using Oracle 19c for the tests As specified before TDE(…)

Oracle TDE part I : Configuring the Encryption

By Mouhamadou Diaw Oracle gives us some tools to secure our data in transit and in rest. Oracle Transparent Data Encryption will allow us to encrypt data in rest. Oracle TDE need The Oracle Advanced Security License Oracle TDE(…)

The Option -applyRU of runInstaller

By Mouhamadou Diaw RU, MRP should be applied to database home as soon as possible. Usually we often nstall the base version and after install the RU on top on the base version For example we want to have(…)