BE SHARING

Database Administration & Monitoring

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

28.02.2023 by Microsoft Team

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 Microsoft Team

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 Microsoft Team

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

Oracle TDE part I : Configuring the Encryption

23.02.2023 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 allow to do encryption(…)

Database Administration & Monitoring

The Option -applyRU of runInstaller

18.02.2023 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 the version21.8 We usually(…)

Database Administration & Monitoring

Oracle 21c Gradual Password Rollover : Tracking old password usage

17.02.2023 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 Password Rollover, is possible(…)

Database Administration & Monitoring

TimescaleDB

15.02.2023 by Joël Cattin

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

Database Administration & Monitoring

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

Oracle TDE part I : Configuring the Encryption

The Option -applyRU of runInstaller

Oracle 21c Gradual Password Rollover : Tracking old password usage

TimescaleDB