Test Data Management – 2024 is your year to do it
This blog post is about Test Data Management – or my take on it. I just saw that a video I did for my good mates at Redgate is...
2024-05-01 (first published: 2024-04-30)
93 reads
The Hybrid DBA's Blog
Interview around DevOps, Data, AI and Microsoft Fabric
A few weeks ago I did an interiview with Nagaraj Venkatesan – a good friend of mine who works for Microsoft Singapore. You can watch video below – I...
2024-04-01 (first published: 2024-03-20)
195 reads
Goals for 2024
Way back in 2019 I set some goals…. well I wrote some goals and posted them here 2019 seems a lifetime ago…..that was the year I travelled 200,000 air...
2024-03-20
56 reads
DevOps: It’s About the Team, Not Just the Tech
In November 2023 I did a session at PASS Summit and one of my sessions was voted https://passdatacommunitysummit.com/about/news/have-you-watched-some-of-the-most-popular-sessions-from-summit-2023/ That session was called DevOps is about Growing People rather than...
2024-03-27 (first published: 2024-03-20)
213 reads
KQL Series – KQL the next query language you need to learn – a video from Data Exposed
I love KQL so much I even made a video and if you compare it to my last blog post – yeah my hair has changed a bit…And my...
2023-04-07 (first published: 2023-03-20)
465 reads
KQL Series – enough writing – some talking
I recently did a talk to the Data Platform Down Under User group and it covers a whole heap of stuff that I’ve written about in this series. Check...
2023-03-20
30 reads
KQL Series – some DevOps things: Provisioning using ARM templates (dedicated to Scott)
I was talking to an ex-client earlier this week and he saw the drafts of my blog posts around DevOps infra-as-code spinning up Azure Data Explorer and he said...
2023-03-20
42 reads
KQL Series – Kusto Engine V3 – let’s make stuff go faster
In late March 2021 Azure Data Explorer Engine v3 was release and it is the latest version of the engine that powers Azure Data Explorer. It is designed to...
2023-03-20
56 reads
KQL Series – some DevOps things: Provisioning using Powershell
If you have read any of my last few posts on provisioning Azure Data Explorer then you will probably be wondering….. Will he write about Powershell? Ok, I will....
2023-04-03 (first published: 2023-03-20)
225 reads
KQL Series – some DevOps things: Provisioning using Azure CLI
I can’t really write about provisioning anything in Azure without mentioning Azure CLI.My last two posts were about using terraform and bicep Here we will be using the Azure...
2023-03-20
44 reads
Blogs
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers