Watch all my free PASS Summit recordings– and more videos at Pass.org
A magical thing happened this week in the SQL Community Slack (it’s free to join, by the way, sign up here). In the midst of a discussion about the...
2019-01-16
81 reads
Butter in My Coffee and Low Carb Tortillas: Keto Day 2
Hello Dear Reader, just a quick check in, I had originally planned to blog yesterday. However, screen shots of apps made for a terrible looking blog.Fortunately I found that...
2019-01-16
26 reads
Butter in My Coffee and Low Carb Tortillas: Keto Day 2
Hello Dear Reader, just a quick check in, I had originally planned to blog yesterday. However, screen shots of apps...
2019-01-16
235 reads
Data Modeling Webcast Rescheduled
Unfortunately, due to a last minute scheduling conflict on my side, we’ve had to reschedule the data modeling webcast with...
2019-01-16
142 reads
A brief introduction for bcp
I end up using the bcp utility to move tables between environments, and I’ve found that a lot of the...
2019-02-04 (first published: 2019-01-16)
3,203 reads
Controlling the firewall for an Azure SQL DB via T-SQL
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I...
2019-01-29 (first published: 2019-01-16)
2,250 reads
Let’s talk SQL Server Waits: Topic 2 – CXPacket
With our effort to talk about SQL Waits we come across another common wait called CXPacket. Last week we reviewed...
2019-01-30 (first published: 2019-01-16)
2,717 reads
Inspector V1.3 hotfix
Unfortunately we discovered a small bug in 1.3, the Database ownership module default warning level was not showing a yellow...
2019-01-16
184 reads
Deploying SQL Server to Kubernetes using Helm
In previous posts I’ve run through how to deploy sql server to Kubernetes using yaml files. That’s a great way...
2019-01-29 (first published: 2019-01-16)
2,689 reads
It’s always parameter sniffing (part 1?)
This is a blog post about a perennial issue. Have you ever had a call in the middle of the...
2019-01-28 (first published: 2019-01-16)
3,047 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