Pro SQL Server on Linux- More Installs
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-01-14
801 reads
Today, I’m making my 100th post on SQLShack
The journey with the SQLShack family has been a one from the beginning. It is certainly not easy to join an excellent group of elite authors. When I joined...
2019-01-14
24 reads
Today, I’m making my 100th post on SQLShack
The journey with the SQLShack family has been a one from the beginning. It is certainly not easy to join...
2019-01-14
178 reads
Availability Groups: When Your Synchronous Secondary isn’t Synchronous
During a recent DR scenario I came across a slight misinterpretation in how availability groups with replicas in synchronous commit...
2019-01-22 (first published: 2019-01-14)
2,069 reads
DevOps and Automation Will Eliminate the DBA
I’ve been reading about the death of the DBA ever since I first made the jump from full time developer...
2019-01-23 (first published: 2019-01-14)
2,702 reads
Developing Presence
At SQL Saturday Nashville, I didn’t do a good job explaining the concept of presence. This is in reference to...
2019-01-25 (first published: 2019-01-14)
1,856 reads
SQL Server Monitoring: What to start measuring
So you’ve got a SQL Server that you want to monitor. What should you monitor? In my opinion, at bare...
2019-01-22 (first published: 2019-01-14)
2,705 reads
Quick Permissions Audit
DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.
Related Posts:
Easy Permissions Audit...
2019-01-14
28 reads
Quick Permissions Audit
Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out...
2019-01-21 (first published: 2019-01-14)
2,902 reads
SQL Bits 2019: The Great Data Heist
SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL...
2019-01-14
733 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