Roleplaying Dimensions and SSAS Multidimensional
Yes, I can hear you, SSAS Multidimensional is so old and unsexy. Still, a lot of the data warehouse projects I work on still use this techonology. So what is a roleplaying dimension? It’s quite simply a dimension, that plays different roles in regard to…
Hunting date errors
Just recently, I had to find out, why a dataload, that had been working smoothlessly in the past, suddenly prodced an error. The data is coming from an ORACLE database, and imported into MS SQL Server with an OPENQUERY statement. The error message read: “Error…
SQL Server Graph Database and Performance
When Microsoft announced, that their upcoming release would contain an implementation of Graph Database objects, I was intrigued. There are already a couple of good posts around, that explain how to use the feature, e.g. how to create a table structure and query the information,…