SQL Performance Explained by Markus Winand
Here, I have listed some interesting concepts from the book.
Shreyansh's blog
Latest articles
Strong migrations in Ruby on Rails
Gems in Ruby on Rails to facilitate Strong Migrations.
ACID transactions in databases
Understand ACID transactions in context of databases.
gh-ost - an Online Schema Change tool
Let's take a look at github/gh-ost, an Online Schema Change (OSC) tool.
Replication formats in databases
Understanding the different replication formats in databases.
Strong migrations
Understanding strong migrations while working on applications with large databases.
Multiple granularities of database locks
Understand the multiple granularities of database locks