Database Administration & Monitoring

Deploying your own PostgreSQL image on Nutanix Era

Some days ago we had a very good training on Nutanix. Nutanix is a Hyper-converged infrastructure and that means that all is software driven and the system can be deployed on many(…)

Dbvisit Standby 9 : Do you know the new snapshot feature?

By Mouhamadou Diaw Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following(…)

ARRAYSIZE or ROWPREFETCH in sqlplus?

ARRAYSIZE or ROWPREFETCH in sqlplus? What is the difference between the well known sqlplus-setting arraysize and the new sqlplus-12.2.-feature rowprefetch? In Blog https://www.dbi-services.com/blog/oracle-fasttrue-in-sqlplus-some-thoughts-about-rowprefetch/ I showed a case, which helps to reduce the logical IOs when(…)

Oracle FAST=TRUE in sqlplus? Some thoughts about rowprefetch

During my time as a Consultant working on Tuning Tasks I had the feeling that many people think that there is an Oracle-parameter “FAST=TRUE” to speed up the performance and throughput of the database calls. Unfortunately such a parameter is(…)

One Host, multiple PostgreSQL Clusters – Monitoring using EDB PEM

At a customer we implemented the EDB Postgres Enterprise Manager. As they run multiple PostgreSQL cluster on one server, they wanted, for sure, to monitor all the cluster using PEM. This blog should give you a short guidance on(…)

Jenkins X ecosystem: Kaniko as image builder

For a few months now, we started a huge project at a customer; build a complete CI/CD platform for Documentum. The final goal is to create a CI/CD process for platform and software delivery to reduce as possible the delivery(…)

Power BI Report Server – Kerberos Advanced configuration

Introduction Following the basic configuration explained in a previous blog (Link), I describe here how to make more advanced configurations in some specific cases but often met by customers. It is only complementing what has being described in the(…)

Documentum – MigrationUtil – 5 – Change Installation Owner

The Documentum installation owner is the operating system user that owns the server executable and other related files along with the OS process when the server is running. It is originally determined when the server is installed, in fact, it(…)

SQL Server – Collecting last backup information in an AlwaysOn environment

Introduction Sometimes you face interesting challenges with unusual environment. One of my customer needed a automated and flexible backup solution. Said like that nothing very complex you will say. But if I mention that some databases were 60TB big with(…)

Upgrade your Power BI Report Server

Introduction Even if upgrading your Power BI Report Server is straight forward, I have been asked many times where to find the installation files and how to run it that I thought a blog is worth it. Before you start(…)