If you work a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with “Parameter sniffing”. SQL Server 2022 solves this issue – almost completely – through a new feature called Parameter Sensitive Plan Optimization.
If you work a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with “Parameter sniffing”. SQL Server 2022 solves this issue – almost completely – through a new feature called Parameter Sensitive Plan Optimization.
The possibilities are infinite when it comes to creating custom visuals in Power BI. As long as you have creativity and knowledge about the right programming language, you can let your imagination run free.
What if you could get the ease of phone notifications for whatever monitoring alerts you need? We show you how to integrate Telegram in your PowerShell scripts to do just that!
The DatabaseMail feature in SQL Server and Managed Instance is widely used by many professionals. But what if you want a similar functionality in Azure SQL Database? There are options, but it requires a bit of tinkering. Tinkering that we gladly explain in this blog.
A client asked to track which content on SharePoint was performing well. One of their requests – sorting the matrices by different values – for the Power BI report turned out to be as tricky to implement, as it seemed straightforward when I first heard it. A rare occurrence! Let’s explore the solution to this conundrum.
APIs are one of the things we often come across when working with data. In this blogpost we’ll have a look at some ways of extracting data out of them with Python in an efficient way.
Splitting datasets and reports into separate PBIX files is a very common way of managing Power BI reports. But dividing sets and reports can result in a headache or two. Let our blog be your Power BI painkiller.
Always wanted to run Python on Azure? We'll show you how with Azure Container Instances.
A client asked if we could provide a simple form of monitoring on a part of a provided solution. For this particular source, our client asked us to send a simple email with record counts to a mailing list. No problem! Let's get to work
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...
In this video our Senior BI Consultant Frederik Aerts is discussing how to start with the creation of your own custom Power BI visual. You can choose from a wide range of default visuals, but you can also create them yourself.
One of our most-read blogpost of all times without a doubt is the one in which Frederik Vandeputte explains how you can create a Power BI date table in just two steps. To make it even easier for you, we made a step-by-step video to build your own date table in just a few minutes.