Contexte A customer recently asked me to disable FileTable/FileStream on their instance because the databases no longer use it, and to ensure that this is indeed the case.The aim is to migrate to a new architecture without FileTable/FileStream in a second time. Link to FileTable and FileStream if you need to know a bit more about these technologies The environment…
How many times have I found, during a migration, that I also have to clean up the databases no more used?Why keep them for so long if we’re not going to use them? This is something we often see among our customers. If we assume that we carry out a migration project roughly every five years, this means we’re keeping…
This Monday morning, we begin our SLA Support with a customer call.He cannot do a select on a table in his database… After creating the Ticket, I connect to the instance and see that the msdb system database is in a Suspect State: After taking a deep breath because I don’t see that every day, I begin my investigation by…
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 tips, starting with this one on unused indexes. When discussing SQL Server performance, we often hear our performance tool say, ‘An…
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, HTTPS wasn’t working anywhere — neither via the usual DNS names nor even when accessing the server directly. Only HTTP remained…
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 they were not working as I expected. I hope this blog helps others save time. Installation The installation is very straight…
SQLDay 2026 offers a full-day workshop program on 11 May 2026, before the main conference scheduled for 12–13 May 2026 in Wrocław, with onsite and online participation options depending on the session. The workshops cover several areas of the modern data platform: advanced BI, AI and MLOps, SQL performance tuning, PostgreSQL adoption, and Microsoft Fabric automation. DAX – Beyond the…
First, for those unfamiliar with the term, low-code is a software development approach that uses visual, drag-and-drop interfaces and pre-built components to create applications, rather than manual coding. Low-code doesn’t always have a good reputation in the IT world because “real” programmers write code. But why reinvent the wheel? I have worked in the ECM world for more than fifteen…
The problem: I faced an issue today where one of my colleagues was struggling to remotely connect to a Windows server via RDP. He was using the default Remote Desktop app that comes standard with Windows 11 and everytime he’d connect, the application would hang at login. Something between 2 to 4 minutes, until he could finally type his password…
For over 15 years, I have been exploring the world of Enterprise Content Management (ECM). Although this sentence reminds me that I’m getting old, that’s not the point! Above all, I have accumulated a fair amount of knowledge in this field. I find it interesting to briefly compare the four ECMs with which I have worked most in recent years.…
If you have a clusturized environment already up and running, but you want or need change the complete ip adress of your wall with minimal downtime (full downtime during operation: 3 min). You’re in the right place, I will show you how we can do that. Context Two-node clustered environment in sql 2022 with OS environment in 2022 .In 1…
This blog focuses on the integration of M-Files with Microsoft Teams. Please find below a brief overview of the installation and configuration requirements. The primary focus will be on the benefits it will bring to the user and on demonstrating how to work with the M-Files Teams integration. Requirements This list details the most important requirements. For a full list…
