Book Review: SQL Server 2017 on Linux
I don’t have any statistics but I think most IT Professionals in the SQL Server field are managing or developing...
2019-01-11
480 reads
Cool Stuff in Snowflake – Part 2: LISTAGG
I’m starting a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2019-01-11
194 reads
Introducing ChaosLoad
Scripted Simulation of SQL Server Loads
When blogging, presenting or testing an idea, one issue I constantly have is that my...
2019-01-17 (first published: 2019-01-11)
2,363 reads
ASF 018 video invitation
What popular tool has he created in 2006?
What popular tool has he created in 2006? How many people do live...
2019-01-11
196 reads
Big Changes for WaterOx Consulting
March of 2019 would have marked that start of the 8th year of WaterOx Consulting, Inc. running. That isn’t going...
2019-01-10
214 reads
Sorting Values in a Column
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2019-01-10
288 reads
Watch: Can This Team Succeed at DevOps? Panel discussion
I recently participated in a panel discussion for the SQL PASS DevOps virtual chapter. If you didn’t make the meeting, you can catch our 90 minute discussion here about...
2019-01-10
18 reads
New vCore Compute Levels for Azure SQL Database and Elastic Pools
Additional vCore-based elastic pools and single databases have been expanded for the general purpose, business critical, and hyperscale service tiers....
2019-01-10
216 reads
Power BI World Tour 2019 Tampa
In just a few weeks (Jan 21-22) I will be presenting on two topics at the Power BI World Tour...
2019-01-10
369 reads
#SQLCareer 4/4 January 2nd 2019
Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be...
2019-01-10
179 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
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