TSQL2sday #66 – Monitoring
A big thank you to Cathrine Wilhelmsen (blog | twitter) for hosting this month’s TSQL2sday party. Monitoring is this month’s topic...
2015-05-12
580 reads
T-SQL Tuesday 66 Monitoring – Agent Alerts
Alerts have been around for as long as I can remember, so some time before breakfast. That probably means you...
2015-05-12
1,159 reads
Make Sure You’re Eligible to Vote in the 2015 PASS Election.
Per the post from Bill Graziano, if you want to vote in the 2015 election you have to make sure...
2015-05-11
309 reads
The Murder Train is pulling into Iowa City
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-05-11
574 reads
Come Speak at SQLSaturday Orlando on October 10, 2015
It’s five months until SQLSaturday Orlando, have you thought about your speaking plans for October? We’d love to have you come...
2015-05-11
358 reads
Monday Morning SQL Break – May 11, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-05-11
731 reads
Notes From SQLSaturday Jacksonville #391
Beautiful weather for a SQLSaturday! Everything went well, as expected but always appreciated. Just a few notes on this one:
They...
2015-05-11
282 reads
Watch The EngineerGuy–Great for Kids
Great explanation of some interesting engineering topics at http://www.engineerguy.com/.
2015-05-11
316 reads
Is Performance Better With LEFT JOIN or RIGHT JOIN?
I tend to write my queries using LEFT JOIN. Why? Because logically I see it in my head like this:
Give...
2015-05-20 (first published: 2015-05-11)
7,096 reads
Introduction to Azure DocumentDB
This is a basic introductory post about Microsoft’s new product: Azure DocumentDB, and how it compares to SQL Server.
What is...
2015-05-11
1,294 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