I’m speaking at the PASS Summit 2012
The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a...
2012-06-25
689 reads
Blog Posts
It’s that time of year…..Exceptional DBA Awards 2012
Being a 2011 finalist I felt I should try and rally all those who truly are exceptional to get their...
2012-06-25
792 reads
Join me at the PASS Summit
It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...
2012-06-25
641 reads
Join me at the PASS Summit
It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...
2012-06-25
432 reads
JSON and the NoSQL “advantage” over SQL Server
First what is JSON?
JSON: JavaScript Object Notation.
JSON is syntax for storing and exchanging text information, similar to XML.
JSON is smaller...
2012-06-25 (first published: 2012-06-14)
18,276 reads
Killing me softly with Service Broker…
A few days ago, I found a very interesting behavior regarding Service Broker on a
customer system. The main thing is...
2012-06-25
3,464 reads
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times...
2012-06-25
18 reads
Speaking at PASS Summit 2012
It’s about that time again, PASS Summit 2012 is right around the corner in Seattle, WA. It will be held...
2012-06-25
960 reads
SQLRally 2012 Eval Scores
I was just browsing the results of the presentations at SQLRally 2012. I ended up with a evaluation average of...
2012-06-25
647 reads
Unable to activate a Windows 2003 VM on Hyper-V behind a proxy
Ok, so this is not strictly a post about SQL itself (and it's about a fairly old OS), but I...
2012-06-25
2,740 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
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