As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data with Microsoft Power BI and Power Pivot for Excel by Marco Russo and Alberto Ferrari. The title is quite a mouthful but it gets the point across: the book mostly deals with how to correctly build […]
T-SQL Tuesday #100!
The monthly blog party is back and we’ve reached the mythical number 100. The host of this month is the Creator himself: Adam Machanic (blog | twitter). The topic is the future: what will the world be like when it’s T-SQL Tuesday #200? The very first T-SQL Tuesday was over eight years ago, which was […]
Excel Rendering In Power BI Report Server: You Are Not Licensed To Use This Feature
I recently migrated an SSRS 2017 instance to a Power BI Report Server environment, as you can read in the blog post Migrate SSRS 2017 to Power BI Report Server. After quite some issues, the PBI RS Portal worked and I could happily browse SSRS and Power BI Desktop reports. The last on the last […]
Migrate SSRS 2017 to Power BI Report Server
UPDATE: The blog post doesn’t make this exactly clear, but fiddling around with the report database to get the upgrade working isn’t supported by Microsoft. However, someone from the SSRS team told me the March 2018 release of Power BI Report Server has fixed some bugs, so you should try to upgrade the normal way. […]
Data Modeling for Self-Service BI @ Techorama 2018
I’m delighted to announce I’ll be giving a session about data modeling in a self-service BI environment at Techorama 2018 (the Internet is divided on the correct spelling: modelling or modeling. Apparently it depends on which side of the pond you’re on). Techorama is one of the biggest Microsoft-oriented tech events in Europe (it takes […]
T-SQL Tuesday #99 – Door #2
This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice to blog about a topic of our choice, either about a passion outside of the SQL Server community, or about a T-SQL bad habit. In this blog post, I’ll tackle the second option, but I […]
T-SQL Tuesday #99 – Door #1
This months T-SQL Tuesday is hosted by Aaron Bertrand and the topic is Dealer’s Choice. Aaron gives us the choice to blog about a topic of our choice, either about a passion outside of the SQL Server community, or about a T-SQL bad habit. In this blog post, I’ll tackle the first option, but I’ll […]
Session Materials – Biml DataMinds
All of the materials for my Biml session for DataMinds.be can be downloaded from Github: the slidedeck (it’s only 12MB :)) a .sql file with the DDL statements to create objects (schema, tables, views, stored procs, functions) in a database called Biml (which you have to create yourself). Along with some metadata in those tables. […]
DataMinds.be Meetup – Biml
First blog post of the year and I’d like to take the opportunity to wish everyone the best, professionally and otherwise. And what better way to start the new year with a user group session? On Thursday 25th of January 2018 I will be giving an evening session for dataminds.be, formerly known as SQLUG.be aka […]
Connect is dead! Long live feedback.azure.com!
After years of having to deal with Connect – the feedback platform of Microsoft – it is announced a successor has been found: feedback.azure.com. It’s not all about Azure, the link goes to the relevant portion of SQL Server. I’m glad for this change, as Connect could sometimes be a little … quirky. Especially the […]