Azure

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

Deploying Azure Terraform code with Azure DevOps and a storage account as remote backend

Why this blog? While I was working for a customer, I was tasked to create an Azure infrastructure, using Terraform and Azure DevOps (ADO). I thought about doing it like I usually do with GitLab but it wasn’t possible(…)

Dctm – OTDS SSO with sAMAccountName AD/LDAP attribute and Azure

The OpenText Directory Services (OTDS) is a pretty interesting piece of software, and it works quite well out-of-the-box. If you are starting to use the OTDS from scratch (when you have nothing internally), then there isn’t much problem, you(…)

SQL Server 2025: Where Data Meets Intelligence

The evolution of AI is booming and brings many new possibilities to enhance efficiency and convenience with many different use cases. While AI chatbots have had an almost revolutionary influence in recent years, we are now entering the next(…)

Experiencing SQLBits 2025 in London

This week, I’m in London attending the SQLBits 2025 conference.Since joining dbi services as a consultant, this is my second time taking part in the event. The last time was in 2022, but I attended remotely due to(…)

Azure Bootcamp Switzerland 2025

Last week I attended the Azure Bootcamp Switzerland 2025 with my colleague Adrien from the Cloud team. It was the 1st time for us but it was already the 6th edition of the event. This is a community(…)

Azure Bootcamp Switzerland 2025, an Azure day in Bern

On June 5th I could participate to Azure Bootcamp Switzerland in Bern. The event gave me the opportunity to attend multiple presentations on various Azure topics. From AI to serverless integration to the cloud and networking, the(…)

SQLDay 2025 – Wrocław – Sessions

After a packed workshop day, the SQLDay conference officially kicked off on Tuesday with a series of sessions covering cloud, DevOps, Microsoft Fabric, AI, and more. Here is a short overview of the sessions I attended on the first(…)

SQLDay 2025 – Wrocław – Workshops

I had the chance to attend SQLDay 2025 in Wrocław, one of the largest Microsoft Data Platform conferences in Central Europe. The event gathers a wide range of professionals, from database administrators to data engineers and Power BI developers.