A Minute About Minute Key
You may have seen these minuteKey boxes at your local home supply store (Lowes has it near me) that let...
2014-03-18
735 reads
Performance improvements in SQL Server 2014
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the...
2014-03-18
1,273 reads
DBAs should be on CLOUD 9 - IT Trends
For all the talk and initial fear that the DBA is going the way of the Dodo (pronounced doh-doh) (an...
2014-03-18
2,106 reads
Remaining Vigilant, my contribution to #DBAJumpStart – Part 1
This post is part of the SQL Community Project #DBAJumpStart by John Sansom.
“If you could give a DBA just one...
2014-03-18
773 reads
A New Day at #Ntirety
We - the rank-and-file employees at Ntirety - received word yesterday that we had been acquired by Hosting, a cloud and network...
2014-03-18
594 reads
Webcast – Small Changes Can Make a World of Difference
This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my...
2014-03-18
454 reads
PowerShell – System Information
Different ways to find system information are given below:-
Method 1:Querying WMI objectsDownload the code SystemInfoCreate the function with Powershell console...
2014-03-17
660 reads
PowerShell – System Information
Different ways to find system information are given below:-
Method 1:Querying WMI objectsDownload the code SystemInfoCreate the function with Powershell console...
2014-03-17
1,573 reads
SQL Saturday: You can’t have it all.
SQL Saturday’s are awesome! Let’s get that clear up front. The organizers of SQL Saturday events are glorious individuals. Let’s...
2014-03-17
673 reads
Last Weeks Top “Reading” Links #75
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-03-17
603 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