PASS Summit 2019 Wrap-Up
I’m home from PASS Summit 2019, recovered from the travel, and in the post-Summit “I miss #SQLFamily” funk. Time to recap the week, maybe a bit differently than it’s...
2019-11-27
9 reads
FLX SQL
Monday Morning Module Maintenance Monoliners
Or: Andy Authors An Amazing Alliteration
Do enough work with PowerShell and you’ll build up a decent collection of modules installed from the gallery into either your computer or your...
2019-11-25
22 reads
SQL Saturday Rochester Returns!
We have just published SQL Saturday Rochester 2020. We took last year off but we’re back for 2020 on a very special day - it’s Leap Day, February 29th!
What...
2019-11-22
16 reads
Preparing for PASS Summit - Odds and Ends
This is the final installment in my series of posts which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle,...
2019-10-29
17 reads
Preparing for PASS Summit - Sessions!
This is the third in my series of posts which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle, Washington.
So...
2019-10-21
14 reads
Preparing for PASS Summit - Networking and Events
This is my second post in a series which I hope will help you (and me!) prepare for the upcoming PASS Summit November 4-8, 2019 in Seattle, Washington.
Networking, Networking!...
2019-10-14
12 reads
T-SQL Tuesday #119 - Changing Your Mind
For T-SQL Tuesday this month, Alex Yates (blog | twitter) gives us this challenge:
I would like you to write about something in your IT career that you have changed...
2019-10-08
16 reads
Preparing for PASS Summit 2019 - Logistics & Survival
It’s time once again to prepare ourselves for the endurance test that is PASS Summit, November 5-8. I’ve participated in the Summit Buddies program the past two years, but...
2019-10-07
24 reads
The "Go Pack"
I’ve found myself traveling quite a bit this year, with more travel on the horizon. Like many, I travel with a fair bit of technology and of course that...
2019-09-17
8 reads
T-SQL Tuesday #118 – Your Fantasy SQL Feature
It’s early September, which means it’s time for T-SQL Tuesday! This month’s topic comes from Kevin Chant (blog | twitter). Our mission, should we choose to accept it (click...
2019-09-10
16 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