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