Blog

03 dec 2019 Creating a Secure Databricks Environment

Azure Databricks is a cloud native (Big) Data analytics service, offered as a managed PaaS environment. It’s designed to hide the underlying distributed systems and networking complexity as much as possible from the end user, so you can focus on developing rather than having to stress over infrastructure management.

18 nov 2019 Azure Synapse Analytics: Where Azure DWH, Spark & ADF meet

When I started to jump from DBA to Data Architect, I thought that these roles would diverge further and further until they became two separate roles and functions. The current evolution Microsoft launched proved me wrong though. Enter Azure Synapse Analytics.

30 okt 2019 Prevent lock escalation on indexed views

Recently our data wizard Thomas Costers was at a customer who created an indexed view, which spanned multiple tables as part of a release. Because you can't disable lock escalation for an indexed view as you can for a table, he went looking for another solution.

14 okt 2019 Onze key takeaways van dataMinds Connect 2019

Oktober 2019, de herfst is in het land, het weer is druilerig, ideaal voor 2 dagen DataMinds Connect! Onze data wizards Ludo Bernaerts en Simon De Meester, vertellen je wat ze vooral bijhouden van deze tweedaagse.

24 sep 2019 Wanneer je bij Kohera start….

Seriously, have fun .. and what great fun we had! In deze blogpost beschrijven we hoe we onze eerste week als gloednieuwe Koheriaanse groentjes hebben beleefd. En geloof ons, dit smaakt naar meer...

27 jun 2019 How To video: Visualise your Fitbit data in Power BI

In our latest How To video, our BI wizard Frederik Aerts, integrates the data of his Fitbit into Microsoft Power BI. There are different ways to do it... Enjoy!!

28 mei 2019 Power BI: How to unpivot twice

Recently I had a customer providing data for a Power BI report in a format that wasn't ideal for reporting purposes. We solved it by using a combination of pivoting and unpivoting columns. This blog post will show you how to do this.

30 apr 2019 Does Persisting sampling rate work on Databases with compatibility levels below 130?

When you create or update statistics (without specifying a sample rate) the sample rate is automatically calculated by SQL Server. If you would want this statistic (or the whole table) to use a Flat sample rate, say 5 percent, then you could specify a persisting sample rate after updating your stats. Read all about it in this 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.