So You Want to Write a Book?
What the heck is wrong with you?
Still interested? Fine. I’ll tell you my take on this whole business. I’m only...
2010-02-19
708 reads
The Scary DBA
Buck Woody on Code Writing Code
I realize I’m prejudiced, being one of those evil DBA’s & all, but I can’t help but agree with him. It’s...
2010-02-16
784 reads
nHibernate Database, First Look
I’m getting my first look at a full-fledged nHibernate database developed by consultants for our company. I thought I’d share...
2010-02-15
1,304 reads
SQL Saturday #34 Wrap-up
Whew!
It’s over. New England Data Camp v2, aka, SQL Saturday #34, was completed on Saturday. Going in we had maxed...
2010-02-01
591 reads
SQL Saturday #34
The event is this Saturday. Take a look at our sponsors, speakers and the program. It’s going to be a...
2010-01-27
601 reads
A Call to Arms
Phil Factor’s most recent guest editorial over at SQL Server Central has, to a degree, pointed out that the emporer’s...
2010-01-25
808 reads
PowerShell Script for Creating Indexes
I needed to create an identical index on a bunch of tables within one of my projects (yes, I know...
2010-01-21
1,813 reads
What three events brought you here?
Another one of the DBA bloggers games of tag is occurring. I’ve been asked by Tom LaRock to answer Paul...
2010-01-18
754 reads
Database Design Process
Buck Woody recently asked a question; how do you design a database. He outlined the process he followed and asked...
2010-01-18
1,921 reads
SQL Server Standard Volume 7 Issue 1
Kathi Kellenberger’s fantastic new article is available in the latest issue of SQL Server Standard. There are a lot more...
2010-01-13
841 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
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