Techfuse, a New Laptop, and How Microsoft Azure Helped Save the Day
On Tuesday, April 22, I had the opportunity to speak at the Techfuse conference in Minneapolis. I was presenting a...
2014-04-24
696 reads
Another Question Of the Day
Yesterday I submitted a new question of the day based on the best idea generator you can find – something that...
2014-04-24
567 reads
SSMS Add-ons
At my presentation on SQL Server Management Studio at SQL Saturday in Exeter I promised to write some articles on...
2014-05-05 (first published: 2014-04-24)
25,000 reads
Using a Filtered Index to Enforce Filtered Uniqueness
One of the advantages and uses of Filtered Indexes (introduced with SQL Server 2008) is to provide filtered uniqueness. Obviously...
2014-05-06 (first published: 2014-04-24)
2,173 reads
Where are my 32-bit Perfmon Counters?
I have run into this before, but not in this same way, so I decided it would be worth writing...
2014-05-05 (first published: 2014-04-23)
3,419 reads
Learn High Availability and Disaster Recovery with SQL Server in a Day!
If you are near Pittsburgh, PA on May 22, 2014 catch the following all-day training session from 8:30 AM to 4:00...
2014-04-23
1,016 reads
Azure Automation
I introduced Azure Automation in a previous post. I’ve spent some more time exploring it.
There’s a set of documentation available...
2014-04-23
1,383 reads
Collation: Confusion
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-04-23
545 reads
Collation: Confusion
I started reading about collations after I had a recent run in with them. As I read I started to...
2014-05-02 (first published: 2014-04-23)
2,398 reads
Practical Data Migration Strategies
Practical Data Migration Strategies
As organizations mature their IT infrastructure must change to keep up with new applications and technologies. Many...
2014-04-23
1,332 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