Data Warehousing Tip #4 – Trust your instinct
My fourth data warehousing tip is to trust your instinct when it comes to building solutions, and if to you...
2019-01-21 (first published: 2019-01-14)
2,917 reads
Dodging Deadlocks With Indexes
A lot of people don’t realise that some deadlocks can be removed entirely with the introduction of a new index....
2019-01-23 (first published: 2019-01-14)
6,523 reads
WordPress's Block Editor and the Publicize Feature
Like many folks using Wordpress, I post a tweet each time I publish a blog entry and that’s done automatically by Wordpress. In the Wordpress Classic Editor, there was...
2019-01-14
17 reads
Last Week Reading (2019-01-13)
Good morning chaps! Bunch of news from the world of data freshly served. Press Office Hours 2019/1/2 (With Transcriptions) The...
2019-01-13
204 reads
MongoDB Replica-Set
The most important feature of MongoDB is its easy setup and use of Replica set. in mongo db you can...
2019-01-13
181 reads
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My new course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you want to learn about the course, check out...
2019-01-12
8 reads
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
New Pluralsight Course – Kubernetes Installation and Configuration Fundamentals
My new course “Kubernetes Installation and Configuration Fundamentals” in now available on Pluralsight here! If you...
2019-01-12
249 reads
MongoDB – Storage
MongoDB has a Storage Wired Tiger by default MongoDB generated some standard wt (WiredTiger extension) files, WiredTiger uses MultiVersion Concurrency Control...
2019-01-12
178 reads
The Necessary Extras That Aren’t Shown in Your Azure BI Architecture Diagram
When we talk about Azure architectures for data warehousing or analytics, we usually show a diagram that looks like the...
2019-01-18 (first published: 2019-01-11)
2,390 reads
Execution plans: RetrievedFromCache
I first came across the value for RetrievedFromCache when I was reading a confusing execution plan. At first, I thought...
2019-01-11
732 reads
Blogs
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...
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
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