Author: Andrey Langovoy

Andrey Langovoy is a team leader at Devart. He takes part in development and testing database management tools for SQL Server, writes articles about SQL Server and contributes to open source projects, MSDN and MDN.

Everything you should know about SQL Server JOINS

Database administration, Work with data

The focus of this article is going to be on utilizing JOINs. We will start off by talking a bit...
Read More

Creating and Accessing In-Memory OLTP Databases and Tables

Database administration, Memory Optimization

This is the second article in a series of articles about SQL Server In-Memory OLTP. The introductory article — SQL Server In-Memory OLTP,...
Read More

SQL Server In-Memory OLTP: The Basics

Database administration, Memory Optimization

This is the first article in a series of articles about In-Memory OLTP. It helps you to understand how the new Hekaton engine works...
Read More

Deploying Database from Source Control

Database development, Source control

These days, development teams start new projects from choosing a version control system. There are...
Read More

JSON Support in SQL Server 2016

JSON, Languages & Coding

SQL Server 2016 provides the built-in support for importing, exporting, parsing, and querying JSON documents or fragments. In this article,...
Read More

Query Performance Insight: Discovering What Consumes Resources of Your Azure SQL Database?

Azure, Cloud, Database administration, Performance Tuning

In this post, I’d like to take a brief look at the Query Performance Insight — SQL Azure tool which will help you to identify the most...
Read More

EFFECTIVE CODE REVIEW: Uprooting Source Code Defects

Code Management, Tools & technologies

Preface In software development, a small coding error can result in a critical vulnerability that...
Read More

SQL Server Database Backup Encryption

Database administration, Security

To manage the data security that has been backed up by the file system as a database backup files, SQL Server provides the backup...
Read More

JavaScript Recipes: A Problem-Solution Article

Basics of JavaScript, Languages & Coding

Why reinvent the wheel every time you run into a problem with JS? This article is chock-full of code recipes that address common...
Read More

Javascript Closures

Basics of JavaScript, Languages & Coding

Closures in Javascript are (internal or nested) functions that refer to (outer) independent...
Read More
Close