Day Zero
Today's the day!!!
SQL Server is being released as I type this and I'm online listening to the keynote from Steve...
2005-11-07
1,471 reads
Boycott Sony
In general I have been a Sony fan for most of my life, starting with the Walkmans they brought out...
2005-11-04
1,388 reads
Looking For Technical Editors
If anyone is interested, we are looking for people that are interested
in doing some technical editing for our magazine, the...
2005-11-02
1,415 reads
The Plame Saga...
Living in the D.C metro area it is difficult to avoid politics,
policies and policy-makers. After 9/11 it became well nigh
impossible ...
2005-10-28
1,406 reads
It's Done
I wrote the editorial today about this, but SQL Server 2005 RTM'd yesterday!!!
If you an on MSDN Subscriber, you can...
2005-10-28
1,408 reads
The Great Uproar and some advice
My editorial
this past week had to do with a great uproar on the interviewing piece
that ran Monday. I felt I...
2005-10-20
1,455 reads
On vacation!
It was busy at work after returning from PASS which means my work day continued for 2 or 3 hours after I got...
2005-10-16
1,296 reads
Something About Nothing: NULL
You wouldn’t think that “nothing” would cause so many problems. But seriously, understanding how to correctly use NULLs is a...
2005-10-16
1,394 reads
Blogging Is Hard
Why is that? My Database Daily editorial for this week focuses on that and I thought it would be interesting...
2005-10-14
1,400 reads
Remote Access
We typically have great weather in Colorado where I live, but we do get
snow. And occassionally it causes issues. Like...
2005-10-12
1,530 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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