All articles

Documentum : Dctm job locked after docbase installation

A correct configuration of Documentum jobs is paramount, that's why it is the first thing we do after the docbase installation. A few days ago, I configured the jobs on a new docbase using DQL, and I got an error(…)

OpenText Enterprise World Europe 2019 – Day 3

Last but not least, today was mainly dedicated to demos and customer cases. It started with the global stream presenting some OpenText applications like Core for Quality: An application developed with AppWorks and integrated to Magellan. It was meant to(…)

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