All articles

Pass a variable to a trigger in PostgreSQL

By Franck Pachot . With Oracle there are many ways to set a state in the session: context variables, set with DBMS_SESSION.SET_CONTEXT and retrieved with SYS_CONTEXT, or package global variables, or global or private temporary tables with ON COMMIT(…)

SQL Server: How to delete the msdb backup history kindly

This week I noticed some slowness on queries related to backup history. The instance had a huge msdb database (more than 10GB size), the backup history had never been purged. I already wrote a post on this topic and(…)

Maven: Could not find or load main class org.codehaus.plexus.classworlds.launcher.Launcher

Working on Jenkins and Artifactory I often seen options suggesting Maven tool,but what is Maven purpose?How can we use and install it on a Windows system?During this install you may encounter some kind of issues Introduction Maven is a tool(…)

SQL Server: Replace the old SCOM login by the new one

It’s every time hard to replace a login who as role and permissions in every database like the service account for SCOM. In the previous version of Scom, you create a service account (dbiscom) to access the SQL Server(…)

Documentum – SSL Certificate based secure communication setup

Around four years ago, I did a few presentations, here, in Switzerland about “Security & Documentum”. In there, I talked about a lot of different subjects related to both security and Documentum (you guessed it…) like: ciphers, SHA, FIPS &(…)

Documentum – Configuration of an IDS Target Memory/RAM usage on Windows

A few months ago, I had to work on a Windows Server to setup an IDS Target. The installation and configuration of the target wasn’t that different compared to a Linux host, so it wasn’t difficult at all (if you(…)

DynamoDB / Aurora: sparse and partial indexes

By Franck Pachot . In a previous post I tried to build a glossary about Amazon DynamoDB terms that look like relational database terms, but with a different technical meaning. Here is more about it. If(…)

JENKINS : Update manually your Jenkins master

Hi there, What about keeping up to date your Jenkins 🙂 Such easy to perform that!Today we will check the manual update of our Jenkins master Check if updates are available You can see that(…)

Ansible Basics Workshop day @dbi services

Today, I follow our Workshop Ansible Basics with Jérôme Witt. Why I follow this workshop? First, it’s to have the basics and Best Practices before begin myself and do “bricolage” by my customers.

Control-M/EM : libnsl.so.1: cannot open shared object file: No such file or directory

Hi team, When installing a brand new control-M server on your machine,you may encounter issues related to Control-M installation prerequisite. That was my case on my Virtual machine,we will see how to fix it quickly. System configuration:(…)