Working From Home
It’s now been one month since I’ve started to work for Denny Cherry & Associates Consulting. Working for DCAC now enables...
2017-12-01
183 reads
Blog Posts
Design Concepts For Better Power BI Reports – Part 2: Preattentive Attributes
Preattentive attributes are visual properties that we notice without using conscious effort to do so. Preattentive processes take place within 200ms...
2017-11-30
859 reads
Eliminating Hassles
It is easy for me to fall into the trap of the “who” versus the “what”. If we are not...
2017-11-30 (first published: 2017-11-20)
1,302 reads
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got an error message to say “The host cannot be...
2017-11-30
22 reads
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
231 reads
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
677 reads
Fixing SQL AG Routing "Cannot find host" using packet analysis (and a spell checker)
I was setting up an availability group listener recently and when I tried to connect to the listener I got...
2017-11-30
215 reads
Handling Missing Instances when Looping with Pester
In my previous posts about writing your first Pester Test and looping through instances I described how you can start...
2017-11-30
694 reads
Hit Refresh
I read Satya Nadella’s Hit Refresh recently, and it was a very enjoyable book. He’s had an interesting journey and...
2017-11-30
676 reads
I’m Presenting Two Linux Sessions on One Day!
On 12/13 I’m presenting two, back to back, sessions on SQL Server on Linux online. So you can attend from anywhere!
Let’s go through both!
First, on 12/13 at 1PM Central,...
2017-11-30
11 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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