How SQL Server 2016 Took Azure SQL Data Warehouse to Next Level
Azure SQL DW (SQL Data Warehouse) is a massively parallel, petabyte-scale, cloud solution for data...
Exploring SQL Server 2016 Query Store GUI
Introduction Query store is a new feature, introduced in SQL Server 2016, that allows database administrators to historically review...
Performing Data Changes Audit Using Temporal Table
SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using normal table, you can retrieve current data;...
USE HINT and DISABLE_OPTIMIZED_NESTED_LOOP
One of the available algorithms to join two tables together in SQL Server is Nested Loops. The...
Working with JSON in SQL Server 2016
JSON is one of the most widely used data interchange formats. It is also a storing format in several NoSQL solutions, in particular, in...
New Query Hints Including USE HINT in SQL Server 2016 SP
This article is an introduction to the query hint overview that appeared in SQL Server 2016 SP1. There are many different thoughts on using...
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...
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,...
SQL Server 2016: New T-SQL Features
In this article, I would like to describe several new T-SQL features available in SQL Server 2016: DROP IF EXISTS, SESSION_CONTEXT, MAXDOP,...
In-Memory OLTP: What’s new in SQL Server 2016
SQL Server development team has added new features to In-Memory OLTP. All these features allow you...
