Koen Verbeeck in General Analytics How to Load a Date Dimension in Microsoft Fabric using Macros in dbt? With the popular data transformation tool dbt (data build tool), we have a bunch of interesting features at our disposal... 23 April 2025 7 min read
Dennes Torres in Blogs Query Performance Analysis in Lakehouses You may have already discovered the 4 special views the lakehouse has in the queryinsights schema to track query performance.... 09 April 2025 4 min read
Dennes Torres in Blogs Fabric Database: Advanced Vector Search Features A few weeks ago, I delivered some sessions about vector search in Fabric Databases and Azure SQL. Let’s talk about... 02 April 2025 6 min read
Dennes Torres in Blogs Fabric: Query a SQL Endpoint from a Notebook Let’s analyse why we would like to query an SQL Endpoint. Once we understand why, we can dig into how... 26 March 2025 5 min read
Dennes Torres in Blogs How Shortcuts affect Lakehouse’s Maintenance I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided sample code about... 05 March 2025 3 min read
Dennes Torres in Blogs Fabric Databases Connection Secrets Fabric Database was a great announcement during Ignite Conference. The announcement spread all around, a great new feature. This feature... 19 February 2025 4 min read
Dennes Torres in Blogs Analysing Kusto Query Performance In Fabric We already discovered how to investigate Kusto query history. Let’s discover how to analyse query performance considering the information on... 06 February 2025 6 min read
Dennes Torres in Blogs SQL Endpoint Secrets you need to know Recently I had a severe problem with SQL endpoints and I was required to build a quick workaround for this.... 29 January 2025 5 min read
Koen Verbeeck in General Analytics Loading Models from Source Data with dbt The data transformation tool dbt (data build tool) has become more and more popular over the past years. It focuses... 20 January 2025 8 min read
Dennes Torres in Blogs Fabric Copy Job: What’s new in it At first sight, the new Copy Job may seem only one more redundancy: Why do we need this? We have... 15 January 2025 2 min read
Microsoft Fabric Dennes Torres in Microsoft Fabric High Concurrency Data Pipelines in Fabric Data Pipelines can orchestrate many activities, creating a flow for data ingestion. One of these activities is the notebook execution... 08 January 2025 2 min read
John Kerski in Data Science Comparing Groups for Similarities in Power Query – Using Cosine Similarity I’ll admit upfront—I am not a data scientist by trade. Instead, I’ve picked up my data science skills over time,... 17 December 2024 7 min read
Koen Verbeeck in General Analytics A gentle introduction to dbt In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract... 10 December 2024 12 min read
Dennes Torres in Microsoft Fabric Granting Permissions in a Fabric Data Warehouse and Lakehouse We are becoming used to being a bit lazy when granting permissions to Data Warehouses and lakehouses in Fabric. We... 04 December 2024 4 min read
Dennes Torres in Blogs KQL: The top of a group in an easy way When learning something new, we always compare it with what we know. In this case, we end up comparing KQL... 13 November 2024 3 min read
Dennes Torres in Blogs Analyzing Kusto Query History in Fabric We can consume a Kusto database in Fabric from many different places: Notebooks, semantic models, real time dashboards and more.... 07 November 2024 5 min read
Dennes Torres in Blogs T-SQL Notebooks: Manage Views Source Control and more T-SQL Notebooks is one of the new features announced during FabCon Europe. The most distracted could miss the fact this... 31 October 2024 3 min read
Dennes Torres in Blogs Shortcuts, Capacities and Costs : Some Considerations Edit on 25/10/2024: According to some official documentations, there is an inaccuracy on this blog. The costs involved on data... 23 October 2024 3 min read
Microsoft Fabric Dennes Torres in Microsoft Fabric Using a Service Account in Microsoft Fabric Applications should never depend on user accounts for their own authentication. User accounts have unique security configurations, such as MFA... 16 October 2024 4 min read
Koen Verbeeck in BI Quick Tricks to Make Your Power BI Model Smaller, More Efficient and Almost Certainly Faster Power BI has been a leading data visualization tool in the market for years. It can be used as a... 11 October 2024 13 min read
