Databases Notes
Serializable vs Repeatable Read
October 04, 2026
EN
Imagine two requests hit an application at almost exactly the same time...
Identity Authentication and Access Control
October 04, 2026
EN
Database security starts with answering three different questions...
Sql Injection
October 04, 2026
EN
SQL injection occurs when untrusted input changes the structure of a SQL statement...
Synchronous vs Asynchronous Replication
October 04, 2026
EN
The fundamental difference between synchronous and asynchronous replication is...
Clustered Indexes Heap Tables and Row Locality
October 02, 2026
EN
A table's primary key does not imply one universal physical layout...
Benchmarking Load Testing and Capacity
October 01, 2026
EN
A performance claim without a workload definition is incomplete...
Database Hardening and Patch Management
October 01, 2026
EN
Hardening reduces the number of ways a database can be attacked or accidentally misused...
Incident Response and Disaster Recovery Drills
October 01, 2026
EN
A security or reliability incident is the wrong time to discover that...
Encryption Secrets and Key Management
October 01, 2026
EN
Database security depends on protecting data in several different states...