Articles
Deep dives on .NET, React, cloud and everything in between.
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 · 21 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 · 31 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 · 25 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 · 23 views
Primary Key / Foreign Key 🔑 — Database Relationships
Primary Key uniquely identifies a row in a table. A Foreign Key creates a relationship between two tables by referencing a key in another table.
26 Sep 2026 · 31 views
Relational Database 🗄️ — Understanding SQL Databases
A Relational Database stores data in structured tables made up of rows and columns. Tables can be related to each other using keys.
26 Sep 2026 · 28 views
SQL vs NoSQL 🗄️ — Choosing the Right Database
SQL and NoSQL databases solve different data-storage requirements. In system design interviews, the important part is understanding their data model, consistency, scalability, and when to choose each one.
26 Sep 2026 · 24 views
Backpressure 🌊 — Handling More Work Than You Can Process
Backpressure is a mechanism used when a producer is generating work faster than a consumer can process it. Instead of allowing unlimited requests to accumulate, the system controls the incoming flow.
26 Sep 2026 · 25 views
Bulkhead Pattern 🧱 — Isolating Failures
The Bulkhead Pattern isolates resources used by different parts of a system so that a failure in one area does not consume all available resources and bring down the entire application.
26 Sep 2026 · 21 views