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...

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...

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...

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...

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...

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...

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...

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...

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...

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...