Custard Indexes
Not sure how or why this popped into my head (and too late for April Fools!), but it amuses me...
2018-04-13
470 reads
Blog Posts
Farewell, Robert Davis
Robert Davis (@SQLSoldier) died on Monday. A great technical guy, he did a lot of writing and presenting and answering...
2018-04-13 (first published: 2018-04-04)
3,138 reads
How to sync user logins across SQL Server instances – dbatools is brilliant
This blog post is about how brilliant dbatools are. In this case – for syncing user logins between SQL Server instances.
Background:
Whenever...
2018-04-13
1,063 reads
ITIL certification for DBAs – Part 1
In some point of your career as DBA you might have interacted with ITIL or at least your heard about...
2018-04-13
266 reads
ITIL certification for DBAs – Part 2
In my previous post I did my best explain a little bit what ITIL is and how important is for...
2018-04-13
250 reads
Ohhhhhh S…t!! A tribute to Robert Davis
Today marks 3 days since we’ve lost Robert Davis a.k.a SQLSoldier, one of the pillars of SQL Family community.
I was...
2018-04-13 (first published: 2018-04-05)
3,128 reads
4 Improvements to Azure SQL Database
If I was a wizard I would make these 4 improvements to Azure SQL Database. They are in no particular...
2018-04-12 (first published: 2018-04-05)
2,197 reads
Adding the KeyMap Extension in SQL Operations Studio
I’m playing with SQL Operations Studio a bit to get a feel for what works and what doesn’t. So far,...
2018-04-12
2,021 reads
Azure SQL DW – Let’s Shuffle?
Initially, the main focus of this post was going to be quick and about using the latest version of SSMS...
2018-04-12
884 reads
Change SQL Server Collation – Back to Basics
Every now and again we have to deal with a sudden requirements change. When that happens, we sometimes just need to take a step back and evaluate the entire...
2018-04-12
118 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