Mattias De Smet

Aug 19 2022

Azure, Navision

SQL : Configure automatic failover

by mattias

No Comments

Having some redundancy in your database infrastructure is essential to making sure your applications are accessible as much as possible. Even with a solid platform as Azure SQL database, you...

azure, database, db, failover, navision, primary, replica, sql

Aug 18 2022

Azure

Hiding secrets from Azure Functions

by mattias

No Comments

When creating Azure Functions in support of database related logic, or with any need to use a sensitive value, you probable already make sure you don’t store it in the...

azure, function, keyvault, security

Jun 28 2020

Business Intelligence

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

bi, database, edw, etl, integration services, security, SQLServer, ssis, ssisdb

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

analysis services, child, dimension, hierarchy, parent, parent child, server, sql, sql server, SQLServer, ssas

Jun 16 2020

Business Intelligence

SSAS : Locale Error while processing cube

by mattias

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

analysis services, cube, device attached, not functioning, processing, registry, sql, SQLServer, ssas