Automatic Deletion of Forgotten Transactions in MS SQL Server
Introduction It is often the case when an MS SQL Server transaction is being forgotten by the...
Importance of transaction log in SQL Server
Transaction logs are a vital and important component of database architecture. In this article, we’ll discuss SQL Server transaction...
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...
The Lost Update Problem in Concurrent Transactions
The lost update problem occurs when 2 concurrent transactions try to read and update the same data. Let’s understand this with the help...
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...
