Oracle Regular Expressions. Dangerous Range
An Oracle developer who often uses regular expressions in code sooner or later can face a...
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, i.e. denormalization. The reasons for...
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....
How Generics save from Boxing
At the method input, we often perform a null test. Someone makes the test as a separate method, so that the code looks cleaner, and gets...
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...
Generic Repository Pattern in Entity Framework
A Repository mediates between the domain and data mapping layers, acting like an in-memory domain object collection. Client objects...
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....
