Database development

Rules for Implementing TDD in Old Project

Database development, Testing

The article “Sliding Responsibility of the Repository Pattern” raised several...
Read More

Events and Threads in .NET

Database development, Events

I’d like to tell you straight off that this article will concern not threads in particular, but events in the context of threads in...
Read More

Introducing Common Table Expressions in SQL Server

Database development, Tables

Common Table Expressions, or CTE for short, is simply a technique to create a temporary set of records that can be referenced within an...
Read More

Introduction to Temporary Tables in SQL Server

Database development, Tables • One Comment

A temporary table in SQL Server, as the name suggests, is a database table that exists temporarily...
Read More

Why Using Unit Tests is a Great Investment into High-Quality Architecture

Database development, Testing • 2 Comments

I have decided to write this article in order to show that unit tests are not only a tool to grapple with regression in the code but is...
Read More

Eliminating Duplication of Where Expressions in Application

Database development, Statements

Assume you have products and categories. A client says that it is necessary to use other business processes for the categories with the...
Read More

Better ALTER than DROP

Database development, Statements

In this article, I am going to provide a construction for deleting an object before creating it....
Read More

What Can Query Plan Tell?

Database development, Statements

Introduction SQL query describes the expected result, not the way to get the result. The set of specific steps the server must take to...
Read More

Optimizing Overlapping Queries Part 1: Introduction & Enhanced T-SQL Solution

Database administation, Perfomance Tuning, Statements

Databases that serve business applications should often support temporal data. For example, suppose a contract with a supplier is valid for...
Read More

SQL Server: Useful Tips for Newbies

Database development

In this article, we will discuss typical errors that newbie developers may face with while...
Read More
Close