Event and Session Evaluation Results for SQLSaturday Orlando
SQLSaturday is ultimately about attendees, and they finally speak! The scores look very good and the comments should be useful...
2007-12-02
629 reads
Blog Posts
The DBA Routine Posted on SSC
This was fun to write, though it's hard to boil everything down to 10 big steps. I thnk as an...
2007-11-30
1,452 reads
Another use of OpenRowSet()
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,423 reads
MS, kill Begin/End!
It's funny - sorta - how you become used to the quirks of the tools you. I try not to rant too...
2007-11-29
1,423 reads
Why Don't People Go to Free Training?
I was having this discussion recently with Shawn Weisfeld, President of ONETUG and it's definitely a frustrating topic. As a...
2007-11-28
1,430 reads
Community Search vs Brute Force Algorithms
I was reading an interview with Jimmy Wales (the Wikipedia guy) in Selling Power magazine (I have ecletic reading preferences...
2007-11-26
1,374 reads
Google CIO and IT Strategy
CIO Magazine has a interesting article about Douglas Merrill, the CIO of Google. One of the things he dicusses in...
2007-11-26
1,718 reads
Passed 70-431
After putting it off for six months, I finally took - and passed - 70-431 yesterday. I know, I'm probably one of...
2007-11-25
1,458 reads
Honeypots in the Database
As a follow up to my post about Cesar Cerrudo's new whitepaper, earlier this month David Litchfield talked about putting...
2007-11-23
2,357 reads
Whitepaper on Malware to Attack Databases
Cesar Cerrudo of Argeniss Information Security has put out a new whitepaper (.pdf format), Data0: Next generation malware for stealing...
2007-11-23
1,988 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