Database Administration & Monitoring

Disaster Recovery Solution to Azure SQL Database

Executive Summary As preparation for migrating his MS SQL workload to the cloud, a customer ask for a disaster recovery solution from an On-Premise MS SQL Instance to an Azure Cloud. The starting point for the disaster recovery will be(…)

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

Oracle 21c Gradual Password Rollover : Tracking old password usage

By Mouhamadou Diaw In a previous blog, I talked about the new feature in Oracle 21c, which allows an old and new password to be valid during a period of time. This feature, Gradual Database(…)

TimescaleDB

Introduction TimescaleDB is a “time-series” database (TSDB). This kind of databases are optimized for storing, manipulating and querying time-series data. But… what is time-series data ?Time-series data is a collection of metrics (regular) or measurements (irregular)(…)

Migrating Non-CDB to Multitenant

By Mouhamadou Diaw Dealing these last days to database migration with a customer, I write this blog to describe the main tasks The context is to migrate databases to a new infrastructure. Below the configuration Source : Linux Suse(…)

PostgreSQL 16: More I/O statistics

PostgreSQL is already tracking various kinds of statistics which can help in identifying bottlenecks. Some of these statistics are available in the the pg_statio_* catalog views: postgres=# select viewname from pg_views where viewname like '%statio%'; viewname -------------------------- pg_statio_all_sequences pg_statio_all_tables pg_statio_sys_tables(…)