Specification Design Pattern in C#
In computer programming, the specification pattern is a particular software design...
SOLID: Single Responsibility Principle
In this article, I will try to describe one of the famous principles of the object oriented programming, that is a part of another famous...
CombGuid: Generation of SQL Server-friendly Guid Values in .NET Applications
Usage of UUID as a primary key for tables has a bunch of pros, including the option to retrieve IDs for objects created in a client...
Hangfire: Task Scheduler for .NET
Hangfire is a multi-threaded and scalable task scheduler built on client-server architecture on...
Entity Framework: Improving Performance when Saving Data to Database
When adding or modifying a large number of records (10³ and more), the Entity Framework performance is far from perfect. The reasons are...
Authorization in ASP.NET Core MVC
This article describes patterns and methods available in ASP.NET Core MVC. I would like to emphasize that we will explore only...
Pitfalls of Linked Server Usage
An interesting project related to the task queue processing come to the company I work for. It was...
Dynamic T-SQL and Benefits of its Usage
In our projects, we have to cope with different tasks. To solve some of them, we use dynamic T-SQL. Why do we need dynamic T-SQL? Well, it...
Working with JSON in SQL Server 2016
JSON is one of the most widely used data interchange formats. It is also a storing format in several NoSQL solutions, in particular, in...
New Query Hints Including USE HINT in SQL Server 2016 SP
This article is an introduction to the query hint overview that appeared in SQL Server 2016 SP1....
