Oracle as Workaround of Mutating Tables
The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger,...
Oracle Regular Expressions. Dangerous Range
An Oracle developer who often uses regular expressions in code sooner or later can face a phenomenon that is indeed mystical. Long-term...
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...
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 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...
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 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...