Tag: Backend
All the articles with the tag "Backend".
【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
Transaction isolation levels
Walks through the four transaction isolation levels in MySQL, plus dirty reads, non-repeatable reads, and phantom reads
#Backend#DB
[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
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
[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
【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
【Oracle Java Gold】 How I passed the hardest Java cert
How I studied for Oracle Java Gold, the hardest Java cert, and a cheaper way to sit the exam.
#Backend#Java#Books#Udemy#Oracle