Без названия

[codingsight-blog]

C# is a multi-paradigm programming language. Recently, the course has been set towards new functional constructions in C#. We can go further and add other extension methods that allow writing less code without ‘climbing’ in the F# territory.

[codingsight-blog]

Entity Framework: (anti)pattern Repository | {coding}Sight

This article describes Generic Repository as an attempt to disregard a particular ORM and a repository as a set of queries to a selected database table.

[codingsight-blog]

Signals in C#

The article describes an interface of implementing the simple class that allows sending and receiving signals with a thread lock.

[codingsight-blog]

Preparing for Exam 70-483: Programming in C# | {coding}Sight

The article is dedicated to preparation for Exam 70-483: Programming in Microsoft C#. The article may help you to highlight certain aspects of C#.

[codingsight-blog]

Some questions may seem too basic, but they still contain tiny tricks. Sometimes even a simple question may nail to the wall. These questions will be useful to all who study the language.

[codingsight-blog]

Pivot Tables in MySQL

This article deals with the transformation of table data from rows to columns. Such transformation is called pivoting tables. Often, the result of the pivot is a summary table in which statistical data are presented in the form suitable or required for a report.

[codingsight-blog]

In this article, we are going to review DBAs mistakes, the consequences of which were quite perceptible and which I had to deal with. The purpose of the article is to prevent users from repeating these mistakes. Sometimes, a bad experience is even more valuable than a positive one.

[codingsight-blog]

Understanding Dirty Read Problem with SQL Server | {coding}Sight

One of the most common problems that occur while running concurrent transactions is the Dirty Read problem. A dirty read occurs when one transaction is permitted to read data that is being modified by another transaction which is running concurrently but which has not yet committed itself.

[codingsight-blog]

SQL Server 2016: JSON vs XML - Performance Comparison

In this article, you will find the comparison of JSON and XML performance.

[codingsight-blog]

SQL Server: The dark side of NVARCHAR | {coding}Sight

We are going to talk about nvarchar data type. We will explore how SQL Server stores this data type on the disk and how it is processed in the RAM. We will also examine how the size of nvarchar may affect performance.