PASS Summit 2016 – Connect, Share, Learn
Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th....
2016-06-24
546 reads
The Desktop Rebuild–Part 1
I’ve had an aging desktop for some time. I originally bought it from Glenn Berry (b | t), who I think...
2016-06-24
541 reads
PASS Summit 2016 – My Session Evaluations
No Sessions For You! The announcements of the speakers and sessions selected for the PASS Summit 2016 were recently announced,...
2016-06-24
427 reads
My PASS Summit 2016 Session Submissions Feedback
I’m excited to say that I will be delivering a session in this year’s PASS Summit in Seattle later this...
2016-06-24
451 reads
Problems When Running DBCC SHRINKFILE On SQL Server Database
Overview of the Situation
While accessing data files in SQL Server, many issues may occur that may lead to frustrating situation...
2016-06-30 (first published: 2016-06-24)
2,294 reads
What do you want to learn about SSRS 2016 at PASS Global Summit?
I’m thrilled to have been selected to deliver a session at the 2016 PASS Global Summit titled “Reporting Services 2016:...
2016-06-29 (first published: 2016-06-24)
1,148 reads
Are my SQL logins weak?
Security is a vital component of data security. In today’s day and age it is imperative to think about security....
2016-07-04 (first published: 2016-06-24)
1,622 reads
Is Resource Monitor (resmon) all I need to troubleshoot storage?
I was recently doing some work on my Windows 10 desktop and placed a drive on one of the slower...
2016-06-30 (first published: 2016-06-23)
1,652 reads
Struggling With Due Diligence
It’s been a while since my last post, there are various reasons for my absence: work, illness, having our house...
2016-06-23
547 reads
Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why...
2016-06-23
19 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