Parameter sniffing solved with new Parameter Sensitive Plan Optimization feature
If you’re someone that works a lot with Microsoft SQL Server, there’s no doubt that you’ve had issues with an issue called “Parameter sniffing” before. Up until now, you had to figure out a way around it. SQL Server 2022 solves this issue – almost completely – through a new feature called Parameter Sensitive Plan […]
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 are creative and have knowledge about the right programming language, you can let your imagination run free. I’ll talk about languages – specifically about R – in more detail later. One interesting application of those endless possibilities […]
Sending monitoring alerts through Telegram
What if you could get the ease of phone notifications for whatever monitoring alerts you need? Then we have a solution for you with the app Telegram. Some of you may be familiar with this messaging tool, that’s very similar to WhatsApp. Telegram focusses on speed and security, is easy to use and free. Setting […]
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 similar functionality in Azure SQL Database? There are options, but it requires a bit of tinkering. Tinkering that we gladly explain in this blog. The alternative So, you want to create something in Azure […]
Sorting matrices in Power BI
Recently I worked on a Power BI project for a client. They had a SharePoint site where they regularly published articles and wanted to pour view data into a report to track which pieces of content were performing well. One of their requests – sorting the matrices by different values – for the Power BI […]
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. For small amounts of data we could write a simple script that sends one request at a time. For […]
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. This approach keeps data and calculations in a more central repository which acts as a “Single Source of Truth”. But dividing sets and reports can result in a headache or two. Let our blog be your Power […]
Running Python scripts on Azure with Azure Container Instances
Contents 1. Requirements 2. Register a repository on Docker Hub 3. Create the first Azure resources 4. Building and testing the container locally 5. Creating the Azure resources for the Container Instance 6. Optional: Disable access via environment variables to key vault 7. Closing words & further reading Running Python scripts on Azure with […]
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. The data platform we developed for them ingested a source that was afterwards used by a business team and our client’s clients. For this particular source, our client asked us to send a simple email with […]
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. You can even expand your Power BI reports further by bringing in sophisticated machine learning and AI. Our Power BI wizard Nick Faes gives you an introduction in setting up […]
