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,...
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...
Rules for Implementing TDD in Old Project
The article “Sliding Responsibility of the Repository Pattern” raised several questions, which are very difficult to...
Events and Threads in .NET
I’d like to tell you straight off that this article will concern not threads in particular, but...
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...
Introduction to Temporary Tables in SQL Server
A temporary table in SQL Server, as the name suggests, is a database table that exists temporarily on the database server. A temporary...
Why Using Unit Tests is a Great Investment into High-Quality Architecture
I have decided to write this article in order to show that unit tests are not only a tool to...
Eliminating Duplication of Where Expressions in Application
Assume you have products and categories. A client says that it is necessary to use other business processes for the categories with the...
Better ALTER than DROP
In this article, I am going to provide a construction for deleting an object before creating it....
What Can Query Plan Tell?
Introduction SQL query describes the expected result, not the way to get the result. The set of...
