Beginning Powershell Companion PDF
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
2011-01-03
2,699 reads
24 Hours of PASS Wants You…
Calling for Presenters!There’s still a couple months until the next 24 Hours of PASS. Even though it’s a bit of...
2011-01-03
314 reads
Happy New Year 2011
Wish you all a very happy an prosperous New Year 2011. When I see back year 2010 : >> was started my...
2011-01-03
445 reads
Looking Back at 2010
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals,...
2011-01-03
456 reads
MVP 2011
I was awarded the MVP status from Microsoft for 2011 on Jan 1, 2011. This is my fourth consecutive award...
2011-01-03
1,283 reads
Back to Work
It's actually nice to be back to work. It's been a great holiday season for me, lots of family time...
2011-01-03
781 reads
31 Days of SSIS – Using Breakpoints (2/31)
31 Days of SSIS
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Today’s post is going...
2011-01-02
579 reads
TPC-E Benchmark Analysis by CPU Type
As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database,...
2011-01-01
1,291 reads
31 Days of SSIS – Raw Files Are Awesome (1/31)
As I mentioned in the introductory post, I’m writing 31 Days of SSIS. Let’s start off this series with a...
2011-01-01
12,407 reads
January Question: As a DBA, how do you manage your disk space?
Managing disk space is an important responsibility of the DBA, and there are many ways to perform this task. In...
2011-01-01
2,523 reads
Blogs
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