Daily Coping 10 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-10
29 reads
Daily Coping 9 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-09
26 reads
Webinar: How to unlock the value of frequent deployments
I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at some of the learnings from the 2020 State of Database DevOps report. I’ll be discussing...
2020-04-09
35 reads
SSMS 18.5 Fixes from Redgate
I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins from Redgate. I posted the release of the SQL Prompt fix (here: ). The teams...
2020-04-15 (first published: 2020-04-09)
1,907 reads
SQL Saturday Organizer Q&A
A little while ago, Ray Kim (blog | twitter) asked a few folks who organize SQL Saturday events a few questions for his blog. The results are in and...
2020-04-09
15 reads
SQL Prompt and SSMS 18.5
I downloaded SSMS 18.5, as there were a lot of fixes in here and thought this was a good upgrade to try. I’d heard reports of major changes in...
2020-04-08
2,255 reads
Jupyter Book Challenges in ADS
I was excited to try the Jupyter Book feature in the March Azure Data Studio (ADS) release. I’ve thought notebooks were an interesting way to teach and I’m looking...
2020-04-22 (first published: 2020-04-08)
334 reads
Join me (virtually) in Adelaide!
I will be presenting a session to the Adelaide SQL Server User Group on April 15th, 2020, and if you’re awake at that time (it’ll be 9pm on April...
2020-04-08
65 reads
Data Bits – Episode 5 – Louis Davidson
The one and only – Dr. SQL – Louis Davidson (b|t|t|t) stopped by for a chat! Relational Algebra, Disney, Dollywood and a SQL Dump Truck ??
The post Data Bits...
2020-04-17 (first published: 2020-04-08)
290 reads
Has this login been used recently?
I get asked this every now and again, along with the companion When was the last time this login was ... Continue reading
2020-04-20 (first published: 2020-04-08)
906 reads
Blogs
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, which is...
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