Speaking at EDMPASS This Month
If you are up in Edmonton around January 26th, you can hear my voice at the EDMPASS January user group...
2011-01-07
435 reads
31 Days of SSIS – What The Sorts?! (7/31)
31 Days of SSIS
Welcome to day seventh day of the 31 Days of SSIS. If you are just joining the...
2011-01-07
559 reads
Happy moments in 2010
Happy moments in 2010
Hi all wish you a happy new year.
I know it’s a late post anyway I am going...
2011-01-07
1,432 reads
Windows Experience on W510
I toyed with the idea of using the SSD for my main drive, but I’d really like to get the...
2011-01-07
1,063 reads
RTFM365, Week 5
I’m trying to plan out this week better, and come at the RTFM readings with a sense of direction an...
2011-01-07
471 reads
An Artist I’m Not!
One of the gifts my Mom gave my children was a ‘Painting Rocks’ kit. Great marketing, six medium sized rocks,...
2011-01-07
558 reads
Troubleshooting SSRS subscription failures
Of-late one of our SSRS 2005 report subscriptions started to fail regularly with the error message
Failure sending mail: Timeout expired....
2011-01-07
3,073 reads
It’s A Major Award!
“It’s a major award!” That’s what Darren McGavin’s signature role, Mr. Parker, proudly proclaimed to friends and family in the...
2011-01-07
592 reads
The laptop rebuild continues
Not done yet, but I have been slowly patching and installing software over the last few evenings, stuck at my...
2011-01-07
664 reads
SQL Server Index Tuning for Mere Mortals
One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is...
2011-01-07
3,480 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