Announcing Minion CheckDB release date!
Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup...
2016-11-28
1,064 reads
Jen McCown
Fight harassment: be the “Backup” at PASS Summit
Harassment is a problem at some of the conferences we go to. What can we, as attendees and speakers and...
2016-10-11
417 reads
Step by Step: WHERE, GROUP BY, and HAVING
People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the...
2016-10-07
626 reads
PASS Summit 2016: Recommendations and Invitations (#sqlpass #sqlsummit)
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I...
2016-09-06
516 reads
October precon in Orlando: “The Lifecycle Approach: Maintenance Problems & Solutions”
On October 7 we will be presenting a full day of maintenance and backup learnin’! Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724 And while you’re at...
2016-09-05
476 reads
Conference speakers: Why do you teach at events?
I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at...
2016-08-29
853 reads
An MCM teaches COMMENTS at SQL Saturday OKC
Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events...
2016-08-26
501 reads
Slash star, dash dash: Be obsessive about comments
I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the...
2016-08-12 (first published: 2016-08-08)
2,003 reads
Tricky TSQL: NOT IN (NULL)
We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means...
2016-08-11
1,051 reads
Feasel’s Grand Analysis of the PASS 600 mile radius rule
UPDATE: Last week, PASS announced an update to the 600 mile radius announcement: “…we will be piloting the 600-mile driving radius...
2016-08-10 (first published: 2016-08-01)
1,199 reads
Blogs
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, which is...
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