Meeting My Goal
Last year I was talking about goals and changes for the site as I was negotiating my continued employment with...
2008-10-09
846 reads
Validating text data. A few techniques.
/*datafile used in the SQL */
DECLARE @String VARCHAR(MAX)
SELECT @String = 'When you are starting out to validate text input, perhaps to clean...
2008-10-09
1,117 reads
Project Management Management - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-09
933 reads
Tethering vs Air Card & Other Miscellaneous Phone Thoughts
I've been using a Blackberry Curve for a while and I'm been entirely happy with it. Great phone, great battery...
2008-10-08
536 reads
Take the Plunge - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-08
395 reads
Red Gate SQL Response Review is up
Full Disclosure: I did receive a trial version of the software and payment for the review. I am also a...
2008-10-08
965 reads
Do You Love PASS?
Recently Tony Davis posted some thoughts (almost a rant) about his opinions of PASS, and there is a great follow...
2008-10-07
703 reads
Database Administration Librarian
If I cannot find a book or info in a library, I always go to a librarian for advice and...
2008-10-07
630 reads
Can't Attend SQL Server Training in Person, Consider Virtual Training
I am one of the biggest advocates there is of self-education. Whether you are a novice, intermediate, or expert-level DBA,...
2008-10-07
1,018 reads
Always more to do
My current "to do" list, which is only partially written down and organized. Putting it all one one list is...
2008-10-07
398 reads
Blogs
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