Why bi-projects fail?

So – I once organized an internal workshop for senior BI-consultants where we among other things discussed why BI-projects fails. Because – sometimes they do fail.

Azure SQL Database performance

I found these videos on how to tweak Azure SQL Database for performance really interesting.Should apply to on-premise version also, I’d imagine. Azure SQL for beginners – Special edition on performance Found on the Microsoft Developer channel:

Write back data to Power BI

Here is a neat guide for how you can add write back functionality to Power BI, so you can write comments or change data directly from a report.This can be done by integrating Power Apps with Power BI.

Check access to specific port on a server

When adding a new source system, often you have to open a firewall to that server in order to connect.The ping command will only show if that server is reachable, but not if a specific port is open. In order to test if a specific …

Read more

What SQL Server version do I have?

Here is a great script to see the version of the SQL server you are working on: This is how it looked on my home server that of cause is running Express Edition:

Google database services

Google offers a range of database services that are designed to meet the needs of a variety of applications and workloads. These services are provided through the Google Cloud Platform, which is a comprehensive cloud computing platform that offers a range of infrastructure, platform, and …

Read more


What is AWS from Amazon?

Amazon Web Services (AWS) is a comprehensive cloud computing platform provided by One of the key services offered by AWS is its database offerings, which include a variety of options for storing and managing data in the cloud. One of the main benefits of …

Read more

What is SSIS?

SQL Server Integration Services (SSIS) is a platform for building high performance data integration and workflow solutions. It is a component of the Microsoft SQL Server database software, and it allows users to design and deploy integration solutions for a wide range of data sources …

Read more

What is Azure Synapse

Azure Synapse is a cloud-based data warehouse platform from Microsoft that allows businesses to analyze large amounts of data quickly and easily. With Azure Synapse, you can collect, store, and analyze all the data you need to gain a deeper understanding of your customer behavior, …

Read more

Loading data into Azure

Prerequisites:Make sure you have Resource groups Make sure you have an Azure Account