All articles

OpenText Enterprise World Europe 2019 – Day 2

Day 2 of OTEW, we followed the global stream this morning which was taking most of the points from yesterday. But we had the pleasure to have a session from Dr. Michio Kaku, Theoretical Physicist, Futurist and popularizer of science.

Upgrading SQL Server pods on K8s and helm charts

It has been while since my last blog. Today it is about continuing with helm charts and how to upgrade / downgrade SQL Server containers to a specific cumulative update. My first write-up in my to-do list. Last(…)

SQL Tuning – Mix NULL / NOT NULL Values

One of the difficulty when writing a SQL query (static SQL) is to have in the same Where Clause different conditions handling Null Values and Not Null Values for a predica. Let’s me explain you by an example : Users(…)

OpenText Enterprise World Europe 2019 – Partner Day

First day of the #OTEW here at the Austria International Center in Vienna, Guillaume Fuchs and I where invited to assist to the Partner Global sessions. Welcome to OTEW Vienna 2019 Mark J. Barrenechea, the OpenText’s CEO & CTO,(…)

SQL Server Temporal Table – How to store a history table in another file?

Few days ago, a customer asks me if it is possible to move the history table to slower but cheaper storage. The question behind this is whether it is possible to create a history table on a separate filegroup(…)

How to patch your ODA lite to 18.3.0.0.0

Even you don’t need 18c, or you’re not ready for this release, this patch will also update your 11gR2, 12cR1 and 12cR2 databases to the latest PSU available on ODA, it means for example the patchset from last July if(…)

How to extract sql statements with awk

A common problem is to extract sql statements out of a sql file e.g. produced by full metadata impdp. Often these files are too big to be edited with vi. Following statement extracts all sql statements with “CREATE MATERIALIZED(…)

How To Create A Recovery Services Vault In Azure

Creating A Recovery Services Vault In Azure To create a recovery services vault, we first need to create a resource group by using either the CLI or the Azure interface. Creating a resource group using the(…)

PostgreSQL 12: New option –exclude-database for pg_dumpall

By Mouhamadou Diaw Up to PostgreSQL 11 pg_dump all was used to dump all PostgreSQL databases of a cluster into one script file. The script file then contains SQL commands that can be used as input to psql to restore(…)

How to disable ACLs in Oracle 12c

A common problem in Oracle 12c is, that ACLs are often not wanted to limit connections from database to other hosts. To disable ACLs is not that easy, so the best way is to enable connections and resolutions to all(…)