T-SQL Tuesday #132: How Are You Coping with Pandemic?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Taiob Ali (b | t) and it’s about a topic I could...
2020-11-13 (first published: 2020-11-10)
192 reads
The rule of three, SQL Server on Linux edition
When it comes to Microsoft products, the rule of three — at least as far as I’m concerned — is where you can accomplish the same task in three...
2020-11-10
86 reads
Daily Coping 10 Nov 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-10
28 reads
I get by with a little help from my friends : T-SQL Tuesday #132
Taiob Ali (blog|twitter) is our host for TSQL Tuesday this month and he’d like us to talk about how our ... Continue reading
2020-11-13 (first published: 2020-11-10)
272 reads
T-SQL Tuesday #132 Pandemic Coping
This year, 2020, has been crazy. What started as a normal year for me, including a sabbatical, turned into a crazy, shutdown, lockdown, stuck at home pandemic around the...
2020-11-17 (first published: 2020-11-10)
238 reads
Notes on the 2020 PASS Virtual Summit – Part 2
Writing most of this Monday afternoon while on lunch break. I’m attending the Advanced T-SQL Querying and Query Tuning pre-con by Itzik Ben-Gan. You access pre-cons via the Virtual...
2020-11-10
32 reads
T-SQL Tuesday 132: Coping with a pandemic
This month’s T-SQL Tuesday is hosted by my good friend and data platform MVP Taiob Ali. Taiob’s challenge is very relevant to current season – he asks to blog...
2020-11-10
34 reads
Daily Coping 10 Nov 2020
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m adding my responses for each day here. Today's tip is to add the word "yet" when you feel you can't do something. This is good advice because […]
2020-11-10
24 reads
Notes on the 2020 PASS Virtual Summit – Part 1
I’m in learning mode this week, scheduled for two full day pre-cons plus the Summit. I’ve been to a couple of virtual events already this year, but they were...
2020-11-09
100 reads
PowerShell Arrays and Hash Tables–#SQLNewblogger
I was watching the GroupBy talk the other day and noticed that Cláudio Silva was using arrays, or what appeared to be arrays, in his talk. That was an...
2020-11-18 (first published: 2020-11-09)
379 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