Webinar: Change Detection in SQL Server
Change detection is a critical component of any system that moves data from one structure to another. Most data movement...
2019-03-22
404 reads
Using docker named volumes to persist databases in SQL Server
I’ve previously talked about using named volumes to persist SQL Server databases but in that post I only used one...
2019-03-21
439 reads
Power BI Now Has Keyboard Accessible Visual Interactions
The March 2019 release of Power BI Desktop has brought us keyboard accessible visual interactions. One of Power BI’s natural...
2019-04-10 (first published: 2019-03-21)
1,886 reads
Microsoft Azure – How to create the Azure Active Directory (AD) using Azure Portal
Microsoft Azure Active Directory (AD) is a cloud based service to handle the identity and access management. It has the...
2019-03-21
546 reads
Uppercase All String Columns (and in a Single Query!)
(last updated: 2019-03-21 @ 15:00 EST / 2019-03-21 @ 19:00 UTC )
Intro
The other day, Steve Jones published a short post with a quick...
2019-04-10 (first published: 2019-03-20)
1,542 reads
Two Weeks to #sqlinthecity Streamed
It’s just two weeks until the SQL in the City Streamed starts up again in 2019. I’m ready to travel...
2019-03-20
447 reads
Delete activity in Azure Data Factory - Cleaning up your data files
(2019-Mar-20) File management may not be at the top of my list of priorities during data integration projects. I assume that...
2019-04-09 (first published: 2019-03-20)
4,565 reads
Generating a Jupyter Notebook for Glenn Berry’s Diagnostic Queries with PowerShell
The March release of Azure Data Studio now supports Jupyter Notebooks with SQL kernels. This is a very interesting feature...
2019-04-08 (first published: 2019-03-20)
697 reads
The free SQL to Excel Export tool
Earlier this month I released a new, free tool to export SQL Server query data to Excel files without needing Excel....
2019-03-20
681 reads
Sizing your Azure SQL Database
Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...
2019-03-20
672 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