Database Administration & Monitoring

First steps on Kusto Query Language (KQL)

Do you know this query language?  No, it’s time to explain you and see what it is.   “A Kusto query is a read-only request to process data and return results.” dixit Microsoft Documentation here The KQL(…)

Network configurations on ODA

Network configurations on ODA(…)

8000 databases in one PostgreSQL cluster?

A while ago I posted this tweet on Twitter: #Postgresql friends: 8000 databases. One cluster, 8000 clusters, Kubernetes,, what would be your choice? Let's assume 10gb per database. I know backup/restore, inodes etc, no discussions about(…)

Oracle 21c : Two nodes Grid Infrastructure Installation

By Mouhamadou Diaw Oracle 21c is actually released in the cloud, and I did some tests to setup a Grid infrastructure cluster with two nodes. I used following two VM servers to test racp1vm1 racp1vm2 Below(…)

An introduction into server side programming in PostgreSQL – 3 – PL/pgSQL, procedures

In the first to posts in this series (An introduction into server side programming in PostgreSQL – 1 – SQL functions, basics , An introduction into server side programming in PostgreSQL – 2 –(…)

SQL Server tips: How to migrate database-users in another domain without touching permissions

By a customer, I must migrate a database from a domain to another. The goal is to keep the database-user permissions, take the new SID from the windows login of the new domain and change the database-user name.

An introduction into server side programming in PostgreSQL – 2 – SQL functions, sets, udts and polymorphic types

This is part two of the little series about server side programming in PostgreSQL. In the last post we had a look at the basics when it comes to SQL functions. We learned how to write those(…)

PostgreSQL High Availability: Patroni, Ectd , HAProxy , Keepalived

By Mouhamadou Diaw Patroni is one the most famous tool that can be used to setup a high avalaibilty for PostgreSQL. In this blog I am describing a test I did. Below the environment we will(…)

An introduction into server side programming in PostgreSQL – 1 – SQL functions, basics

Over the last years I've seen many different applications running against PostgreSQL. The use cases vary from simple applications, which only use basic data types and a few tables and views, to complex applications with custom types, more specific data(…)

How long does it take to redeploy an ODA X8-2M?

Introduction One of the advantage of Oracle Database Appliance is its fast deployment. Most often, the initial setup of a lite ODA (with a reimaging) only takes half a day, from unboxing until a first test database is available. Trust(…)