SSAS Tabular – Large Dimension Performance II
What are the limits?
What are the limits?
Of course, as a follow-up to my last article you might ask at least...
2017-11-29
154 reads
Blog Posts
2 Ways to Loop through collections in Pester
In my last post I showed you how to write your first Pester test to validate something. Here’s a recap
Decide...
2017-11-28
409 reads
AlwaysON Reporting Solution with SSRS
We will be going over the implementation of automatic failover setup for reporting services using availability groups. The report server databases...
2017-11-28
5,390 reads
I have a new Passion
Yes, I like to blog, maybe slightly more on Azure than SQL Server. I enjoy it and it probably explains...
2017-11-28
367 reads
My Favorite SSMS Shortcut (After Copy/Paste)
If there's one keyboard shortcut I use more than any other (with the exception of copy and paste) it would be the ALT + highlight multi-line edit/block selection shortcut.
Let's...
2017-11-28
23 reads
My Favorite SSMS Shortcut (After Copy/Paste)
Photo by Abhishek Desai on UnsplashIf there’s one keyboard shortcut I use more than any other (with the exception of...
2017-11-28
247 reads
PoshSSDTBuildDeploy Update – Now With Dynamic SqlCmdVar Updates
One of the big challenges in the whole “build once/deploy many” ideology is the need for environment configuration. And this...
2017-11-28
282 reads
PoshSSDTBuildDeploy Update – Now With LocalDB!
Hello!
Late on Friday I published a PowerShell Module that gives working examples of using DataToolsMSBuild. All very interesting, go and...
2017-11-28
329 reads
Power BI Custom Visuals Class (Module 78 – Data Image by CloudScope)
In this module you will learn how to use the Data Image Power BI Custom Visual by CloudScope. The Data...
2017-11-28 (first published: 2017-11-21)
1,429 reads
What is Azure Databricks?
Azure Databricks (documentation and user guide) was announced at Microsoft Connect, and with this post I’ll try to explain its use...
2017-11-28 (first published: 2017-11-20)
2,880 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
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...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
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