Everything you should know about SQL Server JOINS
The focus of this article is going to be on utilizing JOINs. We will start off by talking a bit...
Creating and Accessing In-Memory OLTP Databases and Tables
This is the second article in a series of articles about SQL Server In-Memory OLTP. The introductory article — SQL Server In-Memory OLTP,...
SQL Server In-Memory OLTP: The Basics
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...
Deploying Database from Source Control
These days, development teams start new projects from choosing a version control system. There are...
JSON Support in SQL Server 2016
SQL Server 2016 provides the built-in support for importing, exporting, parsing, and querying JSON documents or fragments. In this article,...
Query Performance Insight: Discovering What Consumes Resources of Your Azure SQL Database?
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...
EFFECTIVE CODE REVIEW: Uprooting Source Code Defects
Preface In software development, a small coding error can result in a critical vulnerability that...
SQL Server Database Backup Encryption
To manage the data security that has been backed up by the file system as a database backup files, SQL Server provides the backup...
JavaScript Recipes: A Problem-Solution Article
Why reinvent the wheel every time you run into a problem with JS? This article is chock-full of code recipes that address common...
Javascript Closures
Closures in Javascript are (internal or nested) functions that refer to (outer) independent...
