Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-05-23
15 reads
JSON data and a T-SQL variable.
G’day, You may have noticed when looking at FOR JSON AUTO or FOR JSON PATH that both clauses result in one single column that contains a JSON string. But,...
2020-05-23
2,159 reads
A New Windows Terminal
Watching the Build keynotes, I saw that the new Windows Terminal has been released. It looks mildly interesting, as I really like ConEmu, but it’s something that will be...
2020-05-22
75 reads
Watch out for your own confirmation bias
First, a true story: I was a senior in high school, applying for college. One of the colleges I applied for was the Naval Academy. As part of the...
2020-06-08 (first published: 2020-05-22)
358 reads
What are you tuning for?
People want to make things faster. It’s in our nature as IT professionals. What are you tuning for? I’ve been asking that a lot later. I have to sit...
2020-06-04 (first published: 2020-05-22)
341 reads
Quickly Blocking Inbound Connections to SQL Server
Sometimes the brilliance of a solution is lost in its simplicity. Full disclaimer, this was Joey D ’Antoni’s (B|T) idea, however, he has given me permission to blog about...
2020-05-22
10 reads
Quickly Blocking Inbound Connections to SQL Server
Sometimes the brilliance of a solution is lost in its simplicity. Full disclaimer, this was Joey D ’Antoni’s (B|T) idea, however, he has given me permission to blog about...
2020-06-04 (first published: 2020-05-22)
560 reads
Daily Coping 22 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-22
13 reads
Missing Biometric devices Node in Device Manager
If you have a Windows Hello compatible device (face or finger-print) and you are unable to use it, make sure Device Manager has a node for Biometric devices (see...
2020-05-21
39 reads
Missing Biometric devices Node in Device Manager
If you have a Windows Hello compatible device (face or finger-print) and you are unable to use it, make sure Device Manager has a node for Biometric devices (see...
2020-05-21
10,671 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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