SQL Server PDW the Microwave of BI
The Path to the PDW
For decades we had the traditional electric oven to cook with and people thought it was...
2014-02-08
1,011 reads
Basic Cloud Computing Patterns for Application Development
Over the past few years, the cloud evolution has answered all questions on the cloud being the right strategy. The...
2014-02-08
824 reads
Top 10 Process Listing By Memory Consumption – GUI Tool
This Powershell GUI tool is used to list Top 10 memory consumption process of a given computer[local /Remote]. In the...
2014-02-07
968 reads
Watch the Growth of Walmart and Sam’s Club Across America #bigdata
This is pretty amazing. After 1970 the grow rate is astronomical for Walmart. You have got to watch this. Pretty...
2014-02-07
424 reads
Reblog: January 31 to February 6
Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...
2014-02-07
792 reads
Speaker of the Month, February 2014
I didn’t get out to many events in January, so I was somewhat limited in the pool of presenters that...
2014-02-07
711 reads
Nadella, Gates: Right Team For Microsoft? – InformationWeek
Does the pairing of Nadella and Gates foretell Microsoft’s return to glory or a new era of dysfunction? Take a...
2014-02-07
951 reads
Friday Followup For February 7, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-02-07
445 reads
Parent-Child SSIS Architecture
This is the first in a series of technical posts on using parent-child architectures in SQL Server Integration Services. The...
2014-02-07
2,217 reads
What Drives Microsoft’s Data Platform Vision?
FEATURED POST BY: Quentin Clark, Corporate Vice President, The Data Platform Group, Microsoft Corporation
If you follow Microsoft’s data platform work,...
2014-02-07
1,530 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