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:https://www.youtube.com/@MicrosoftDeveloper/videos
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 …
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 …
What is AWS from Amazon?
Amazon Web Services (AWS) is a comprehensive cloud computing platform provided by Amazon.com. 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 …
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 …
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, …
Loading data into Azure
Prerequisites:Make sure you have Resource groups Make sure you have an Azure Account