Creation of a temporal table

Live Query Plans and Blocking

Erik Darling looks at how SQL Server 2016's live query plans react when they're blocked.

Extracting a DAX Query Plan With Analysis Services 2016 Extended Events

In this post, Koen Verbeeck shows how to use SQL Sever 2016's Extended Events to find the query plan for a DAX query, just like you would for a T-SQL statement.

Setup and Implement SQL Server 2016 Always On Distributed Availability Groups

SQL Server 2016 introduced a new feature called Distributed Availability Group. A Distributed Availability Group is a special type of Availability Group that spans two separate Availability Groups. Edwin Sarmiento explains.

Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4

Continuing his series covering a step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster, Edwin Sarmiento looks at adding a node to an existing SQL Server 2016 failover clustered instance (FCI).

CPU Limits

New CREATE OR ALTER statement in SQL Server 2016 SP1

Ahmad Yaseen explains what SQL Server 2016 SP1's new CREATE OR ALTER statement does, and how to use it.

Columnstore Indexes and Computed Columns in SQL Server 2016

You can’t do everything with a columnstore index — but SQL Server’s optimizer can get pretty creative so it can use a columnstore index in ways you might not expect. Kendra Little explains.

SQL Server 2016 Build List

A list of all builds for SQL Server 2016. Updated with CU2 for SP2 and CU10 for SP1.

SQL Server 2016 Enterprise Edition Performance Advantages

Glenn Berry uses a few specific examples to demonstrate the performance benefits you can get from SQL Server 2016 SP1 Enterprise Edition.