One of the cool new features of SQL 2016 or SQL Azure is that you can add row level security to your database directly. So you don't need to use a cube or a tabular model to implement row level security. Let me show you how you can use it. The example is based on
Continue reading...
Just recently I was writing a very complicated query. Took me 2 hours to write. In the end I saved it as a view in the development database. I did not yet synchronize it back to the solution in visual studio, because I wanted to add a few related views for the problem I was
Continue reading...
The idea of organizational Business Intelligence was to create "One version of the truth, One Ring version to rule them all" errrr, well that was the idea. Away with all those Excels and bring on the conformed BI reports right? Of course it is a great idea to make sure you have a data warehouse where your data
Continue reading...