Freaky statistics feature
SQL Server statistics can make things a bit freaky. You might have read one of my previous articles portraying a...
2015-10-30
1,574 reads
From PASS Summit to MVP Summit
This was a really great week!
So many sessions by great speakers, lots of community events, parties and fun. I met...
2015-10-30
964 reads
Catching specific statements using new MI008 "Statement used" rule
Imagine that you want (for some reason) prohibit usage of some statement (or statements), eg - CURSOR
How can you find if...
2015-11-05 (first published: 2015-10-30)
1,869 reads
the game
So things are messed up. Bad. I mean, you lost a $2.7 Billion Dollar Secret Blimp or your team accidentally sent...
2015-10-30
1,101 reads
Tricks and Treats with XE
With the proximity to Halloween, it's not hard (knowing me) to figure out why I originally decided to terminate this series on the Eve of Halloween day. Join me...
2015-10-30
8 reads
Tricks and Treats with XE
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2015-10-30
1,024 reads
How to find blocked processes
Blocked processes are often a big problem for DBAs, because they’re difficult to monitor. We receive desperate calls saying “Everything...
2015-11-06 (first published: 2015-10-30)
7,194 reads
PASS 2015 Session Report – Understanding Real World Big Data Scenarios
PASS 2015 continues in Seattle, and today was my session at 1045am on Using Azure Machine Learning (ML) to Predict Seattle House Prices. The background and info on my session...
2015-10-30
20 reads
PASS 2015 Session Report – Understanding Real World Big Data Scenarios
PASS 2015 continues in Seattle, and today was my session at 1045am on Using Azure Machine Learning (ML) to Predict Seattle...
2015-10-30
975 reads
PASS Summit Key Note Day 2 – Recap
As I sit here in an offshoot of the convention center, I started reflecting back to this morning’s keynote for...
2015-10-29
864 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