Jun 22 2020
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
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
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
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...
powershell Master Data Services devops session optimize trigger etl ssas upgrade maximum notification azure os ssis scripting dax tsal database datawarehouse portnumber business rules rdp analysis services windows flow db portal mappings SQLServer port function PowerBI email sql queue vm administration json .net server navision powerautomate automation compute usage