Writing A Month Long Blog Series
You might wake up one day soon and think, “Hey, wouldn’t it be cool to write a month long blog...
2011-02-14
615 reads
Presenting for the PASS PowerShell Virtual Chapter
On Wednesday, February 16 at 2:00pm CST I’ll be presenting “.NET Powers Activate! Form of PowerShell!” to the PASS PowerShell...
2011-02-14
784 reads
Quest Webcast: Dos and Don’ts of Database corruption
I was guest presenter on last week’s Quest Pain of the Week presentation. The presentation is available for download from...
2011-02-14
653 reads
Working on the Railroad
I work with a client that has an office about 25 yards from a train track and recently the railroad...
2011-02-14
613 reads
Can I Add Controls to a Reporting Services Report?
I see this question on the forums all the time and thought it was worth a repost here.
Just this week,...
2011-02-14
1,334 reads
CHD Awareness Week
Do you know about congenital heard defects (CHD)? Did you know that February 7-14 is the week dedicated to making...
2011-02-14
478 reads
February PASSMN Meeting This Week
PASSMN meeting is this week on Tuesday. Without further ado…
Meeting Details
Here are the details on the meeting location and time:
Date:February...
2011-02-14
532 reads
Evaluating Performance of View and Stored procedure
I got a chance to evaluate performance of both views and stored procedure for high level decision making.
As all of Us knows that purpose/scope...
2011-02-13
11,594 reads
DBA 101: Why Don’t People Run Backups
It happened multiple times this week. It happens multiple times every week. Some poor soul is posting on a message...
2011-02-13
723 reads
SSMS Tools Pack – Script Grid Results
Most of us like things that make our lives easier. When they’re free, it’s just that much sweeter. I would...
2011-02-13
1,602 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