Understanding Transactions in SQL
A transaction in SQL is a unit of execution that groups one or more tasks together. A transaction...
Analysis of MS SQL Server for Those Who See It for the First Time
What Problems Will We Consider? If the server notifies “there is no more space on the E drive” – no deep analysis is...
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...
Counting references to a record in a table via Foreign Keys
I have recently needed to solve the task for my own purpose: to calculate the number of external...
Configuring Database Mail Notifications in MS SQL Server
Introduction Often, there is a need to somehow inform administrators about the problems with a server. Notifications are generally divided...
Synchronizing database structure between applications
Anyone who has ever developed applications that use a database has probably faced the problem of updating the database structure when the...
Understanding Dirty Read Problem with SQL Server
One of the most common problems that occur while running concurrent transactions is the Dirty Read...
Implementing OOP Inheritance in Classes that work with SQL and Entity Framework
This article is about creating a data model that would nicely fit SQL and contain “proper” OOP inheritance. I must say that I...
More about Introduction of Time zones in long-lived Project
Some time ago, we started to adapt the system to the new market that requires support for time zones. Initial research was described in the...
Introducing Common Table Expressions in SQL Server
Common Table Expressions, or CTE for short, is simply a technique to create a temporary set of...
