Parameterization Part 6: Simple vs. Forced Parameterization
This is the sixth post in the “Parameterization” series. In the previous posts I explained what parameterization is, how plan...
2014-11-27
7,731 reads
Audit Database File Size Changes
If you just so happen to be running on SQL Server 2012 or later, you will need to change your event sessions that were tracking file changes. It is...
2014-11-26
27 reads
Audit Database File Size Changes
Recently I shared an article on how to track the growths and shrinks that occur within database files. I shared...
2014-11-26
2,591 reads
When the Problem is Not Them. It’s You.
Hello Dear Reader! I’ve been the Data Platform Management Lead at Pragmatic Works for almost two years now. It’s been...
2014-11-26
1,255 reads
What is Azure Data Factory?
The Azure Data Factory is a service designed to allow developers to integrate disparate data sources. It is a platform...
2014-11-26
2,082 reads
SQL Saturday Parma – English Slide decks available to download
My SQL Saturday Parma slide decks are available to download on SlideShare.
The main topic of those presentations is database lifecycle management (DLM)...
2014-11-26
39 reads
How to burn down your house while frying a turkey
It’s an odd query, yes, but in preparation to write this post I actually typed the above phrase into my...
2014-11-26
1,263 reads
Who’s on call
Kenneth Fisher:
I really enjoyed writing this post last year and honestly still enjoy reading it myself. And since tomorrow is...
2014-11-26
1,056 reads
PASS Summit 2014 ~ My GameTime Experience
“How did you like your convention?”
“How was your trip?”
“What did you learn?”
“Where did you go for a week?”
“Who did you...
2014-11-25
1,551 reads
SQL Saturday NYC
I excited to say that PASS SQL Saturday NYC is back on the schedule and will be May 30, 2015...
2014-11-25
1,020 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