An All Star Lineup for EightKB
An online conference is coming on June 17, 2020 that is full of high level content. It’s the type of event that I think contains information relatively few people...
2020-06-03
87 reads
How should I store currency values in SQL Server?
On Twitter, Michael Dyrynda writes: ?? Never ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever ever...
2020-06-03
344 reads
What happens if your SQL Server editions are out of support? – a MinionWare snippet
The more your SQL Server is out of date, the more things become vulnerable, broken and unfixable, limited in features, and expensive.
The post What happens if your SQL Server...
2020-06-03
21 reads
What happens if your SQL Server editions are out of support? – a MinionWare snippet
The more your SQL Server is out of date, the more things become vulnerable, broken and unfixable, limited in features, and expensive.
The post What happens if your SQL Server...
2020-06-03
179 reads
Daily Coping 3 Jun 2020
I’ve 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-06-03
24 reads
Lock your Azure SQL Database
So you have many databases in Azure, you accidentally deleted one which can happen and has happened to me because in my situation they had very similar naming conventions...
2020-06-03
163 reads
BlitzFileStats custom module available for Inspector V2
BlitzFileStats is the latest addition to our custom module collection for reporting on data logged to tables using the First Responder kit, We created a new project where we plan on...
2020-06-03
34 reads
Fun Fact: AWS RDS and system_health
Did you know that the system_health Extended Event session was running in your RDS instances? Well, it is. HOWEVER. This query, which works perfectly fine on my on premises...
2020-06-02
77 reads
Daily Coping 2 Jun 2020
I’ve 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-06-02
15 reads
TSQL Tuesday #127 Invite – Non SQL Tips and tricks
How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a ... Continue reading
2020-06-02
38 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