Speaking at PASS Summit 2016
I’m very honored to be speaking at the PASS Global Summit again this year in Seattle during the week of...
2016-06-29
409 reads
Summit Submission Feedback Response
I’m It Survival Tips for the Lone DBA – Level 100
(Not Accepted: Higher rated session selected)
Track: Professional Development
As others have done I...
2016-06-28
221 reads
Does my database have data type drift?
Over the years I have come to see that every database has what I call data type drift. Simply put,...
2016-07-13 (first published: 2016-06-28)
2,515 reads
Better ReadyRoll Script Naming
One of the things that I like about ReadyRoll is that the product will automatically build new scripts that are...
2016-06-28
632 reads
CASE Statement in GROUP BY
Set based operations means you should put everything into a single statement, right?
Well, not really. People seem to think that...
2016-07-06 (first published: 2016-06-28)
4,859 reads
Power BI Custom Visuals Class (Module 05 – KPI Indicator)
In this module you will learn how to use the KPI Indicator (This is kind of like saying “ATM Machine”...
2016-07-05 (first published: 2016-06-28)
2,680 reads
Slidedeck ITPROceed – Power BI Status Update
I uploaded my slidedeck from the ITPROceed event to Docs.com. For the abstract, see the blog post Speaking about Power...
2016-06-28
535 reads
BREXIT…IT professionals need a plan… much like the UK government
The events that have unfolded over the last few days since the shock result that the BRExit referendum delivered, has,...
2016-06-28
497 reads
The Desktop Rebuild–Part 2
You can read part 1, but that’s more about the (initial) hardware changes. This one looks at getting moving on...
2016-06-27
546 reads
Monday Morning SQL Break – June 27, 2016
The best way to make the most of the week is to set your goals. One of the things I...
2016-06-27
896 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