Prevent lock escalation on indexed views
Recently I was at a customer who had created an indexed view which spanned multiple tables as part of a release. Although the index was already created, it wasn’t being used by the application yet.
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! Traditiegetrouw waren we deze editie weer met het voltallige Kohera team aanwezig. Ludo Bernaerts, ervaren data wizard en Simon De Meester, vers van de pers data wizard sinds 1 maand, vertellen je wat ze zoal opstaken van deze tweedaagse.
Wanneer je bij Kohera start…
Seriously, have fun .. and what great fun we had! Een kleine greep uit onze eerste week als gloednieuwe Koheriaanse groentjes; veel eten (hamburgers), koffie, rijden (file), opleidingen en ontsnappen uit de jungle of deep space, dat kan tellen als eerste week!
How To video: Visualise your Fitbit data in Power BI
In this video, our BI wizard Frederik Aerts, integrates the data of his Fitbit into Microsoft Power BI. When using the template, you need to provide the full path of 3 example files (steps/calories/resting heart rate) and also the main folder path:
Power BI: How to unpivot twice
Recently I had a customer providing data for a PowerBI report in the below format. We have procedures containing several tests and for each test a result and target value. As you might notice, the format of the data provided is not ideal for reporting purposes. Creating visuals based on data in this format is not easy (try it!). You would have to write a measure for each test and if an additional test is added to a procedure the setup, as is, is not workable.
Does Persisting sampling rate work on Databases with compatibility levels below 130?
Short answer: Yes, it does. Long answer: What is persisting sampling rate and why does it exist? When you create or update statistics (without specifying a sample rate) the sample rate is automatically calculated by SQL Server.
Managed Instance (in combination with SSIS Integration Runtime) a first POC story
First of all, this article is based on a personal experience and is a snapshot in time. All comments made are based on the experience and what was available at time of writing. We have a client who wants to get rid of its ‘On Prem’ infrastructure and wants to push everything into the Azure Cloud environment, not having to think about maintenance/patching/high availability and so on. You may have noticed that On Prem is written between quotes? The answer why is that the server(s) are already in Azure, but in a IaaS model and is a intermediary step to go into a full blow (Azure) Cloud environment.
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. The witepaper shows you how to make your company future proof, by letting data and analytics work for you. So you can understand your customers and market better, and push your business and workforce forward. To quote our wizard Ken: “You first have to make sure that the data is stored in the best possible way and then made available centrally. Then you look for ways to convert that data into a policy instrument; that helps you make targeted and strategic decisions.”
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
SQL Server Plan Guides: A Walkthrough, Part 2
In the first part of this blog series, we looked into the basic plan guide setup, the fact that hints already on the queries will be overwritten by the plan guide and some other intricacies.
