The Joy of Contracting
As you may or may not know I have been contracting since 2007, almost 4 years now and I have...
2011-02-21
920 reads
A Wireless Production Server? Sure, Just Enable the Wireless Networking Feature on Windows 2008
Since I have Enabled Wireless on Windows Server 2008, and picked up a better-than-average Asus N wireless card, handling the...
2011-02-21
804 reads
Hello, My Name is Hugo and I haven't Blogged in Two Months
Oh gracious sin 🙂
No apologies, just that life gets in the way from volunteer work.
My regular political passions have gotten in...
2011-02-21
753 reads
Data Driven Subscriptions for SSRS Report with Parameters from multiple data sources
Just to give the context of the problem I faced recently.. our application is very data intensive, GB of data received...
2011-02-21
660 reads
The Winter 2011 Colorado SQL Tour
During my visit to Denver last September for SQL Saturday 52, I spent a while talking with Marc Beacom, who...
2011-02-21
964 reads
Use Patterns and Prior Code and Don't Reinvent the Wheel
In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the...
2011-02-21
1,991 reads
New Version of CPU-Z (1.57) has Been Released
On February 18, Franck Delattre released version 1.57 of the very useful CPU-Z Utility. Here is a list of the...
2011-02-20
2,241 reads
24 (Hours of SQL Training Delivered to Your Computer)
The Spring 24Hours of PASS: Celebrating Women in Technology will be broadcast live on the intertubez on March 15 and 16...
2011-02-20
1,633 reads
Is CPU-Z Risky To Run on a Production Server?
There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the...
2011-02-19
1,786 reads
SQL Saturday #70 - Columbia, SC 2011 Session Schedule Is Up!
As announced, we have posted our session schedule for SQL Saturday #70 - Columbia, SC. The event will be March 19, 2011...
2011-02-19
1,275 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