10 aug 2022 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.

30 jun 2022 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.

17 mei 2022 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!

24 mrt 2022 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.

24 feb 2022 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.

27 jan 2022 The world of data is evolving

The data landscape has changed dramatically over recent years. Is cloud-only still the credo? And what about Big Data? In this article, we explore the data trends for the coming year.

16 dec 2021 Bringing Python to Azure Data Factory with Azure Batch Service

In most cases programming is not needed when working with Azure Data Factory. In the rare situations where it is necessary, Python and Azure Batch Service are a viable option. Let's do a deep-dive!

24 nov 2021 Why use SSAS Tabular when we have Power BI?

Managers, analysts, engineers and information workers, who use it, know that SQL Server Analysis Services Tabular (SSAS Tabular) is a valuable ICT asset. On the other hand, Power BI (PBI) is a great tool too that has a bit more functionality under its belt. Yet, there’s cases where SSAS Tabular might prove useful which we’ll detail in this blog.

21 okt 2021 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.

31 aug 2021 SQL Server Reporting Services 2019: what has changed compared to earlier versions?

When trying to do a standard install of SQL Server, you may have noticed that the 2017 or newer versions of SQL Server Reporting Services (SSRS) aren’t installed as well. That’s because SSRS now has its own separate installer. In this blog, we’ll show some of the changes compared to older versions.

01 jul 2021 Import text by example in Power BI reports

Weirdly formatted files, we’ve all had to import them into our reports at some point. Luckily, Power BI has new option that might make our lives easier: import text/CSV by example. We’ll show you how to use it in this blog.

15 jun 2021 The Databricks lifecycle and how it impacts your maintenance

There's plenty of updates to Databricks. And that sometimes leaves users frazzled. his begs the questions, why are there updates so often? And what is the impact on maintenance of your dearest Databricks-projects?

05 mei 2021 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.

25 feb 2021 Niets beter dan Power BI: de Coca-Cola van de BI volgens Gartner

Al zolang Kohera bestaat, staat Microsoft als leider in de rechterbovenhoek van Gartner’s Magic Quadrant voor Analytics en BI Platformen. Net daarom hebben we bij Kohera een bewuste keuze gemaakt voor Microsoft Power BI. Het is zowaar de cola van de BI-tools.

15 feb 2021 De Tijdloze 2020: follow-up

Op 31 december zaten we met enkele Koherianen opnieuw gekluisterd aan onze radio. Zouden we erin geslaagd zijn het voorspellingsmodel zodanig aan te passen dat we De Tijdloze Top 100 van Studio Brussel juist hadden?

08 feb 2021 Defining your Azure infrastructure as code with Bicep

Azure Resource Manager templates are great. Managing the resulting JSON files not so much. So Microsoft launched Azure Bicep. Read how it will help with maintaining your infrastructure as code.

13 jan 2021 Small Multiples: a new smart feature in Power BI

Recently, a long-awaited feature was added to Power BI: Small Multiples. Time to explore our new options of visualizing data!

27 dec 2020 De Tijdloze van StuBru: Kohera’s voorspelling voor 2020

Deze eindejaarsperiode is er een waarbij heel wat tradities gesneuveld zijn. Gezellig samenzijn met de hele familie of lekker gaan eten op restaurant zitten er niet in dit jaar. Gelukkig zijn er ook nog zekerheden, zoals De Tijdloze van StuBru, die ook dit jaar voor muzikaal vertier zorgt in de laatste dagen van het jaar. En daarbij hoort natuurlijk ook onze voorspelling.