Medium

Rafael Rampineli

Rafael Rampineli

·

Oct 13

The Delta Lake transaction log through the eyes of a SQL Server DBA

Why start with the log

The Delta Lake transaction log through the eyes of a SQL Server DBA

Rafael Rampineli

·

Aug 17

Merge Replication: When the Head Blocker Is SQL Server Itself

Generation leveling, Merge Agent profiles, and why a 300-second -QueryTimeout is a trap

Merge Replication: When the Head Blocker Is SQL Server Itself

Rafael Rampineli

·

Aug 4

The Layer Below Latches: Diagnosing Spinlock Contention in SQL Server

Why your server burns CPU at 95% with no wait stats to blame and how to prove it.

The Layer Below Latches: Diagnosing Spinlock Contention in SQL Server

Rafael Rampineli

·

Jun 29

Always On in Azure: When the Listener Dies After Failover and ProbePort Is the Cause

There is a type of incident in Always On environments hosted on Azure VMs that is very good at fooling the person who investigates it. The…

Rafael Rampineli

·

May 28

Granular Auditing with SQL Server Audit and Extended Events: far beyond simply “enabling the…

Unauthorized access to sensitive data was detected weeks after it happened. The only evidence available was a generic Windows log showing…

Granular Auditing with SQL Server Audit and Extended Events: far beyond simply “enabling the…

Rafael Rampineli

·

Mar 16

Testing Index Performance Without Creating It: Hypothetical Indexes in SQL Server

When tuning SQL Server queries, one of the most common solutions is to create a new index. A well-designed index can dramatically reduce…

Testing Index Performance Without Creating It: Hypothetical Indexes in SQL Server

Rafael Rampineli

·

Jan 21

Enforcing Data Uniqueness with HASH in SQL Server

Ensuring data uniqueness is a fundamental requirement in enterprise systems. The most common approach — enforcing UNIQUE constraints…

Enforcing Data Uniqueness with HASH in SQL Server

Rafael Rampineli

·

Jan 15

Real-World Case: Managing LOB Data at Scale in SQL Server: From Filegroups to Partitioning

LOB data rarely causes problems on day one. The real damage happens quietly, over years, until storage, backups, and maintenance collapse…

Real-World Case: Managing LOB Data at Scale in SQL Server: From Filegroups to Partitioning

Rafael Rampineli

·

Jan 7

Real-World Case: Using SQL Server Filegroups to Control Disk Growth and Improve Performance

Recently I was brought into a SQL Server production environment that supported a high (really high)-volume transactional system. Nothing…

Real-World Case: Using SQL Server Filegroups to Control Disk Growth and Improve Performance

Rafael Rampineli

·

Dec 12, 2025

Understanding IO Latency and the Role of Resource Governor Metrics in SQL Server and Azure SQL

When you troubleshoot performance bottlenecks in SQL Server or Azure SQL, one of the first suspects is I/O latency. Queries slow down…

Understanding IO Latency and the Role of Resource Governor Metrics in SQL Server and Azure SQL

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

Store

Privacy

Rules

Terms

Text to speech