Database Administration & Monitoring

Oracle 21c: Blockchain Tables

Oracle Blockchain Tables With Oracle Database 20c/21c the new feature Oracle Blockchain Tables has been introduced. Blockchain Tables enable Oracle Database users to create tamper-resistant data management without distributing a ledger across multiple parties. Database security can be improved by(…)

Pressure Stall Information on Autonomous Linux

By Franck Pachot . The Linux metrics that are usually considered for performance monitoring and troubleshooting have many drawbacks and frequent misinterpretations. The recent kernels provide PSI (Pressure Stall Information) which is not enabled by default in Oracle Linux(…)

JENKINS Add new users on Jenkins

Hello everybody , today we will see how to manage user creation on Jenkins As many other scheduling software, Jenkins has tool to manage credentials and also grant access to users. Best practice to manage user right level is(…)

Dealing with German “Umlaute” in PostgreSQL’s full text search

PostgreSQL comes with build-in Full Text Search and you can do quite amazing stuff with it. A question that popped up during one of the last PostgreSQL for developers workshop was: How(…)

How to quickly download the new bunch of 21c Oracle Database documentation?

Last month, Oracle released its new 21c version of the database documentation. At that time, I was looking for a quick mean to get all the books of this so-called 21c Innovation Release. I could remember I used a(…)

Migrate Oracle Database 9.2.0.6 to Oracle 19c using GoldenGate

When a customer wanted to take the challenge to migrate an oracle database 9.2.0.6 (the prehistory in the Oracle world) to Oracle 19c using Oracle GodenGate, I saw more problems than add value for different reasons:  Oracle 9.2.0.6 database is(…)

Cluster level encryption for PostgreSQL 14

The discussions how and why TDE (Transparent data encryption) should be implemented in PostgreSQL goes back several years. You can have a look at these two more recent threads to get an idea on how much discussion happened around that(…)

Running two Patroni on one host using an existing etcd

Have you ever asked yourself, how to create a second Patroni PostgreSQL cluster on an existing server using the existing etcd? My first idea was to study the documentation of Patroni, but unfortunately without big(…)

Validate your SQL Server infrastructure with dbachecks

Introduction In this blog post, I’ll do an introduction to the PowerShell module dbachecks. dbachecks uses Pester and dbatools to validate your SQL Server infrastructure. With very minimal configuration you can check that(…)

Oracle 21c Security : Mandatory Profile

By Mouhamadou Diaw With Oracle 21c, it is now possible to enforce a password policy (length, number of digits…) for all pluggable databases or for specific pluggable databases via profiles. This is done by creating a mandatory profile in the(…)