5 More Power BI Tips
I’ve had this blog post in my mind to write for the past month or so and I’m finally just...
2016-07-07 (first published: 2016-06-29)
3,633 reads
The Desktop Rebuild–Part 3
This is the last part of this series, at least for now. If you haven’t seen Part 1 and Part...
2016-06-29
931 reads
Is Today Your Last Day Working With SQL?
Please entertain this thought for a moment – If today was your last day working with SQL how would you spend...
2016-07-08 (first published: 2016-06-29)
3,337 reads
Better Explorer on High dpi Displays
I’ve got a high dpi display on my laptop. The recommended resolution is 2560×1704. That’s small. I have had all...
2016-06-29
907 reads
Hearing Responsibility
A while ago I was watching Shark Tank on TV and at one point Robert Herjavich (T|B) made the great...
2016-06-29
705 reads
Finding, disabling and enabling foreign keys
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if...
2016-07-11 (first published: 2016-06-29)
1,968 reads
Uninstalling SQL Server from the Command Line to Remove Unwanted Background Instances
I had a note (or ‘action item’) to make sure that people were informed regarding the ‘uninstall’ of SQL Server,...
2016-07-11 (first published: 2016-06-29)
88,658 reads
If You Need to Think, You’re Doing It Wrong
A month ago, my wife and I were in Barcelona for a short vacation.
In one of the days, we entered...
2016-06-29
657 reads
Introducing SQL Server Reporting Services
In an earlier post I introduced the SQL Server umbrella and briefly discussed a number of products that make up...
2016-07-12 (first published: 2016-06-29)
3,148 reads
Automatic Seeding Very Large Databases in SQL Server 2016
There are a lot of new features in SQL Server 2016. Availability Groups by itself got a lot of new...
2016-07-12 (first published: 2016-06-29)
3,697 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