Database Theory
- Database Theory: What is CAP theorem – Consistency, Availability, Partition
- SQL Server: The use of Semicolons is a good habit, Don’t forget it
- SQL Server: Must know – the Forwarded Records in HEAP Table
- Database News: Now Uber switched from PostgreSQL to MySQL
- Database Theory: What is difference between MySQL and PostgreSQL?
- Database Theory: What is Parallel Query Processing (Parallel Database System)?
- Database Theory: What is BRIN (Block Range Index), How is faster than BTREE Index
- A Day in the life of a DBA !
- Database Theory: Advice to DBA, Understand RTO and RPO before Database Maintenance
- Database Theory: Table Scan vs Index Scan vs Index Seek
- Database Theory: What is Optimistic Locking and Pessimistic Locking?
- Database Theory: What is Timeout, Lock, Block, and Deadlock in a Database System?
- Database Theory: The truth about Universally Unique Identifier – UUID
- SQL Server 2014: What is Hekaton?
- Database Theory: What is In-memory Database?
- Database Theory: What is a Data Masking ?
- Database Theory: What is Character Set and Collation
- Prepared or Parameterized Statements in Database System
- The Memory or Heap Storage Engine of MySQL
- What is heap Table
- MySQL Query Cache Part I/II
- What is Multi Version Concurrency Control (MVCC)
- ACID Properties in Database System (Atomicity, Consistency, Isolation, Durability)
