In a previous blog post, I discussed my initial impressions of SQL Server and the key features that are relevant to my work in Business Intelligence. This time, I want to focus on a specific and improved feature of SQL Server, namely extended events. What are they? To provide some context, let's begin by defining … Continue reading SQL Server 2025: time-bound Extended Events explained
When Microsoft Fabric was introduced in May 2023, one of its major promoted components was the Real-time Analytics part. We (that is, my coworkers and I from Axians) focused mainly on the batch processing of data. With the introduction of the DP-700 exam, I started to focus more on the real-time part of Microsoft Fabric. … Continue reading Mastering Real-Time Analytics with Microsoft Fabric
Let me set the scene quickly for you. You're working for an organisation where Fabric is in the process of being adopted or it's already fully in use. Regardless of the number of capacities, workspaces, etc, you're interested in what's going on in your Fabric environment. You have questions like "Who is using the reports?", … Continue reading Streamline Fabric Monitoring and Administration Using FUAM
When we create a data solution for our company or clients, we create the best, right? Sure, we do. But still, monitoring the solution is something you should never forget. Your solution can be stable, but the data usually isn't. And it just feels good to know all the data has been processed correctly. So, … Continue reading DP-700 Training: Monitor hub
About two weeks ago I had the immense pleasure of speaking in Berlin for the first time. Now, I'm used to regular events like data saturday's and SQL Bits or dataMinds Connect as outliers because they're larger and different events. But speaking at this one is on a whole different level. As you might gather … Continue reading Speaking experiences at Data Moshpit (Berlin, Germany)
I'm a huge fan of the Ola Hallengren maintenance scripts. They have incredible power and, when you've read the documentation, are easy to use. But one thing he can't prepare the scripts for, is different settings for each database on the instance. Allow me to show you how I've fixed that. Setup Suppose I've got … Continue reading Dynamic SQL Maintenance Scripts
Next week (Thursday 4th of august 2022) I've been invited to speak at the Microsoft data platform group Birmingham. This is a very active user group that hosts monthly sessions on the data platform, and this month I'm honoured to talk about monitoring Azure SQL with Zabbix. In this session I'll walk you through monitoring, … Continue reading Speaking at Microsoft Data Platform Group – Birmingham
My first long-read about monitoring your Azure SQL DB with Zabbix. And a little bonus with Linux.
Reitse's blog 