Tag: DB

All the articles with the tag "DB".

• 
  Sep 7, 2024

  【System Design】 CQRS (Command Query Responsibility Segregation)

  A walkthrough of CQRS — splitting commands (writes) from queries (reads) — compared with ordinary replication

  #Backend#System design#DB
• 
  Jan 14, 2024

  Transaction isolation levels

  Walks through the four transaction isolation levels in MySQL, plus dirty reads, non-repeatable reads, and phantom reads

  #Backend#DB
• 
  Jul 29, 2022

  [Book review] Notes on A Thorough Guide to Database Design

  Notes and the parts I found important after reading A Thorough Guide to Database Design.

  #Backend#DB#SQL Server#Books
• 
  Jul 16, 2022

  SQL Server indexes and execution plans

  Covers SQL Server index characteristics, how to read execution plans, and the basics you need for performance tuning

  #Backend#DB#Books#SQL Server
• 
  Jul 14, 2022

  [SQL Server] What mattered when we tuned batch performance

  What I learned while improving the performance of a production batch job.

  #Backend#DB#SQL Server
• 
  Jun 10, 2022

  【SQL Server】 Bulk-import large datasets with the BCP command

  A walkthrough of BCP, the command-line tool for loading large amounts of data into SQL Server.

  #Backend#DB#SQL Server