Quick Tip: Accurate Log Shipping Status
Here’s a quick reminder for those of you using log shipping, and checking the SSMS report “Transaction Log Shipping Status”...
2012-08-16
894 reads
2012-08-16
813 reads
Free Tools for Testing SQL Sever
You Need To Test Your SQL Server!
Its like screaming “TEST THE BREAKS ON YOUR CAR!” If you don’t have the...
2012-08-16
2,256 reads
Coming to Your Town
I can’t sing and I can’t play and I left the young generation behind a while ago, but I’m still...
2012-08-16
1,173 reads
Replication and TFS
So, we’ve had this issue lately at work with our TFS build/deploys causing a significant amount of contention and only...
2012-08-16
2,344 reads
SQL Saturday 151 BI Pre-con: Stacia Misner
Hello Dear Reader, SQL Saturday 151 Orlando is picking up steam. The Pre-Con’s have been named and they are fantastic. ...
2012-08-16
745 reads
Speaking at 24 Hours of Pass
24 Hours of PASS (24HOP) has been around a few years now, but this will be my first time participating...
2012-08-16
570 reads
Meme15: Top 5 Reasons I Like My Job
This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’. A little over a year ago, I started...
2012-08-16
1,337 reads
Unwanted dependency between different parts of the code
Small systems tend to grow with new functionality and new access points. When the system grows, the need for data...
2012-08-16
1,142 reads
Dealing with negative session ids
Hello? Mr. DBA? Have you got a moment?
So there you are, enjoying one of the few quiet moments of your...
2012-08-15
5,330 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