Articles
Deep dives on .NET, React, cloud and everything in between.
Connection Pooling
Every time an application needs to communicate with a database or another service, creating a new connection has a cost.
26 Sep 2026 · 23 views
Optimistic vs Pessimistic Locking
When multiple users try to update the same database record at the same time, we need a way to prevent incorrect updates.
26 Sep 2026 · 22 views
Deadlocks
A deadlock occurs when two or more transactions are waiting for each other to release resources, and none of them can continue.
26 Sep 2026 · 21 views
Isolation Levels
When multiple users update the database at the same time, transactions can interfere with each other. Isolation Levels define how much one transaction is isolated from changes made by another transaction.
26 Sep 2026 · 24 views
ACID 🧱 — The Foundation of Reliable Transactions
ACID describes four important properties of database transactions: Atomicity, Consistency, Isolation, and Durability.
26 Sep 2026 · 27 views
Transactions 💳 — Keeping Database Operations Consistent
A transaction is a group of database operations treated as a single unit of work. Either all required operations succeed, or the transaction is rolled back.
26 Sep 2026 · 22 views
Query Optimization 🚀 — Making SQL Queries Faster
Query optimization is the process of improving a database query so that it returns the required result efficiently while using less CPU, memory, I/O, and database resources.
26 Sep 2026 · 32 views
Composite Index 🔗 — Indexing Multiple Columns
A Composite Index is an index created using two or more columns. It is useful when queries frequently filter or sort using a combination of columns.
26 Sep 2026 · 26 views
Indexing 🚀 — Making Database Queries Faster
A database index is a data structure that helps the database find rows faster without scanning the entire table.
26 Sep 2026 · 24 views