Don’t like database triggers? You just don’t know how to work with them!
When designing large relational databases, we often make a decision to diverge from a normal form,...
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...
How Generics save from Boxing
At the method input, we often perform a null test. Someone makes the test as a separate method, so...
GitHub for Windows Users
If your project is stored only on your disk, then you are in for trouble when the disk fails. Even a regular backup will not always save...
How to Use Signals in C#
Currently, the thread synchronization in С# causes some difficulties, in particular, when passing synchronization primitives...
Generic Repository Pattern in Entity Framework
A Repository mediates between the domain and data mapping layers, acting like an in-memory domain...
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...
LINQ: Dynamic Creation of Query Filters
Sooner or later, each developer has to create data tables with the possibility to sort by columns. I am not an exception. In our project,...
Configuring Database Mail Notifications in MS SQL Server
Introduction Often, there is a need to somehow inform administrators about the problems with a...