Tutorials

Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature

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.

Read more

Creating maps with R and Power BI

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.

Read more

Sending monitoring alerts through Telegram

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!

Read more

Send mails with Azure Elastic Database Jobs

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.

Read more

Sorting matrices in Power BI

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.

Read more

Concurrent API requests with Python by example

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.

Read more

Avoid headaches when working with separate PBIX files in Power BI

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.

Read more

Running Python scripts on Azure with Azure Container Instances

Always wanted to run Python on Azure? We'll show you how with Azure Container Instances.

Read more

How to send emails with an SMTP server in Azure Databricks

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

Read more

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

Read more

How to create your own Power BI visual

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.

Read more

Create a date table in Power BI

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. 

Read more