London UK SQL Server User Group – It’s Back!
"We're back with a Bang!"
In case you missed it, being tucked away amongst all the other UK SQL Server User...
2011-02-21
650 reads
How to Avoid SQL Server 2008 Lingering Evaluation Installs - Validation Before Applying SP2 (10.0.2531 to 10.0.4000)
We wound up in a nasty situation recently where SP2 could not be applied to an instance of SQL Server. ...
2011-02-21
1,617 reads
SQLSaturday#69 - Update - Schedule Posted! - You Can Still Register
It's just a little less than 2 weeks to SQLSaturday#69 at DeVry University, 1140 Virginia Drive, Ft. Washington, PA 19034...
2011-02-21
876 reads
Testing SSAS Security in Excel
There are many posts available that describe how to test Analysis Services security from inside the development environment.Today I would...
2011-02-21
1,503 reads
Moore’s Law May Be The Death of NAND Flash
"It ain’t what you don’t know that gets you into trouble. It’s what you know for sure that just ain’t...
2011-02-21
1,014 reads
How Should the PASS Nominating Committee Be Selected?
Over the past few months, the Elections Review Committee (ERC) has been looking into how the community should select its future leaders in the PASS organization. We started with...
2011-02-21
12 reads
How Should the PASS Nominating Committee Be Selected?
Over the past few months, the Elections Review Committee (ERC) has been looking into how the community should select its...
2011-02-21
659 reads
Pragmatic Transition: Lighthouses and Shipwrecks
Sometimes your mistakes are the greatest lessons...
This is the next post in my series about transitioning from a DBA to...
2011-02-21
701 reads
Blowing Kisses: Un-SQL Friday #003 Roundup
We at MidnightDBA sure do love a blog party, and what’s better than a blog party about love? I invited the...
2011-02-21
650 reads
Backups after a DR Restore – MCM
If you have a disaster, and you need to restore to some point in time prior to the last log...
2011-02-21
802 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