STORPORT: Reading an ETL trace
One of the things I enjoy most is diagnosing storage latency. I honestly couldn’t tell you why I enjoy it...
2018-03-05 (first published: 2018-02-19)
3,687 reads
Blog Posts
The Hidden Price Of Foreign Keys
Foreign key constraints put the “relation” into relational databases. They enforce integrity by requiring that a key value referencing another...
2018-03-05
476 reads
VSTS extensions, mixing VSS.require and import ... require
I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing a few vsts extensions and using typescript to write...
2018-03-05
14 reads
VSTS extensions, mixing VSS.require and import ... require
I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing...
2018-03-05
344 reads
VSTS extensions, mixing VSS.require and import ... require
I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing...
2018-03-05
137 reads
VSTS extensions, mixing VSS.require and import ... require
I have been starting to write more and more typescript lately and quite enjoying it. I have also been writing...
2018-03-05
142 reads
2018-03-02
536 reads
Data Modeling for Self-Service BI @ Techorama 2018
I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018...
2018-03-02
339 reads
Distributing SSH User Keys via PowerShell
Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take...
2018-03-02 (first published: 2018-02-18)
6,526 reads
New Built-in Function CONCAT_WS() – SQL Server 2017
In my previous post on new functions in SQL Server 2017, I discussed about the STRING_AGG function. Here, I am...
2018-03-02
1,388 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, 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