Pro SQL Server on Linux–Getting Started
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-01-18 (first published: 2019-01-04)
1,919 reads
Speaking at SQLBits
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s what I call a gift that keeps on giving....
2019-01-04
15 reads
Speaking at SQLBits
I got an early Christmas present this year, I found out I had been selected to speak at SQLBits! That’s...
2019-01-04
154 reads
Azure – Backing up to URL
In a previous post, I talked about some of the available storage options that can be used to back up...
2019-01-14 (first published: 2019-01-04)
450 reads
Looking Forward
2018 has come and gone. And we’re on a new year once again. This is another opportunity for a new...
2019-01-04
263 reads
Query memory grants part 1: Where does the memory go?
Let’s talk about how queries use memory, specifically in the execution plan. One of the query operators that use memory...
2019-01-04
230 reads
Speaking at SQL Saturday Nashville
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January 12, 2019. I’ve been to Nashville before, in fact...
2019-01-04
16 reads
Speaking at SQL Saturday Nashville
I am excited and honored to announce that I have been selected to speak at SQL Saturday Nashville on January...
2019-01-04
132 reads
Automatic Tuning Monitoring and Diagnostics
Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as...
2019-01-04
34 reads
Automatic Tuning Monitoring and Diagnostics
Cool new toys/tools have been made available to the data professional. Among these tools are query data store and automatic...
2019-01-10 (first published: 2019-01-04)
2,708 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
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