Opportunity Cost versus Real Cost
One of the hardest lessons to learn and put into practice as a self-employed consultant is that of Real Cost...
2011-02-08
1,032 reads
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands of SQLSkills. Later that week an announcement was made...
2011-02-08
9 reads
Immersions Training
The last week of January 2011, I wrote a blog post entering a contest for free training at the hands...
2011-02-08
543 reads
T-SQL Tuesday #15 – Automation
It’s that time of the month again, and this month Pat Wright and his SQL Asylum are hosting the T-SQL...
2011-02-08
1,021 reads
February OPASS Meeting
Don’t forget to join us tonight for the OPASS meeting sponsored by RedGate and Signature Consultants.
Event Date/Time: Tuesday February 8th...
2011-02-08
9 reads
TSQL Tuesday #15–Automation in SQL Server
Automation is the separation point for the professional DBA from the amateur. That makes this a very important topic. Thanks...
2011-02-08
911 reads
T-SQL Tuesday #15 Automation and the SSIS Dumper
This post is my contribution to T-SQL Tuesday, hosted this month by Pat Wright (blog | twitter).
In my previous post...
2011-02-08
1,068 reads
February OPASS Meeting
Don’t forget to join us tonight for the OPASS meeting sponsored by RedGate and Signature Consultants.
Event Date/Time:Tuesday February 8th @ 6:00...
2011-02-08
830 reads
What's OLD in SQL Server 11 aka Denali? - Deprecated Feature List
Well, we always see, hear, and read about the list of NEW features in the myriad of articles, columns and blogs...
2011-02-08
1,747 reads
SQL University: SQL Server Security Architecture - 3rd Party, No Options
Welcome back to day 2 of Security Week for this semester of SQL University. If you missed yesterday's introduction, you'll...
2011-02-08
2,484 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