Our SQL Server 2017 Administration Inside Out fun author survey
I was honored to be on the author team of the new SQL Server 2017 Administration Inside Out book by...
2017-12-20
805 reads
Blog Posts
UNDERCOVER TOOLBOX: sp_AGReconfigure – Manage Always on Sync & Failover settings from a single stored procedure.
From time to time we need to make changes to Always on Availability group Synchronization mode settings , this also includes...
2017-12-20 (first published: 2017-12-08)
1,497 reads
Westbound and down, roll ’em up and truckin’
A little less than 2 years ago, my wife and I loaded up our cats and dog and moved from...
2017-12-20
472 reads
A Basic Bot using Azure Bot Services
I wanted to break out my comfort levels and do something different from Azure SQL Database or straight SQL Server....
2017-12-19
589 reads
Do You Really Need Real-Time?
It wasn’t so long ago that the first day of the month was the most common trigger event for updating...
2017-12-19
404 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like...
2017-12-19
8,490 reads
How To Create Multi-Object JSON Arrays in SQL Server
Recently I was discussing with Peter Saverman whether it would be possible to take some database tables that look like this:
And output them so that the Cars and Toys...
2017-12-19
119 reads
How to Update @@SERVERNAME to Actual Machine Name?
The @@SERVERNAME Global Variable
The system global variable @@SERVERNAMEcan be used to return the name of the machine the SQL Server...
2017-12-19 (first published: 2017-12-07)
4,778 reads
Key Sets, or Inverted Keys - defining a key as a set of tuples
TL;DR:
I have been doing a lot of thinking about data models for the last couple of weeks. I have, just...
2017-12-19
497 reads
Mapping SQL Trace to Extended Events
Since I started actively participating in SQL community, I found it is very common that people will approach to seek...
2017-12-19
2,208 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