Looking ahead: Microsoft Edge for developers in 2016  

• This update contains fixes for issues that were fixed after the release of SQL Server 2016 SP1.
• The latest 2016 SP1 update is CU2 - 4013106
• You may have been directed here from a previous SP1 Cumulative Update Knowledge Base (KB) article (See SQL Server 2016 SP1 build versions)
• This Cumulative Update includes all fixes from all previous SP1 Cumulative Updates, therefore it can be installed to resolve issues fixed in any previous SP1 CU 

Here are some additional changes in SQL Server 2016.

Feature	SQL 2014	SQL 2016
Foreign Keys	Not supported	Supported
Check/Unique Constraints	Not supported	Supported
Parallelism	Not supported	Supported
Indexes on NULLable columns	Not supported	Supported
Maximum size of durable table	256 GB	2 TB
ALTER PROCEDURE / sp_recompile	Not supported	Supported
SSMS Table Designer	Not supported	Supported
Check/Unique Constraints	Not supported	Supported

How Microsoft brought SQL Server to Linux 

Indirect Checkpoints is not just about predictable recovery, it enables SQL Server to scale and run faster 

In SQL Server 2012, indirect checkpoint was first introduced in SQL Server and it was made a default algorithm for all new databases starting SQL Server 2016. 

When I look at that list today, SQL Server 2016 makes a pretty compelling case for most folks. It’s a good balance of new features, stability, and long shelf life. 

Scott Klein and Joey D'Antoni provide an overview of the SQL Server 2016 features and enhancements, teasing up many of the features discussed in the other videos as well as covered in the training kit.
 

Free eBook: Introducing Microsoft Power BI