All articles

SQL Server: Automatic index compaction in Azure (preview) – Part 2

Why does index fragmentation matter less than before ? Logical fragmentation was a problem on spinning disks: an ordered scan on a fragmented index broke the read-ahead into smaller I/Os and each jump cost a disk head movement.

SQL Server: Automatic index compaction in Azure (preview) – Part 1

For years, we have all scheduled the same thing on our SQL Server environments: a nightly or weekly index maintenance job. We check the fragmentation level, we run a REORGANIZE between 5% and 30%, a REBUILD above 30% and(…)

Oracle GenAI – Ask EM – Install and configure an Oracle Management agent on OEM 24ai

In order to be able to test the GenAI Ask EM functionality of OEM 24ai, and after I have first installed an OEM platform from OCI MarketPlace, I have been installing and configuring an Oracle Management agent on one of(…)

Split, Sort, Collapse: how SQL Server survives an overlapping unique update

How SQL Server shifts a whole unique column by +1 without ever creating a duplicate using Split/Sort/Collapse.

The lifecycle of a document is more important than the document itself

Most ECM projects start with the same question: How are we going to store our documents? It’s a reasonable question. After all, Enterprise Content Management is often associated(…)

Green SQL Server DBA Tips  #1 – Are unnecessary indexes cluttering up your database?

This summer I start a series of blog posts on the ‘green SQL Server DBA’, as it’s a topic that continues to interest me and one that hasn’t been covered very much so far. I hope you’ll enjoy my(…)

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