As I gear up for our twoday kapacity seminar in Aalborg today, I’m thrilled to share some insights from my collaborative work with Klaus Guldberg Ulsøe. Together, we’ve compared the tried-and-true Classic SQL Cloud Data… Read More »Classic SQL Cloud Platform vs. Data Lakehouse in Microsoft Fabric
I come from a background in Business Intelligence and Data Warehousing on SQL Server and Azure SQL DB. In the past year, I’ve had many discussions and fielded numerous questions during courses, conferences, and conversations… Read More »Demystifying the Data Lakehouse in Microsoft Fabric
When it comes to harnessing the power of data in the ever-evolving landscape of technology, understanding the architecture and dataflow in a Data Lakehouse-based solution is crucial. In this video and blog post, we’ll explore… Read More »Fabric Data Lakehouse: Understanding the Dataflow
For numerous years, the foundation of our Data Warehouse architectures has revolved around the traditional ETL dataflow process, consisting of the following stages: In this process, data is initially extracted from diverse sources in its… Read More »The dataflow evolution: From ETL to ISPS
One of the important tasks as a Power BI administrator is to ensure compliance and auditing requirements of shared reports. The Scanner API and the activity log can give us many really good insights, but… Read More »Widely shared Power BI reports
A long wish have come true. It’s now possible to query the Admin APIs and get a list of all the tenant settings. This is very valuable to be able to document the settings and… Read More »Extract and query the tenant settings
There has been a lot of hype around the newly announced Microsoft Fabric – the marketing machine surely did a very good job! But what if we take a look behind? Is this really as… Read More »Is Microsoft Fabric just old wine in new bottles?
When doing training and sessions on conferences, it’s very important to beware who the primary audience is. Maybe only who specific role or multiple roles? Here is the 8 roles, that we have come up… Read More »Power BI roles
Microsoft just announced that the Power BI admin Scanner API (WorkspaceInfo) will now include even more valuable metadata such as scheduled refresh settings and RLS configuration. The Scanner API is where you can get a… Read More »Extension to the Scanner API
I had the question come up a couple of times. Why should I attend the SQLBits conference – what are the things I should say to my boss, so she would let me go? And… Read More »Why do I attend SQLBits?