Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)
Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
As a logical continuation from the blog...
2018-01-05
872 reads
Blog Posts
Converting a Datarow to a JSON object with PowerShell
This is just a quick post. As is frequent with these they are as much for me to refer to...
2018-01-05 (first published: 2017-12-18)
1,707 reads
Meltdown and Spectre exploits, they can affect your SQL Server instances
A bug was recently discovered on almost every processor made on the last 10 years, and it seems that almost...
2018-01-05
66 reads
Reference architecture for enterprise reporting in Azure
As I mentioned in my recent blog Use cases of various products for a big data cloud solution, with so many...
2018-01-05
713 reads
Reference architecture for enterprise reporting in Azure
As I mentioned in my recent blog Use cases of various products for a big data cloud solution, with so many...
2018-01-05
98 reads
SQL Puzzle 5: Prime Magic
Quite a few of you have read or attempted the previous puzzle SQL Puzzle 1: Magic Squares
As a quick reminder, when...
2018-01-05 (first published: 2017-12-19)
1,678 reads
Trello – Overview
Last month in December, I posted an article about working from home. In it I mentioned a couple of tools...
2018-01-05
425 reads
Trello – Overview
Last month in December, I posted an article about working from home. In it I mentioned a couple of tools...
2018-01-05
583 reads
Working with Query Files (Day 5)
So you’re working with a query that you have loaded from a saved file. And now you want to open...
2018-01-05
382 reads
An Identity Crisis: Is it Profiler or is it Extended Events?
I have been working on this article for far longer than one might think is necessary for something of this...
2018-01-04 (first published: 2017-12-22)
2,030 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