Alexander Obregon's Substack

Weekly recaps of what I’ve published, plus updates, extras, and some exclusive content you won’t find on my Medium.

Launched a year ago

Sparse Columns in SQL Server

Large SQL Server tables can collect a long tail of optional attributes when the main entity stays the same, but different categories need different…

18 hrs ago•Alexander Obregon

Weekly Recap – June 21st, 2026

Spring Boot and SQL

Jun 21•Alexander Obregon

Batching and Queue Draining Logic in Spring Boot

Queue draining starts with a small decision that changes how a service writes data.

Jun 19•Alexander Obregon

Soft Deletes in SQL Tables

With soft deletes, a table keeps a row in place while normal application views treat it as removed.

Jun 18•Alexander Obregon

Dynamic Filters in SQL Queries

Search pages tend to grow past their first query faster than the SQL behind them can keep up.

Jun 17•Alexander Obregon

Bloom Filters for Fast Miss Checks in Spring Boot

Missing data can get expensive in a busy service because the same bad request can keep pulling the application through the same lookup flow.

Jun 16•Alexander Obregon

Pagination with the Seek Method in SQL

Large result sets show up in SQL-backed apps, and pagination keeps those rows in smaller chunks.

Jun 15•Alexander Obregon

Weekly Recap – June 14th, 2026

Spring Boot, SQL and Java

Jun 14•Alexander Obregon