Hey Kids! Let’s Put on a Show at the Old Barn
Alternate Title: I’m traveling a bunch. Let’s get together and talk.
A bunch of trips and presentations coming up, so I...
2015-07-29
981 reads
Halloween at PASS–Donate for some fun
This year’s PASS Summit will end on Oct 30, which is just before Halloween in the US. I’m sure lots...
2015-08-05 (first published: 2015-07-29)
1,914 reads
DBTA – IT Employers Must Adapt to the Looming DBA Shortage
Originally appearing in my monthly column at Database Trends & Applications magazine. In the first of this three-part series, I described some of the findings contained in an intriguing...
2015-07-29
29 reads
Some of my favorite SSMS Keyboard shortcuts
I love keyboard shortcuts. I recently mapped a keyboard shortcut to Change Connection and thought I would share some of...
2015-07-29
1,279 reads
Synchronous Processing in the SSIS Script Component
Without a doubt, the most versatile data flow tool in the SSIS arsenal is the script component. This control grants...
2015-08-05 (first published: 2015-07-29)
2,900 reads
Password for SQL Server Service Accounts
I wrote recently about my philosophy for service accounts, and wanted to add a few more thoughts.
Security is important for...
2015-07-28
1,519 reads
Grant’s Fly-by-night Leadership Course – The Plan
Get a better nameDefine my personal goals for the courseI won’t be sharing these with you. I may share them...
2015-08-07 (first published: 2015-07-28)
1,897 reads
SSC Editorial: Would You Pay to Wear Jeans at Work?
Would You Pay to Wear Jeans at Work turned out to be popular piece when posted a couple weeks back. The...
2015-07-28
634 reads
Database Stuck in Single-User Mode Due to Botched Restore
Working in a development environment, I botched up a restore. After this restore attempt to overwrite my database with the...
2015-08-04 (first published: 2015-07-28)
3,136 reads
When Emotional Intelligence Trumps Math
I have been in Corporate IT long enough to know that when a bad decision is made, you move out...
2015-07-28
478 reads
Blogs
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...
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