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.

Lightweight Code Review

Code Management, Tools & technologies • One Comment

This is the third article in a series of articles that describe code review process. In this part,...
Read More

EFFECTIVE CODE REVIEW: Formal Approach to the Process

Code Management

Formal Approach to Code Review This is the second article in a series of articles that describe the whys and hows of the code review...
Read More

ROLLBACK TRUNCATE in SQL Server

Database development, Statements

Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all data loss. The worst thing is that you...
Read More

Iterating Over JavaScript Arrays

Basics of JavaScript, Languages & Coding

Iterating Over Arrays The article describes ES5 and ES6 approaches to iterate over javascript...
Read More

SQL Server Transaction Log — Part 1

Database administration, Transaction Log • One Comment

Every SQL Server database contains one or more transaction log files in addition to data files. Log files record all transactions and...
Read More

С# Nuances: foreach

Basics of C#, Languages & Coding

You may have been asked a question on a job interview: “What needs to be done to make your class work with the foreach loop?” Well, the...
Read More

Retrieving SQL Server Metadata with Help of T-SQL

Languages & Coding, T-SQL • 2 Comments

This article contains a list of scripts that mine the SQL Server metadata in the various system...
Read More

Active Directory vs Azure Active Directory

Azure, Cloud

Active Directory traditionally used to manage elements of a domain-based network. But companies increasingly implement various cloud...
Read More

C# Powerful String Functions

Basics of C#, Languages & Coding

The .NET Framework provides a set of powerful string functions. These building blocks can be used to write more complex algorithms for...
Read More

C# Extension Methods: a Useful Example!

Basics of C#, Languages & Coding

What is an extension method? The extension method provides the ability to extend the functionality...
Read More
Close