Rui Carvalho – Medium

Rui Carvalho

Rui Carvalho
in
Learning SQL

Choosing Between CTEs, Subqueries, Views, and Temp Tables for Optimal Performance

Discover how to streamline your SQL queries for maximum efficiency. Learn the optimal use cases for CTEs, subqueries, views, and temporary…

Jun 14

Choosing Between CTEs, Subqueries, Views, and Temp Tables for Optimal Performance

Jun 14

Rui Carvalho
in
The Data Therapy

Exploring Slowly Changing Dimensions: A Comprehensive Guide to SCD

Discover the different types of Slowly Changing Dimensions (SCD) used in data warehousing. Learn how each SCD type manages data changes…

Jun 14

Exploring Slowly Changing Dimensions: A Comprehensive Guide to SCD

Jun 14

Rui Carvalho
in
Learning SQL

Why You Should Avoid Using SELECT * in SQL: Uncovering the Hidden Costs

Explore the pitfalls of using SELECT * in SQL queries and learn the best practices for optimizing your database management with targeted…

Jun 6

Why You Should Avoid Using SELECT * in SQL: Uncovering the Hidden Costs

Jun 6

Rui Carvalho
in
The Data Therapy

Understanding Data Staging in Microsoft Fabric Dataflows Gen2

Discover how Dataflows Gen2 in Microsoft Fabric optimizes data handling with advanced staging mechanisms. Learn the benefits of efficient…

May 24

Understanding Data Staging in Microsoft Fabric Dataflows Gen2

May 24

Rui Carvalho
in
Art of Data Engineering

Understanding Reverse ETL to Increase Operational Effectiveness

May 16

Understanding Reverse ETL to Increase Operational Effectiveness

May 16

Rui Carvalho
in
The Data Therapy

Introducing Fast Copy: Speed Up Data Management with Fabric Dataflows Gen2

Discover the new Fast Copy feature in Fabric Dataflows Gen2, designed to accelerate your data processing within Azure. Learn how Fast Copy…

May 9

Introducing Fast Copy: Speed Up Data Management with Fabric Dataflows Gen2

May 9

Rui Carvalho
in
Towards Data Engineering

Optimizing Data Serving: Insights into the Last Phase of Data Engineering

Explore the final stage of data engineering — serving data — in this guide. Learn about the challenges, best practices, and key uses of…

May 4

Optimizing Data Serving: Insights into the Last Phase of Data Engineering

May 4

Rui Carvalho
in
The Data Therapy

Accelerate Data Transfer with Microsoft Fabric’s Fast Copy in Data Pipelines

Discover how Microsoft Fabric’s Fast Copy feature revolutionizes data management. This guide walks you through a step-by-step process to…

Apr 28

Accelerate Data Transfer with Microsoft Fabric’s Fast Copy in Data Pipelines

Apr 28

Rui Carvalho
in
The Data Therapy

Use Microsoft Fabric Database Mirroring to Centralize Your Data

Discover how Microsoft Fabric’s new Database Mirroring feature, is set to transform data management and analytics and learn how integration…

Apr 8

Use Microsoft Fabric Database Mirroring to Centralize Your Data

Apr 8

Rui Carvalho
in
Art of Data Engineering

Mastering Data Transformation: Essential Insights for Data Engineers

Dive into the critical role of data transformation in the data engineering process. Explore the challenges, strategies, and best practices…

Mar 18

Mastering Data Transformation: Essential Insights for Data Engineers

Mar 18

Rui Carvalho

Rui Carvalho

Data Enthusiast | Time Management and Productivity | Book Lover | One of my passions is to teach what´ve learned | Storys every week.

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams