Rafael Rampineli – Medium

Rafael Rampineli

Building a Data Pipeline with Delta Lake, Spark, and Databricks

Delta Lake is an open-source storage layer that brings ACID (Atomicity, Consistency, Isolation, Durability) transactions and scalable…

Jan 17

Building a Data Pipeline with Delta Lake, Spark, and Databricks

Jan 17

Understanding Parquet, Apache ORC, and Avro: Key Differences for Big Data

What big Data format shoul you use?…Choosing the right data format can have a huge impact on performance, storage efficiency, and overall…

Jan 7

Understanding Parquet, Apache ORC, and Avro: Key Differences for Big Data

Jan 7

Snowflake Streaming: Loading from AWS S3 using SnowPipe with Change Data Capture (CDC) to DW

The landscape of data management has drastically changed over the past few decades, shifting from traditional on-premise systems to…

Jan 4

Snowflake Streaming: Loading from AWS S3 using SnowPipe with Change Data Capture (CDC) to DW

Jan 4

Comparing Data Warehouses: Redshift, BigQuery, and Snowflake

Data warehouses have become essential for organizations to manage and analyze large volumes of structured and semi-structured data. Among…

Dec 27, 2024

Comparing Data Warehouses: Redshift, BigQuery, and Snowflake

Dec 27, 2024

Snowflake Overview: Time travel, Tasks, Fail-safe, Streams, and Command Copy

Snowflake is a powerful data warehouse platform known for its scalability, elasticity, and ability to process large datasets efficiently…

Dec 27, 2024

Snowflake Overview: Time travel, Tasks, Fail-safe, Streams, and Command Copy

Dec 27, 2024

Understanding Google BigQuery: Tables, Caching, Partitioning, and Clustering

Google BigQuery is a fully managed, serverless, and highly scalable data warehouse that allows businesses to run SQL-like queries on…

Dec 21, 2024

Understanding Google BigQuery: Tables, Caching, Partitioning, and Clustering

Dec 21, 2024

Amazon RedShift — Fast query performance, scalability, and integrations

Amazon Redshift is a cloud-based data warehousing service provided by Amazon Web Services (AWS). It is designed to handle and analyze…

Dec 17, 2024

Amazon RedShift — Fast query performance, scalability, and integrations

Dec 17, 2024

Optimizing SQL Server: Understanding Parallelism in Execution Plan

This article provides an overview of interpreting parallel execution plans in SQL Server.

Dec 16, 2024

Optimizing SQL Server: Understanding Parallelism in Execution Plan

Dec 16, 2024

Optimizing SQL Server: Understanding the much-feared spool operators

In the world of SQL Server, the Spool Operator is often regarded with a mix of fear and confusion by many. It’s one of those elements that…

Dec 11, 2024

Optimizing SQL Server: Understanding the much-feared spool operators

Dec 11, 2024

Optimizing SQL Server: Understanding Nested Loops, Hash Match, Merge Join, and Adaptive Join

In most database systems, join operations are essential for combining data from multiple tables. SQL Server, as a relational database…

Dec 6, 2024

Optimizing SQL Server: Understanding Nested Loops, Hash Match, Merge Join, and Adaptive Join

Dec 6, 2024

Rafael Rampineli

Rafael Rampineli

I specialize in managing and optimizing complex database environments to ensure high availability, performance, and data integrity.

Following

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