Authorization in ASP.NET Core MVC
This article describes patterns and methods available in ASP.NET Core MVC. I would like to...
Pitfalls of Linked Server Usage
An interesting project related to the task queue processing come to the company I work for. It was previously developed by another team. We...
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...
USE HINT and DISABLE_OPTIMIZED_NESTED_LOOP
One of the available algorithms to join two tables together in SQL Server is Nested Loops. The...
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. There are many different thoughts on using...
SQL Server Security Ponderings
DBA is the guardian of the data, and there are two aspects of being a guardian. The first one is...
SQL Server: The dark side of NVARCHAR
Introduction In this article, we are going to talk about using the nvarchar data type. We will explore how SQL Server stores this data type...
What Can Query Plan Tell?
Introduction SQL query describes the expected result, not the way to get the result. The set of specific steps the server must take to...
Scheduled Maintenance of the 24/7 IS Database in MS SQL Server
Introduction This article is a short review of the main scheduled maintenance with a database of...
