Importance of transaction log in SQL Server
Transaction logs are a vital and important component of database architecture. In this article,...
Fixing Data Loss Using Log Shipping with Delayed Recovery
Introduction Transaction Log Shipping is a very well-known technology used in SQL Server to maintain a copy of the live database in the...
Understanding Transactions in SQL
A transaction in SQL is a unit of execution that groups one or more tasks together. A transaction is considered successful if all the tasks...
The Lost Update Problem in Concurrent Transactions
The lost update problem occurs when 2 concurrent transactions try to read and update the same data....
SQL Server Transaction Log — Part 2
This is the second article in the series dedicated to SQL Server transaction log and its specificities. Here we are going to examine the...
SQL Server Transaction Log — Part 1
Every SQL Server database contains one or more transaction log files in addition to data files. Log files record all transactions and...
