Blog

30 Oct 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.

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 May 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 Mar 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 Mar 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 Mar 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.

07 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.

04 Jan 2019 Migrating Databases using Backup and Restore

In this blog post we will describe how to migrate a SQLServer Database between different SQL Instances using the Backup and Restore procedure. The main advantage from migrating databases this way that it is less error prone than other procedures

02 Jan 2019 Migrating to newer SQL Server versions

SQL Server 2017 is not that new anymore, but, as with each new release of SQL Server, most people are hesitating to start migrating to this new version for a variety of reasons. Let's have a look at why you shouldn't hesitate to migrate....

01 Jan 2019 Validate your SQL environment the easy way

Every DBA probably knows and should even be using DBAtools stuff. Lately Chrissy Lemaire and her team also added DBAchecks, a validation tool, to it. A separate powershell module , based mainly on pester checks.

21 Dec 2018 Scale out SRSS with failover on SQL standard edition

A few days ago, I set up my very first SQL Always On cluster. It would be a very straightforward task, just two databases in a 2 basic availability groups and making sure one fails over with the other. Besides that, the customer also asked some other stuff...

19 Dec 2018 Queries are running slower after migrating?

There's a solution for everything. If your queries are running slower after migrating, you can use the Query Store to force lower compatibility plans.The query store is a very easy way to track the queries happening in your database, ...