My First Sandy Bridge Desktop System
I was standing in line at the Denver Micro Center at 11AM this morning (despite the beginnings of a small...
2011-01-10
1,416 reads
Thinking about goals for 2011
The SQL community is inspiring, and there are a lot of people that work hard to contribute to it. With...
2011-01-10
1,034 reads
SSMS Addin Wrapper - Source Code and Usage
Code First, KTHX!
Here, as promised, is the source code for the SSMS wrapper.
Introduction
My apologies for the brief delay on this....
2011-01-10
2,390 reads
31 Days of SSIS – Override Variables (9/31)
Day number 9 of the 31 Days of SSIS. If you missed the first week then start by reading the...
2011-01-09
1,046 reads
The OUTPUT clause
One of the features that I have been using quite a lot lately is the OUTPUT clause.
This clause can be...
2011-01-09
939 reads
SSMSDeploy - Demo Video Available!
Updates
1) I have discovered that there was already a tool called SQL Deploy, so I have renamed my addin to...
2011-01-09
597 reads
31 Days of SSIS – Merge Join Is My Friend (8/31)
31 Days of SSIS
Welcome to day eight post for the 31 Days of SSIS. If you are just joining the...
2011-01-09
837 reads
Changes to the PASS Board
The official announcement was posted yesterday that Jeremiah Peschka and Brian Moran have decided to resign from the Board and...
2011-01-09
706 reads
Microsoft Certified Master in SQL Server 2008 Knowledge Exam
I woke up bright and early this morning to take the beta version of the Microsoft Certified Master in SQL...
2011-01-08
983 reads
Consolidating My Brand
I decided that I really like the WordPress platform, and more importantly, that I need to consolidate all the work...
2011-01-08
817 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