Meetings In Glass Houses
If you’ve followed my writing for a while you’ll know I’m a fan of translucency (transparency) in most things business....
2014-03-20
527 reads
Alas, Poor Snapshot, I Knew Him Well (Question Of the Day)
My latest question of the day is up, this one called Alas, Poor Snapshot, I Knew Him Well. If you’ve...
2014-03-20
506 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 3
This post is part of the SQL Community Project #DBAJumpStart by John Sansom. As I mentioned previously, this post has...
2014-03-27 (first published: 2014-03-20)
1,588 reads
Folks,Know your Outbound Data Transfer Costs – Windows Azure
The cost associated with Outbound Data Transfer is very important when you consider bridging your On-premise network with Windows Azure.
Yes, when I...
2014-03-25 (first published: 2014-03-19)
2,688 reads
Submitting PASS Summit Sessions
I’ve been thinking for a while about what to submit for this year. I knew I wanted to have one...
2014-03-19
637 reads
Thank you!
I won’t be able to make it to the PASS Summit this year but I still consider myself part of...
2014-03-19
683 reads
Why Am I Here? You’re On Retainer
That’s just one of about a hundred great lines from episode 1 of Farmed and Dangerous. A company with the...
2014-03-19
611 reads
The problem with PASS Summit abstracts (and submissions and selection and notification and…)
The problem with the PASS Summit session submissions process is that people don’t know why they’re rejected. So say we...
2014-03-26 (first published: 2014-03-19)
1,444 reads
Query Tuning Near You
It really is so much easier to just throw hardware at badly performing databases. Just buy a bigger, faster server...
2014-03-19
1,191 reads
A Nicely Made Smoke Detector
This may not be the exact model, but I bought 2 First Alert detectors at Costco for $23. Not a...
2014-03-19
674 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