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.