LiveWriter
I’ve been experimenting a bit in the blogging world, setting up a few blog accounts and trying different services. I...
2008-10-13
640 reads
Post Event Notes on SQLSaturday #5 & SQLSaturday #9, and Future Plans
Thought I'd post these notes based on feedback from the event organizers, wasn't able to attend myself due to scheduling...
2008-10-13
544 reads
Back to 400
I had to research a bit, write some code, and look up things to answer questions this morning. I must...
2008-10-13
705 reads
Data Farming - Why Did I Write This?
I grew up in the Cold War, with real concern that the Russians would attack us someday. I wanted to...
2008-10-13
818 reads
SQL Server MVP
Can't say I ever expected to say this, but as of October 1st I'm a SQL Server MVP. A nice...
2008-10-13
888 reads
SQL Saturday in Olympia , WA Pulls in Crowd of over 130 DBAs and Developers
A SQL Saturday event was held Saturday, October 11, 2008 in Olympia, WA. Sponsored by the Olympia Area SQL Server...
2008-10-11
569 reads
One File Per Core?
For a long time in my career I heard various advice on how many files you should create for a...
2008-10-10
958 reads
Database Health - 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-10
627 reads
Do You Understand Microsoft Licenses?
I had an email from a friend recently asking about a licensing question pertaining to Microsoft. It reminded me of...
2008-10-09
545 reads
Tulsa TechFest Draws a Crowd of Over 500
The annual Tulsa TechFest (Tulsa, OK) had over 500 attendees today (Thursday), and is expecting another 500+ attendees on Friday....
2008-10-09
451 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...
FARE LABS Pvt. Ltd. is a Proficiency testing laboratory located in India.
The top proficiency testing facility in India is Fare Labs. We employ particular metrics...
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
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