All articles

Customer experience – Certificat SSL on an SQL Server Reporting Services

Recently, I had to renew an SSL certificate on an SQL Server Reporting Services (SSRS) server. The task seemed straightforward: replacing an expired certificate with a new one containing the same configuration. However, once the change had been made,(…)

When an idle transaction starves the worker pool (THREADPOOL)

How a forgotten transaction exhausted SQL Server's worker pool, triggered THREADPOOL waits, and only DAC could fix it.

Why search is the most underrated ECM feature

When organizations evaluate an Enterprise Content Management (ECM) solution, the conversation usually revolves around Artificial Intelligence, workflow automation, and integrations. Yet the feature employees use more than any other is rarely the one showcased in demonstrations or marketing(…)

Zabbix Agent 2 service terminated unexpectedly on Windows server

Introductiom The Zabbix Agent 2 service on a Windows server was repeatedly becoming unresponsive and eventually crashing. The issue caused intermittent monitoring interruptions and required further investigation through Event Viewer messages and Zabbix Agent 2 logs to better understand why(…)

Oracle GenAI – Ask EM – Deploy Oracle Enterprise Manager 24ai from Marketplace

I have been looking to study and test what Oracle GenAI Ask EM assistant, also called now Oracle AI database assistant, can offer. This generative AI assistant is directly integrated into Oracle Enterprise Manager 24ai. Before being able to look(…)

Designing metadata cards that users like

Over the past few weeks, I’ve addressed philosophical questions related to enterprise content management (ECM), such as “What should be done?” and “Why?” Now, it’s time to focus on the “how.” When discussing user adoption of M-Files,(…)

Measuring the real performance cost of SQL Server XE buffers

Are Extended Events always lightweight? See how a bad config converts event loss into query latency through DMVs.

M-Files Outlook Pro add-in configuration

In this blog post, I will outline the steps required to enable and configure the M-Files Outlook Pro add-in. This includes configuring Microsoft Outlook rules to automate email handling. It took me some time to configure the rules, as(…)

Monitoring MSSQL Database Files in Zabbix

Introduction Monitoring Microsoft SQL Server database files is an important part of infrastructure supervision.A database reaching its storage limit can rapidly lead to application outages, transaction failures, or even complete service interruptions. The Initial Problem In SQL Server, retrieving(…)

M-Files BD – Putting it together with the Visual Designer

After several posts of theory, it’s time to build something. In this post, I will walk you through a Visual Designer tutorial to create a complete Contracts dashboard on the M-Files Sample Vault. Therefore, no JSON editing is required(…)