Rui CarvalhoinArt of Data EngineeringHow Idempotent Data Pipelines Prevent Data Consistency IssuesDiscover the concept of idempotent data pipelines in maintaining data consistency in your database. Learn practical strategies to build…23h ago23h ago
Rui CarvalhoinLearning SQLChoosing Between CTEs, Subqueries, Views, and Temp Tables for Optimal PerformanceDiscover how to streamline your SQL queries for maximum efficiency. Learn the optimal use cases for CTEs, subqueries, views, and temporary…Jun 14Jun 14
Rui CarvalhoinThe Data TherapyExploring Slowly Changing Dimensions: A Comprehensive Guide to SCDDiscover the different types of Slowly Changing Dimensions (SCD) used in data warehousing. Learn how each SCD type manages data changes…Jun 14Jun 14
Rui CarvalhoinLearning SQLWhy You Should Avoid Using SELECT * in SQL: Uncovering the Hidden CostsExplore the pitfalls of using SELECT * in SQL queries and learn the best practices for optimizing your database management with targeted…Jun 6Jun 6
Rui CarvalhoinThe Data TherapyUnderstanding Data Staging in Microsoft Fabric Dataflows Gen2Discover how Dataflows Gen2 in Microsoft Fabric optimizes data handling with advanced staging mechanisms. Learn the benefits of efficient…May 24May 24
Rui CarvalhoinArt of Data EngineeringUnderstanding Reverse ETL to Increase Operational EffectivenessMay 16May 16
Rui CarvalhoinThe Data TherapyIntroducing Fast Copy: Speed Up Data Management with Fabric Dataflows Gen2Discover the new Fast Copy feature in Fabric Dataflows Gen2, designed to accelerate your data processing within Azure. Learn how Fast Copy…May 92May 92
Rui CarvalhoinTowards Data EngineeringOptimizing Data Serving: Insights into the Last Phase of Data EngineeringExplore the final stage of data engineering — serving data — in this guide. Learn about the challenges, best practices, and key uses of…May 4May 4
Rui CarvalhoinThe Data TherapyAccelerate Data Transfer with Microsoft Fabric’s Fast Copy in Data PipelinesDiscover how Microsoft Fabric’s Fast Copy feature revolutionizes data management. This guide walks you through a step-by-step process to…Apr 28Apr 28
Rui CarvalhoinThe Data TherapyUse Microsoft Fabric Database Mirroring to Centralize Your DataDiscover how Microsoft Fabric’s new Database Mirroring feature, is set to transform data management and analytics and learn how integration…Apr 8Apr 8