Oracle as Workaround of Mutating Tables

Computer Environment, Database development, Tables

The Oracle mutating trigger error occurs when a trigger references the table that owns the trigger,...
Read More

Oracle Regular Expressions. Dangerous Range

Computer Environment, Database development, Statements

An Oracle developer who often uses regular expressions in code sooner or later can face a phenomenon that is indeed mystical. Long-term...
Read More

Don’t like database triggers? You just don’t know how to work with them!

Database development, Triggers

When designing large relational databases, we often make a decision to diverge from a normal form, i.e. denormalization. The reasons for...
Read More

Analysis of MS SQL Server for Those Who See It for the First Time

Database administration, Database Optimization & Structure

What Problems Will We Consider? If the server notifies “there is no more space on the E...
Read More

The Lost Update Problem in Concurrent Transactions

Database administration, Transaction Log, Troubleshooting Issues

The lost update problem occurs when 2 concurrent transactions try to read and update the same data. Let’s understand this with the help...
Read More

How Generics save from Boxing

Computer Environment, Languages & Coding

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...
Read More

GitHub for Windows Users

Tools & technologies, Visual Studio

If your project is stored only on your disk, then you are in for trouble when the disk fails. Even...
Read More

How to Use Signals in C#

Basics of C#, Languages & Coding

  Currently, the thread synchronization in С# causes some difficulties, in particular, when passing synchronization primitives...
Read More

Generic Repository Pattern in Entity Framework

Frameworks, Languages & Coding • 2 Comments

A Repository mediates between the domain and data mapping layers, acting like an in-memory domain object collection. Client objects...
Read More

Counting references to a record in a table via Foreign Keys

Constraints, Database development

I have recently needed to solve the task for my own purpose: to calculate the number of external...
Read More
Close