Entity Framework: Improving Performance when Saving Data to Database
When adding or modifying a large number of records (10³ and more), the Entity Framework...
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 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....
USE HINT and DISABLE_OPTIMIZED_NESTED_LOOP
One of the available algorithms to join two tables together in SQL Server is Nested Loops. The nested loops join uses one join input as 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....
SQL Server Security Ponderings
DBA is the guardian of the data, and there are two aspects of being a guardian. The first one is integrity. It includes tasks like checking...
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...
