Andrey Langovoy, Author at {coding}Sight

Everything you should know about SQL Server JOINS

Andrey Langovoy — Mon, 13 Mar 2017 16:55:26 +0000

The focus of this article is going to be on utilizing JOINs. We will start off by talking a bit about how JOINs are going to happen and why you need to JOIN data. Then we will take a look at the JOIN types that we have available to us and how to use them. …

The post Everything you should know about SQL Server JOINS appeared first on {coding}Sight.

Creating and Accessing In-Memory OLTP Databases and Tables

Andrey Langovoy — Mon, 16 Jan 2017 13:44:40 +0000

This is the second article in a series of articles about SQL Server In-Memory OLTP. The introductory article — SQL Server In-Memory OLTP, briefly introduced the basics of the new Hekaton engine. In this part, we will focus on practice. To be more specific, we will see how to create In-Memory optimized databases and tables, …

The post Creating and Accessing In-Memory OLTP Databases and Tables appeared first on {coding}Sight.

SQL Server In-Memory OLTP: The Basics

Andrey Langovoy — Fri, 09 Sep 2016 11:14:15 +0000

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 internally. We will focus on details of in-memory optimized tables and indexes. This is the entry-level article, which means you do not need to be an SQL Server expert, however, you …

The post SQL Server In-Memory OLTP: The Basics appeared first on {coding}Sight.

Deploying Database from Source Control

Andrey Langovoy — Tue, 02 Aug 2016 04:55:30 +0000

These days, development teams start new projects from choosing a version control system. There are many benefits of source control systems in coordinating the efforts of the development team. It ensures a complete audit trail of all changes to the code and allows the team to reproduce any specific revision or build. Along with the …

The post Deploying Database from Source Control appeared first on {coding}Sight.

JSON Support in SQL Server 2016

Andrey Langovoy — Sat, 16 Jul 2016 15:18:18 +0000

SQL Server 2016 provides the built-in support for importing, exporting, parsing, and querying JSON documents or fragments. In this article, we will discuss this feature in more details! JSON (JavaScript Object Notation) is a lightweight data-interchange format that uses text name/value (or attribute/value) pairs to represent data. JSON serves as a data transmission technology that …

The post JSON Support in SQL Server 2016 appeared first on {coding}Sight.

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

Andrey Langovoy — Mon, 04 Jul 2016 11:29:49 +0000

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 expensive queries in your database. Query Performance Insights was announced in early October 2015. To understand what it is, let’s think about how do you usually learn that …

The post Query Performance Insight: Discovering What Consumes Resources of Your Azure SQL Database? appeared first on {coding}Sight.

EFFECTIVE CODE REVIEW: Uprooting Source Code Defects

Andrey Langovoy — Sun, 05 Jun 2016 09:15:23 +0000

Preface In software development, a small coding error can result in a critical vulnerability that may lead to malfunction of an entire system. There are many techniques for detecting software defects such as static code analysis, manual and automated testing, pair programming, continuous integration, and of course, code inspections. However, detecting defects in software product …

The post EFFECTIVE CODE REVIEW: Uprooting Source Code Defects appeared first on {coding}Sight.

SQL Server Database Backup Encryption

Andrey Langovoy — Sun, 08 May 2016 13:55:27 +0000

To manage the data security that has been backed up by the file system as a database backup files, SQL Server provides the backup encryption feature. In this article, we will talk about encryption options available in SQL Server for database backups. We will have a closer look at the usage details, benefits, and recommended …

The post SQL Server Database Backup Encryption appeared first on {coding}Sight.

JavaScript Recipes: A Problem-Solution Article

Andrey Langovoy — Tue, 05 Apr 2016 09:37:22 +0000

Why reinvent the wheel every time you run into a problem with JS? This article is chock-full of code recipes that address common programming tasks. Q: What is Javascript object creation best practice? How to protect themselves from errors, if the new keyword is used? I always capitalize constructor names. I use this instanceof funcName to validate …

The post JavaScript Recipes: A Problem-Solution Article appeared first on {coding}Sight.

Javascript Closures

Andrey Langovoy — Tue, 05 Apr 2016 09:09:50 +0000

Closures in Javascript are (internal or nested) functions that refer to (outer) independent variables. Simply put, the function declared in the closure remembers the environment in which it was created. Lexical scope Consider the following: function outerFunc() { var outerVar; var func = function () { var innerVar //Do something here x = innerVar + …

The post Javascript Closures appeared first on {coding}Sight.