Rui CarvalhoinArt of Data EngineeringData Architecture Principles Every Data Engineer Should KnowDiscover the key principles of data architecture critical for any data engineer.3d ago3d ago
Rui CarvalhoinTowards Data EngineeringWhat You Need to Know About Data Management as a Data EngineerExplore data management as a data engineer. Discover essential best practices and strategic approaches to data governance, quality, and…Jul 5Jul 5
Rui CarvalhoinThe Data TherapyHow you can Score 95% plus on the DP-600 Fabric Analytics Engineer Associate Microsoft…After spending so much time using Microsoft Fabric since it was in preview, I finally managed to achieve this certification.Jun 30Jun 30
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…Jun 28Jun 28
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