An Outpouring From The Twitter Community
Last week, I was in Redmond, Washington, for the Microsoft MVP Global Summit. This was my fourth time attending the Summit; it’s a great opportunity for networking and providing...
2011-03-07
7 reads
An Outpouring From The Twitter Community
Last week, I was in Redmond, Washington, for the Microsoft MVP Global Summit. This was my fourth time attending the...
2011-03-07
938 reads
The Three C’s Of Interviewing
A client of mine recently asked me to help fill a junior-level position in their organization. This isn’t uncommon; I regularly help clients interview and select qualified IT Professionals...
2011-03-07
10 reads
The Three C’s Of Interviewing
A client of mine recently asked me to help fill a junior-level position in their organization. This isn’t uncommon; I...
2011-03-07
1,043 reads
SSWUG DBTechCon Coming Up
Over the last few years, I’ve blogged about and spoke at the SSWUG Virtual Conferences. It’s that time of the...
2011-03-07
480 reads
IT Camp Saturday
The first ever IT Camp is being held in Tampa on March 19, 2011, organized by cool Tampa guy Chad...
2011-03-07
624 reads
SSAS – Changing the Dimension ALL Member Name
All Analysis Services dimensions have a default All member that represents all the members for a particular attribute.For example, let’s...
2011-03-07
2,170 reads
Execution Plan Stability
I’ve talked before about one of the primary things that the Query Optimizer team at Microsoft tries to avoid, regressions....
2011-03-07
789 reads
Upcoming Engagements
I haven’t been blogging lately because I’ve been busy tweaking my resume, working on PASS SQLRally, serving at church, and spending...
2011-03-07
636 reads
XQuery for the Non-Expert – Aggregates
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2011-03-07
1,257 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