All articles

Control-M/EM Add a suffix to your jobs using mass update utility

Hi guys,and girls of course 😉 Sometimes we have to make some cleanup on our Control-m folders and also we have to keep them disabled (we never know if one day the can be used again by a new agent)(…)

Switching from CentOS 8 to Red Hat 8

We have quite a few customers still running on CentOS 8 and you probably already are aware that CentOS 8 will be end of life by the end of this year. This forces a(…)

Install Enterprise Manager 13c R5: Check the db edition Failed

By Mouhamadou Diaw A few days ago, I was setting an Enterprise Manager 13c R5 for a client. The configuration used is the following -The EM binaries are installed in a separate server than the database -The database(…)

Improve Oracle Insert Performance with BULKCOLLECT and FORALL

As specified by Steven Feuerstein into the Oracle Blog Website the bulk processing features of PL/SQL are designed specifically to reduce the number of context switches required to communicate from the PL/SQL engine to the SQL engine. Using BULK(…)

DataPump and the Transform option – Not very well known, but it can be useful

I work with Oracle Databases and Datapump for more than 10 years but still I find some datapump options that I did know and in some cases can be very helpful. For a customer we did a migration of(…)

Using pgBackRest to backup your PostgreSQL instances to a s3 compatible storage

When it comes to backup and restore of PostgreSQL we usually recommend pgBackRest to our customers. This tool comes with many options and features and should bring everything you need. Most of the times we install a(…)

SQL Server database design – Moving table to new filegroups

Introduction A database is very often created without thinking of its growing and in the most cases that is not really an issue until the data volume is not increasing a lot. And most of the time when a high(…)

Ansible URI module and WebLogic REST API

How to use WebLogic REST API with Ansible URI module.

dbi Event Recap: SQL Server Automatic Tuning and Query Store

Earlier this month, dbi services hosted a free multi-technology event. Details are available on our website. I had the opportunity to present a session about the Query Store and the Automatic Tuning feature available on SQL Server and(…)

Minor PostgreSQL version upgrades in a Patroni cluster

Last week PostgreSQL 14.1, and all other minor versions for the supported version of PostgreSQL have been released. As usual, it is highly recommended to update to the latest minor release as soon as possible. Minor version(…)