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: 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
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
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 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
Dennes Torres in Blogs Cloud Connections in Microsoft Fabric I wrote about cloud connections when they were in a very early stage. Cloud connections evolved and are now sharable.... 09 October 2024 4 min read
Dennes Torres in Blogs Infinity Notebook Loop in Fabric using Data Activator Data Activator allow us to make an interesting workaround for infinity notebook executions. Infinity execution loop is interesting for constant... 20 September 2024 4 min read
Dennes Torres in Blogs Data Activator: The secrets of monitoring alerts Data Activator supports email and Teams alerts. These are good options when we would like to monitor some information and... 11 September 2024 2 min read
Dennes Torres Microsoft Fabric and PySpark: Coding tricks to improve your solutions PySpark has some unconventional syntaxes which provide power to the development process, making it easier. We talked about loops before. Let’s... 04 September 2024 4 min read
Dennes Torres in Blogs PySpark: The flexibility of a loop Pyspark has many flexible syntaxes which are not so common to other languages. One of these syntaxes is the loop... 15 August 2024 3 min read
Dennes Torres Microsoft Fabric: Using Lakehouse data in Real Time Dashboards Real-Time dashboards are a great feature in Real Time Intelligence experience to monitor our data. However, by default it’s made... 08 August 2024 2 min read
