I once heard someone say: if you use SSIS to do ETL, you are just not a good enough programmer in SQL. Needless to say I had some thoughts about that! We had a discussion about ETL and what tool is the most suited for that task. In the end it came down to the fact that
Continue reading...
During last Christmas' project (the Poor Man's IoT - read more about it here and here) I wanted to build a small Proof of Concept communicating my home freezer sensor to Azure IoT. However, if you're not a C# dev, the steps to set up this 'small' Proof of Concept can be quite daunting - especially if you're
Continue reading...
"Unable to establish server mode". *Blink* I admit I was a bit puzzled when this message showed up. I tried to connect to Analysis Services and this message came up. "Why would it be unable to detect the mode of the server? The Server is just fine and so is the mode in which it
Continue reading...
In this post - part of my 'creating non-ugly SSRS reports' series - I'll introduce you to a design and layout technique quite common in webdesign, but AFAIK not too often applied in reporting: using a column grid. Curious? Read on!
Continue reading...
"Is it ok to use a SQL Server database view from the source system as the source for your DWH, or is it better avoid views as a source, using only tables?".
Continue reading...
When training and coaching Microsoft Business Intelligence developers and analysts, people sometimes ask how to keep up with all the new stuff developing. Or, how to start building your knowledge inside your profession. Here are some thoughts about that.
Continue reading...
