My previous post on load testing Azure SQL covered the Standard Edition; today I'm moving to the Premium Edition, which is Business Critical in DTU shape. Again, the calculation mixes CPU, Memory, and disk I/O. The main difference between Standard and Premium is cost. Premium is more expensive and aimed at mission-critical workloads. It has … Continue reading Loadtesting SQL: The Sequel: Premium Edition
This series of posts is much overdue, but with good reason. When I started hammering Azure SQL again, I had a set of scripts to run and tried to figure out what was happening. For most databases, I could explain the results, but some didn't make sense. I'll get back to that later in this … Continue reading Load testing SQL, the sequel. Standard Edition
First up, congrats to Adam Machanic and Steve Jones on reaching 200 episodes of T-SQL Tuesday; you can be proud of yourselves! I've always loved the variety of topics, the different views of the bloggers, and the learning that can be gained from all the posts. I've even had the honour of hosting. Anyway, Brent … Continue reading T-SQL Tuesday 200: When I Look at a Query …
The DP-800 training is new and was released to GA a few weeks ago. It now sits in the same family as DP-600 (Data Analytics using Microsoft Fabric), 700 (Data Engineering using Microsoft Fabric) and 750 (Data Engineering using Databricks). The full name of this training is "Develop AI-Enabled Database Solutions". This one sparked my … Continue reading DP-800: First Microsoft Learn experiences
One of the new features in SQL Server 2025 is that you can now use regular expressions directly in your T-SQL queries. Now, regular expressions (or RegEx) have never been a syntax that's easy to read. There are a lot of brackets, dashes and other symbols that make no sense when you first see them. … Continue reading SQL Server 2025: Simplifying Data Checks with RegEx
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
Some time ago, a client came up with a very intriguing question. As I love a challenge, especially when you get to dig deep into a toolset, I jumped at the occasion and went for it. The following is a write up about the steps taken to analyse. Both for future me when I run … Continue reading Azure Synapse Analytics performance, an analysis
In my previous blogs, I've been hammering Fabric with data from some different angles. Either with the Copy dataflows, notebooks, Pipelines, Data Warehouse SQL scripts or in PowerBI.This time, I'm going to make the dataflow Gen2 work for it's money. As usual, I'm using the F2 capacity as it's the one that should break the … Continue reading Microsoft Fabric Dataflow Gen2: In-depth Performance Evaluation and Capacity Insights
If you've been having fun with Microsoft Fabric, chances are you've been playing around with the F64 capacity trial. This one is given to you by Microsoft for free but, since the GA data, the timer attached to it is counting down the days until you need to buy your own. Most blogs I've read … Continue reading Microsoft Fabric, comparing the F2 with the preview F64
