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 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 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
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
Blogs Dennes Torres in Blogs Microsoft Fabric: Differences Between %Run and Notebook.Run When developing notebooks in Microsoft Fabric, we have two different methods to call one notebook from another: %Run and MSSparkUtils.notebook.run... 31 July 2024 2 min read
Blogs Dennes Torres in Blogs Microsoft Fabric: Ingesting from API’s and the JSON result Ingesting from API’s is a common task to build a Data Intelligence repository. When making this ingestion in a Fabric... 12 June 2024 7 min read
Koen Verbeeck in BI Choosing Between the Lakehouse and Warehouse in Microsoft Fabric Microsoft Fabric is a new centralized, AI-powered cloud data platform hosted by Microsoft. It combines several services of the existing... 10 June 2024 20 min read
Blogs Dennes Torres in Blogs Dynamic Partitioning and a Simple Incremental Load Let’s consider a simple statement for partitioning and save a table in a lakehouse: df.write.mode("overwrite").format("delta").partitionBy("Year","Month","Day").save("Tables/" + table_name) Let’s consider we... 03 April 2024 2 min read
Blogs Dennes Torres in Blogs Creating a Single JSON File for Configuration using Notebooks On the blog Fabric Notebook and Deployment Pipelines I explained a technique to keep notebooks configuration values in JSON files... 27 March 2024 2 min read
Blogs Dennes Torres in Blogs 5 Secrets about Dataflows Gen 2 Dataflows Gen 2 are the new version of Power BI dataflows. There are so many changes in relation to the... 13 March 2024 5 min read
Blogs Dennes Torres in Blogs Semantic Model: More than a Simple Name Change The animation on the top of this article tries to track the evolution of the enterprise architecture since SQL Server... 10 January 2024 3 min read
Blogs Dennes Torres in Blogs Microsoft Fabric: Using VS Code to Develop Notebooks The possibility to use Visual Studio Code (or VS Code) to develop your Microsoft Fabric notebooks seems very interesting. It... 15 November 2023 9 min read
BI Dennes Torres in BI SQL Endpoints and Lakehouse UI Differences and Access Secrets There are some differences and secrets between the UI of a SQL Endpoint and the UI of a Lakehouse. I... 30 October 2023 7 min read
Blogs Dennes Torres in Blogs Fabric: My Content compilation Microsoft Fabric was first announced during Microsoft BUILD. Since then, I’m publishing content about Microsoft Fabric, creating an interesting sequence... 04 October 2023 3 min read
Blogs Dennes Torres in Blogs Microsoft Fabric and the Delta Tables Secrets Microsoft Fabric storage uses OneLake and Delta Tables, the core storage of all Fabric objects, as explained in my introduction... 27 September 2023 10 min read
Dennes Torres Microsoft Fabric: Checking and Fixing Tables V-Order Optimization Download the notebook used on this blog I explained in a previous article how the Tables in a lakehouse are... 20 September 2023 5 min read
Dennes Torres Microsoft Fabric: using Notebooks and Table Partitioning to Convert Files to Tables When Microsoft Fabric was born, the only method to convert files to tables was using notebooks. Nowadays we have an... 13 September 2023 5 min read
Blogs Dennes Torres in Blogs Microsoft Fabric: Loading On-Premises and External Data Loading On-Premises and external data is a fundamental need for a Data Platform such as Microsoft Fabric. However, during this... 28 August 2023 9 min read
Blogs Dennes Torres in Blogs Fabric Lakehouse: Convert to Table feature and Workspace Level Spark Configuration I have been working as a no-code data engineer: Focused on Data Factory ETL and visual tools. In fact, I... 21 August 2023 2 min read
