The value of durable keys in type-2 dimensions

An underutilized technique in the design of type-2 dimensions, and one that I have only started using consistently myself in the past few years, is the concept of a durable key…

Automating Power BI deployments: Assign workspace permissions

Assigning permissions (or updating them) is by far the most “complicated” task we’re going to attempt, mostly due to the fact that we’re going to do it all in one PowerShell script. The “complication” is mostly self-inflicted because of the following…

About Me

Hi, I’m Martin. I like to help people make sense of their data, using Microsoft technologies. This blog is my attempt at giving back to our awesome community, from which I have received so much. Hope you find it worth reading!

Subscribe to My Blog

Get new content delivered directly to your inbox.

Administration Analysis Services Biml Business Intelligence Calculated Measures Career Data Warehouse Architecture DB2 Drivers Dimensional Modeling ETL Events Feature Packs General iif-function Installation Internet Explorer 9 MDX O365 OLEDB Drivers Parameter Sniffing PASS PASS Summit Performance Power BI Power Query PowerShell Presentations Report Builder 3.0 Reporting Services Scoped Assignment SetToStr Function SharePoint 2010 SQL Saturday SQL Saturday SQL Server SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SSAS SSAS 2008 R2 SSIS SSRS 2008 R2 SSRS 2012 T-SQL Temporal Fact Table