I make myself smile
Sometimes, usually when I’m editing video, I see myself do something silly. Today was one of those times, and these...
2011-02-09
711 reads
Work Goals for 2011-Part 2
It’s been a few weeks since I wrote my early thoughts on my goals for this year, and you can...
2011-02-09
796 reads
SQL University: SQL Server Security Architecture - 3rd Party, Some Options
Day 3 of Security Week at SQL University is now in session. You're implementing a third party solution and you...
2011-02-09
4,164 reads
A NULL Is Not Unknown
Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs.
Waiter,...
2011-02-09
788 reads
PowerShell Interfaces with Other Hammers
This month’s installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: “So the topic I have chosen for this month is Automation! It can...
2011-02-09
15 reads
PowerShell Interfaces with Other Hammers
This month’s installment of T-SQL Tuesday is hosted by Pat Wright (blog | twitter). Pat says: “So the topic I have...
2011-02-09
842 reads
T-SQL Tuesday #15 DBA Automaton
Often, we hear about DBA's automating everything under the sun. Why? It simplifies the job and creates time to work on other projects.
Related Posts:
Automating like an Enterprise DBA January...
2011-02-09
13 reads
T-SQL Tuesday #15 DBA Automaton
I have been incognito for the last couple of weeks and nearly missed TSQL Tuesday this month. If it weren’t...
2011-02-09
827 reads
You really like me?
And a bunch of other people who are really talented. My Zero to Cube session won the Summit Spotlight track...
2011-02-08
756 reads
Conquering Kilimanjaro & Cancer !
Day 1 – Leaving for Africa
After almost 12 months of fundraising, training, walking up various mountains, sleepless nights and plenty of...
2011-02-08
471 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