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.
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!!
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.
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.
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.
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.
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.
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.
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.
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...
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.
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.
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.
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
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....
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.
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...
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, ...