Pick the Right Database in Azure
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2015-08-24
737 reads
Stock Market Chart in Power BI
U.S. stock markets have taken a beating this past week fueled by China markets. Take a look at how China and...
2015-09-02 (first published: 2015-08-24)
3,552 reads
Setting Up an HDInsight Cluster (No Scripts Required)
Let me start by saying, I am not a fan of scripting. It definitely has its place and a lot...
2015-09-01 (first published: 2015-08-24)
1,466 reads
Targeted Plan Cache Removal
A lot of times you’ll hear how people are experiencing sudden, intermittent, poor performance on a query, bad parameter sniffing...
2015-09-02 (first published: 2015-08-24)
1,587 reads
The tail of the log
The tail of the log
A little while back I was feeling overwhelmed by the number of blog posts ideas that...
2015-08-24
654 reads
Above All, Good Judgment
What is permissible is not always honorable. – Marcus Tullius Cicero
Rules. Best practices. Guidelines. Design patterns. Policies. All are good and...
2015-08-24
585 reads
Actual Emails: Allow NUNS to Lead You to Good Clustered Index Design
Wrote this email exchange with a colleague who wanted to confirm that the client-proposed design for a table was... less...
2015-08-23
439 reads
WWH in SSIS ? Zero to Hero in SSIS series TIP#111
Dear Friends,
As shared in last post Post #110, We are starting SSIS tutorialseries ( A Step by Step SSIS learning tutorial)...
2015-08-22
830 reads
016 – Me, Myself and I - WaterOx Consulting
Me, Myself and I In WOxPod!, episode # 016 – “Me, Myself...
The post 016 – Me, Myself and I appeared first on WaterOx...
2015-08-21
804 reads
Versions (Master Data Services) - Where to use
Multiple versions of the master data within a model can be created in Master Data Services(MDS). When you create a model for the first time, Master Data Services (MDS)...
2015-08-21
268 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