Tag: sql

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

Jun 14 2020

Business Intelligence

SQLServer : disable inactive logins

by mattias

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

administration, datawarehouse, db, dba, disable, history, login, logon, sql, sqlagent, SQLServer, table, trigger, tsql

Jun 03 2020

Azure, Business Intelligence

Azure SQL DB: setup AD Authentication

by mattias

No Comments

Follow below steps to allow Azure AD users and groups to connect to your Azure SQL database: create a User in Azure AD optionally: create a Group in Azure AD...

active directory, ad, authentication, azure, db, external provider, group, sql, user

May 12 2020

Business Intelligence

Expressions on ConnectionString issue in SSIS 2019

by mattias

11 Comments

In SQLServer Integration Services, the use of Expressions to replace properties at runtime is very powerful. You can use it in combination with variables to pass parameters to queries, determine...

database, datawarehouse, etl, sql, SQLServer, ssis