Articles
Deep dives on .NET, React, cloud and everything in between.
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 · 28 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
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
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 · 32 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 · 29 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 · 25 views