Upcoming Presentations
Just a quick note to let you know about a few upcoming presentations I’ll be doing. This week I’ll be...
2013-06-11
628 reads
sqlchicken
Internet Security Advice For The Family
Constant Vigilance!For today’s post I’m channeling my inner Brian Kelley (Blog | Twitter) and talking about security, in particular Internet security....
2013-05-28
999 reads
Business Objects on Linux and SQL Server
This is just a quick post to share a lesson learned while I was on an engagement where the client’s...
2013-05-23
980 reads
Speaking at PASS Summit 2013!
I’m happy to officially announce that I’ll be presenting at this year’s PASS Summit in Charlotte, NC! I’ll be presenting...
2013-05-22
562 reads
Magnify SQL Text with SSMS 2012
This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday....
2013-05-16
844 reads
SQLSaturday #209 – Rochester
Welcome to the Roc!
Just a quick note that I’ll be presenting this weekend, Saturday May 11th, at SQLSaturday in Rochester,...
2013-05-08
797 reads
Necromancing the Chicken
First off, I’m sorry this space has been dead for so long. I’m sure I’ve dropped off many an RSS...
2013-04-16
870 reads
24 Hours of PASS Fall 2012
Do you like training? Do you like FREE training? Then make sure you check out the 24 Hours of PASS...
2012-09-20
1,293 reads
How To Prevent SELECT * The Evil Way
SELECT * FROM…when administrators see that from developer code, we generally tend to cringe. Why? In a nutshell, it’s terrible on...
2012-07-27
1,900 reads
Identify and Alert for Long-Running Agent Jobs
Being a DBA is like being a train conductor. One of the biggest responsibilities is making sure all jobs are...
2012-07-09
11,276 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