Daily Coping 26 Aug 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-08-26
29 reads
Complete Guide To “SQL Server Security & Architecture and Internals”
[MSSQLFUN & Decode ITeS becomes a family of 1700 individuals across the globe. Please join us onFacebook & YouTube.] Refer our Complete Guide To “SQL Server Security & Architecture and Internals”...
2020-08-25
212 reads
It’s Not Horrible, It’s Just Very Sad
This is a non-technical post, but a necessary one for me. If you’re only interested in technical content, that’s okay, you can stop reading, I won’t be offended (heck,...
2020-08-25
59 reads
Who is your Fail-Safe Agent??
Did you know it is possible for SQL Server Agent to alert you of problems if something goes haywire with your Agent? Have you ever had an issue with...
2020-09-02 (first published: 2020-08-25)
416 reads
Daily Coping 25 Aug 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-08-25
22 reads
Azure SQL Database – Read Only Endpoints
One of the main benefits of configuring active geo-replication for Azure SQL Database is leveraging the read-only endpoint, a good technique to split away read only activity from OLTP...
2020-08-25
153 reads
New Pluralsight Course – Kubernetes Package Administration with Helm
My first course Kubernetes Package Administration with Helm has been published on Pluralsight and is now available! Check out the course overview here This course is aimed at anyone...
2020-08-25
65 reads
Recursively Querying Row Groups
Watch this week's video on YouTube
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to...
2020-08-25
34 reads
Recursively Querying Row Groups
Watch this week's video on YouTube
Recursively Querying Related Rows
Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you...
2020-08-25
38 reads
Recursively Querying Row Groups
Recursively Querying Related Rows Recursive queries are fun to plan and write. They can be frustrating too depending on the complexity of the problem you are trying to solve....
2020-09-02 (first published: 2020-08-25)
614 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