THE Reception
After the PASS opening, which I dropped in long enough to get a beer, we had the SQLServerCentral.com party.
It seemed...
2007-09-19
618 reads
Technical Speaking - Again
One of the points mentioned in the volunteer meeting on Tuesday was that it makes a lot of sense to...
2007-09-19
551 reads
Notes from PASS 2007
I attended the morning portion of the volunteer/chapter meeting today and got to put some names with faces for some...
2007-09-18
597 reads
Training
I'm kind of stunned. I have asked 6 people to go to the PASS conference over the last 4 days...
2007-09-17
694 reads
Technical Speaking - Some Misc Thoughts
Last week I taught 'Successful Technical Speaking' for the first time - it's a free four class I put together for...
2007-09-17
785 reads
Off to the PASS Summit in Denver
I'm flying out tomorrow for the event and looking forward to it, nice break from the office/work routine, a chance...
2007-09-16
519 reads
$4
So I got a final count of referrals from the PASS conference yesterday and it was 183, so thanks to...
2007-09-14
666 reads
Stealth Updates
Editorial coming next week, but so far this is amazing to me. Microsoft's stealth updates of their client update tool....
2007-09-14
618 reads
The Challenges of Podcasting
OK, here's one take. Not sure if it's any good, but it's a start.
No live editorials yet. I've been working...
2007-09-13
665 reads
Podcasting
I'm working on getting a small studio set up for some podcasting of the editorials. That means I put a...
2007-09-12
2,237 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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