The Lost Update Problem in Concurrent Transactions
The lost update problem occurs when 2 concurrent transactions try to read and update the same data....
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 records linked by a foreign key for each...
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...
Understanding Dirty Read Problem with SQL Server
One of the most common problems that occur while running concurrent transactions is the Dirty Read problem. A dirty read occurs when one...
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...
Introducing Common Table Expressions in SQL Server
Common Table Expressions, or CTE for short, is simply a technique to create a temporary set of records that can be referenced within an...
Working with SQL Server in Hybrid Cloud Scenarios
A hybrid cloud is a fairly attractive model when implementing cloud computing in enterprise information systems, as this approach combines...
Execute Powershell in SSIS Using C#
Introduction PowerShell is a Shell included in Windows to automate tasks in the operative system...
