Cleaning Your #PowerBI Power Query Code
Over the weekend I found this nifty tool called Power Query Management Studio. Someone shared it on Twitter and you’ve...
2015-08-10
616 reads
SSIS Catalog – Path to backup file could not be determined
I was creating an SSIS catalog at a new project, but I was greeted with the following error message when...
2015-08-13 (first published: 2015-08-10)
4,853 reads
An interesting setting for NULL but don’t use it for future TIP #109
As we discussed earlier in TIP#103 for NULL in which I shared that we have to take extra care for...
2015-08-09
557 reads
A big issue when try to Alter user define table type structure TIP #108
I hope all of you aware of User define table type (a table value parameter) which we discussed earlier in...
2015-08-08
1,358 reads
HealthySQL – A Review
A quick look into the book by Robert Pearl: Healthy SQL.
Related Posts:
My Book Contributions November 30, 2018
Profiler for Extended Events: Quick Settings March 5, 2018
How to be...
2015-08-07
15 reads
HealthySQL – A Review
How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or...
2015-08-14 (first published: 2015-08-07)
2,243 reads
SQL Sentry Grows in the UK and Beyond
Announcing two new UK-based SQL Sentry global technology evangelists. Please help me welcome John Martin and Richard Douglas.
The post SQL Sentry Grows in the UK and Beyond appeared first...
2015-08-07
26 reads
Another Career Podcast – Working at Microsoft
I have to admit, I had a lot of fun at SQL Saturday in Philly this last June; I mean...
2015-08-07
508 reads
Twitter Analysis with #PowerBI & Plus One
Earlier this week Christopher Finlan put together this awesome Datazen dashboard using Plus One. Christopher has been doing a lot...
2015-08-07
722 reads
Career Progression
Deciding to change jobs can be one of the most difficult decisions you can make. At Dell I was part...
2015-08-07
507 reads
Blogs
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...
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