All articles

Understanding Head Blockers in SQL-Server

A customer of mine had a recurring issue with one of his business critical applications where everything was frozen and stuck for the users. The issue was caused due to a head blocking transaction which increased blocking in the(…)

Enhancing PostgreSQL Performance with Index Advisor and HypoPG

In database management, query performance is critical for efficient data retrieval. PostgreSQL, a powerful open-source database, offers various extensions to optimize and tune query performance. Two such extensions are Index Advisor and HypoPG. These tools help database administrators (DBAs)(…)

ExaCC OCI integration with OEM 13.5 Cloud Control installed On-premises.

Introduction I wrote this article to show how you can integrate Legacy OEM with your Cloud environment in this case Oracle ExaCC.To have overall view on your Exadata X9M Cloud Infrastructure, statistics related to CPU/Memory/ASM Storage usage. Your on(…)

OEM Cloud Control Release update to 13.5.0.23

Introduction This is upgrade procedure to release update from 07 Aug 2024. 13.5.0.23 Its also one of prerequisites for integrating OEM with OCI Exadata Cloud@Customer solution available on my other post under this link:(…)

M-Files to unify your data

Two weeks ago, I was at the #SITF24 to talk about integration of External Repositories (SharePoint/Teams, shared folder,…) into M-Files. Surprisingly this is still a tricky topic for companies. As an ECM consultant since years, I’m probably a(…)

Developing a Business Central Custom API for Power BI Integration – Resolving the ‘Could Not Download Symbols’ Error

Introduction Dear Readers, This article marks my first blog post. I am both excited and eager to share my experience of tackling a challenging issue encountered while developing a custom API for Microsoft Business Central to enable data(…)

SQL Konferenz 2024 – Microsoft Copilots

Today, we followed (with Roger Schönmann) the first day of the SQL Konferenz 2024.  We will be attending this event from October 01 to 02 in Hanau. At dbi services, we are no strangers to this(…)

Future Data Driven 2024 – introduction to vector databases

I had the opportunity to participate in the Future Data Driven 2024 event (https://datadrivencommunity.com/FutureDataDriven2024.html) with my colleague Stéphane Haby. Many speakers were present, and I was able to attend several sessions covering the following topics: Azure,(…)

Control-M for Kubernetes – Installation

After showing you an overview and the preparation of Control-M for Kubernetes, it is time to deep in with the installation of this solution. In fact, without the installation of Control-M for(…)

PostgreSQL 18: Verify tar format and compressed backups

While PostgreSQL 17 was released just a couple of days ago, the development of PostgreSQL 18 is already going on and the first patches got committed. One of them addresses a limitation with pg_verifybackup:(…)