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...
Hangfire: Task Scheduler for .NET
Hangfire is a multi-threaded and scalable task scheduler built on client-server architecture on .NET stack (Task Parallel Library and...
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...
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...
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...
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...
Entity Framework 6: Extensions You Might Be Unaware Of
Entity Framework 6 was and still remains a ‘workhorse’ for data access incorporate. NET-based applications primarily because of...
Precise Computation of CLR Object Size
I think many developers have been wondering: How many bytes does an object instance take in managed...
