Mattias De Smet - Microsoft BI and Azure solved cases

Jun 28 2020

BI : Securing SSIS project deployments

by mattias

No Comments

When you’re sharing an on-premises SSIS server with multiple teams you’d want to segregate responsibilities to their projects. It’s not a much advertised feature of SSISDB, but it allows you...

Jun 22 2020

Business Intelligence

SSAS : Unexpected root elements in Parent Child dimension

by mattias

No Comments

This article describes a bizar behavior of root elements in Parent Child dimensions. A Parent Child dimension is a dimension based on a self-referencing table, where each record (member) points...

Jun 16 2020

Business Intelligence

SSAS : Locale Error while processing cube

by mattias

No Comments

In the past I came across two strange errors when processing a cube: Locale 8129 not supported – this was just a warning, processing succeeded. Still, it didn’t radiate confidence....

Jun 14 2020

Business Intelligence

SQLServer : disable inactive logins

by mattias

No Comments

SQLServer doesn’t have a functionality to expire accounts if they have not been used for a certain amount of time. Sometimes this can come in handy, e.g. in an environment...

Jun 07 2020

Business Intelligence

Create REST API on SQLServer database

by mattias

No Comments

In the past SQLServer offered native webservice support, but this was deprecated in SQLServer 2008 and recommended to be replaced with WCF or .Net custom application. Since many applications require...