BE SHARING

Database Administration & Monitoring

pgDay Paris 2023

24.03.2023 by Daniel Westermann

Another great PostgreSQL community conference is over, and I came back with a lot of impressions yesterday. It was probably the worst time of the year for the conference to happen, as massive strikes are ongoing in France currently. Nothing(…)

Database Administration & Monitoring

Unplug/Plug PDB in TDE Environment

14.03.2023 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 database We plan to(…)

Cloud

Maintenance Azure SQL DBs in Elastic Pool (Private Endpoint) – example based on index fragmentation – password less – azure managed identity

08.03.2023 by Hannes Lissak

How do you check and rebuild your indexes for Azure SQL DBs in Elastic Pool? That question is getting even more interesting if you have only Private Endpoint enabled to connect to the MSSQL DB. Lets get started! Requirements Azure(…)

Database Administration & Monitoring

Starting PostgreSQL logical replication for some tables based on a dump

02.03.2023 by Daniel Westermann

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

Cloud

Estimate the Downtime for an Offline MS SQL Migration: On-Premise to Azure SQL Database

28.02.2023 by Noutsa Tsemo

As you want to migrate your database workload to the Azure Cloud, you must test different aspects of the migration. An important factor for an offline migration is to estimate the duration of the migration process, so the service owner(…)

Business Intelligence

Programmatically change the data source of a Power BI Report

28.02.2023 by Noutsa Tsemo

Executive Summary In this post, I want to demonstrate how to programmatically change the data source of a Power BI report. This can be useful when you develop and test the report then want to publish the report in Test,(…)

Cloud

Disaster Recovery Solution to Azure SQL Database

27.02.2023 by Noutsa Tsemo

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

Database Administration & Monitoring

SHELL SCRIPTING: improve DBA scripts readability using J2 templates

27.02.2023 by Alexandre Nestor

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

Database Administration & Monitoring

Oracle TDE part II : Encrypting Data

23.02.2023 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 will allow encryption at(…)

Database Administration & Monitoring

pgDay Paris 2023

Unplug/Plug PDB in TDE Environment

Maintenance Azure SQL DBs in Elastic Pool (Private Endpoint) – example based on index fragmentation – password less – azure managed identity

Starting PostgreSQL logical replication for some tables based on a dump

Estimate the Downtime for an Offline MS SQL Migration: On-Premise to Azure SQL Database

Programmatically change the data source of a Power BI Report

Disaster Recovery Solution to Azure SQL Database

SHELL SCRIPTING: improve DBA scripts readability using J2 templates

More compression options for pg_dump in PostgreSQL 16

Oracle TDE part II : Encrypting Data