All articles

How to efficiently add constraints to existing tables in PostgreSQL

Is is not a surprise that applications change over time. New tables get added, columns need to be changed or new ones are required, and sometimes you need to add check constraints or foreign keys to already existing tables which(…)

First contact with OCI’s Autonomous Database

Introduction Benefits of going into the Oracle Cloud (OCI) are clear for most of us: no more datacenter and hardware to manage. But what else? On OCI, you can also decide to get rid of part of the DBA tasks(…)

SELECT FROM DUAL : Oracle Performance And Tuning

The DUAL table is automatically created by Oracle and contains one column (DUMMY) and one row (x value). This table is often used by SQL developer in PL/SQL code (Package, Functions, Trigger) to initialize variables storing technical information such as(…)

From Oracle Standard Auditing to Oracle Unified Auditing

In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the oracle documentation. You can also read the blogs written by my colleagues : Oracle 12c Unified Auditing Feature in(…)

Nutanix Era with oracle databases : Part 6 – Refresh an oracle clone database

Now that we have cloned our ORATEST source database into a clone database named ORATCL1 (see Nutanix Era Blog part 5), we will see how we can refresh it and see the impacts on the oracle database itself. For(…)

Exadata X9M release

I would like to share some personal thoughts. September 28th 2021, Oracle released the eleventh Exadata data machine called "X9M-2" (2 CPU sockets), X9M-8 (8 sockets) and ZDLRA X9M. Exadata is a computing platform to run Oracle RDBMS, zero data(…)

Nutanix Era with oracle databases : Part 5 – Clone an oracle database

Now that we have our ORATEST database provisioned (see Nutanix Era blog part 3), that we could run snapshot and take Log Catch Up (see Nutanix Era Blog part 4), we will now see how we can clone(…)

Scanning Ansible code with Ansible Lint

Introduction It’s always good to learn something new. But doing it the right way from the very beginning is even better. I recently started to work with Ansible and after creating a few roles, I quickly realized that there(…)

PostgreSQL indexes and operators

Creating a standard B-tree index in PostgreSQL is nothing special and usually we do it without thinking about what happens in the background. For the standard data types like e.g. int or text we do not need to know anything(…)

Some basics about time zones in PostgreSQL

As soon as you have an application which works across time zones you will have to deal with that properly in the database. I've seen many applications that didn't care of that at the beginning, and much work had to(…)