Blog

14 mrt 2019 Free download: How Big Data and AI can help your business move forward?

A while ago, our DAX Diviner at The Kingdom of Wizards, Ken Geeraerts, has been interviewed for a whitepaper on Big Data and AI for the company Nimbuz. Download a free copy of the whitepaper "How Big Data and AI can help your business move forward" here.

12 mrt 2019 The Chamber of SQL Part 4: What is a managed instance?

Stefanie was planning to update her knowledge on Microsoft Azure. After a good night rest, she was ready for this new adventure. She opened up her laptop, turned on the power and immediately stopped and stood up. First things first. Black gold. Now she was ready to learn about Managed Instance.

06 mrt 2019 SQL Server Plan Guides: A Walkthrough, Part 2

In the first part of this blog series on SQL Server plan guides, we looked into the basic plan guide setup. In this part we will be taking a closer look at somethings you cannot do as well, as how to add a plan guide to procedures, and how to find queries that are using plan guides.

18 feb 2019 The Kohera DNA and me

Working for Kohera is more than a day-to-day job. In fact, it’s a passion that started five years ago. Because it does not always have to be technical, I would like to give you some shop-floor insights and somehow reflect my five years of experience so far.

12 feb 2019 SQL Server Plan Guides: A Walkthrough Part 1

Plan guides are some strange things, and can be very high risk. This post does not have the intention to get all you fine people to implement plan guides everywhere, it should be one of the last resort options in your toolkit.

23 jan 2019 How To videos: Power BI and Python (part I & II)

Python is a great addition to the Power BI family by providing you the ability to perform quick data transformation or plot cool data visualizations. Our Power BI wizard Ken Faes gives you an introduction in setting up Python in Power BI...

14 jan 2019 Data Lake Security and Governance best practices

Data Lakes are the foundations of the new data platform, enabling companies to represent their data in an uniform and consumable way. In this document, we’ll describe how to setup a Data Lake in such a way that it will become the efficient Data Lake that users are looking for.

09 jan 2019 Power BI and Python: scraping De Tijdloze 100 website

As you might know, Python is now available as a preview feature in Power BI. I used it to complete the data in our Power BI dashboard of the radio show "The Tijdloze 100". The data was mostly coming from a web-page, but in the latest edition all data was not available for Power BI.

08 jan 2019 Update: De Tijdloze Power BI

Doe jij dat ook, op het einde van het jaar luisteren naar een top 100 of 1000? Bijna elke radiozender blikt terug met een muzieklijst van nummers van het voorbije jaar of telt af naar de grootse hit allertijden. Ondertussen hebben we ook de gegevens van de meest recente editie 2018 in ons Power BI rapport geladen.