All articles

Mastering Custom Integration Runtimes in Azure Data Factory: An Introduction to Our Upcoming Series

Introduction Dear Readers, This post serves as an introduction to a six-part series focused on the Integration Runtime (IR) within Azure Data Factory (ADF). Over the course of these six articles, you’ll gain essential knowledge and practical skills(…)

PostgreSQL 18: REJECT_LIMIT for COPY

With the just released version of 17 of PostgreSQL, copy got the “ON_ERROR” switch. This is very useful if you load something which contains rows that cannot be inserted into the(…)

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