The End of Summer
It's the first week of September, but Steve sees it as the end of summer. It's a time to catch up on things.
2026-09-04
69 reads
Editorials
Measuring Productivity
Today Steve wonders if the data professionals out there measure themselves on the job.
2026-09-02
122 reads
Preserving Data
Today Steve has a few comments on backups and your ability to get to a restore in the event of an issue with your provider.
2026-08-31
275 reads
When the Token Meter is Zero
DBAKevlar disccusses the new product from Perplexity and Nvidia that just shipped on August 25th. If you haven’t been paying attention its goal is businesses whose entire generative AI solution has been what the AI bubble is betting on.
2026-08-29
118 reads
2026-08-28
155 reads
Admin Rights for Everyone
Steve thinks administrator rights for too many people is a bad idea, but even when it's a limited group, he recommends some sort of governance.
2026-08-26
254 reads
A Challenge of Our Knowledge
AI is changing the world, but it's changing us as well, challenging the things we have been confident in and depended on in our career.
2026-08-24
152 reads
2026-08-22
128 reads
An Eventual Consistency Scam
Steve uncovers a scam that relies on data not being consistent between two systems.
2026-08-21
153 reads
Never is Not the Policy
Are there things you should never change or configure? Steve notes that is probably not the best policy.
2026-08-19
123 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