Uninstalling Software (Sucks) and Why Computers Are Still Slow
I've just recently acquired a new laptop and my resolution is to install no software on it that I'm not...
2008-10-16
681 reads
What's Your Job Title?
As I travel and visit DBAs from around the United States, I am always surprised at the job titles DBA...
2008-10-16
647 reads
How Many Drive Letters Do You Use for SQL Server?
I was teaching a private class recently that had both DBA's and network types in the room, one of the...
2008-10-16
836 reads
Looking for Free Educational Events to Attend?
Every week, there are dozen of free educational events to attend throughout the United States. The sad part is that...
2008-10-15
635 reads
Big and Small - Why Did I Write This?
I've always been very concerned about where I work. Well, maybe not always, since early in my career I took...
2008-10-15
637 reads
Flyclear Revisited
Back in May I wrote about signing up for FlyClear as a way to save time travelling and in doing so,...
2008-10-14
529 reads
Financial Trust
I’m sure that the people at Mint and Thrive have people’s best interests at heart. They built services designed to...
2008-10-14
955 reads
Too Good at Data Analysis - Why Did I Write This?
The past few weeks have been a rough one all around the globe as economies aren't doing well. I studied...
2008-10-14
608 reads
Should I Run for the PASS Board of Directors?
I saw the recent Call for Nominations for the election this year, so the title of this post is only...
2008-10-13
523 reads
Double Posting
I think that it’s a great idea to keep a few blogs going, and separate out your thoughts in different...
2008-10-13
639 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