PASS Summit 2008 - Tom Casey
He's the manager for BI, the General Manager, and he's here to talk about the challenge and promise of Pervasive...
2008-11-20
1,195 reads
PASS Summit 2008 - Thur PASS Opening
The morning keynote opening was good. We had video of the conference playing here and there, the election candidate positions...
2008-11-20
1,076 reads
2008-11-20
746 reads
PASS 2008 Day 3 (Wed)
Went to the intro and keynote yesterday, even though I know better. They weren't bad, they just weren't great. I...
2008-11-20
668 reads
My first blog post -- starting small
I've been hanging around the SQL PASS Summit this week and came to a realization, I do know something...
I don't...
2008-11-20
448 reads
PASS Summit 2008
It’s been a great week at PASS thus far and many others have written on their experiences so I’ll do...
2008-11-20
586 reads
A Dark Picture - Management Presentation
It was really Andy Warren's presentation, but he usually ropes me in to add a different perspective on the various...
2008-11-19
864 reads
PASS Summit 2008 - Ted Kummert Keynote
A film clip opening from MS, quotes and short sound bites from a variety of people from he SQL Server...
2008-11-19
1,777 reads
PASS Summit 2008 - Wayne Snyder Keynote
With the dimming of lights, the drone of "Born to be Wild" from Steppenwolf, and an opening film slip of...
2008-11-19
950 reads
PASS 2008 Day 2 (Tuesday)
I spent most of yesterday in the PASS volunteer training. It's not really training, more of a gathering of volunteers...
2008-11-19
924 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