SQL Server 2016 SP1: Breakthrough Changes

A few days ago, Microsoft released Service Pack 1 (SP1) for SQL Server 2016. This release however, is not at all similar to older releases of SQL Server service packs, in a very pleasant manner.


Breakthrough Changes in SQL Server 2016 SP1

In addition to cumulative patches, bug fixes, improvements, etc., SQL Server SP1 does something else as well; it makes features that until now you could only find them in Enterprise Editions, available to the rest of the Editions of SQL Server 2016 with SP1. Yes, you’ve heard right! This is an exciting, breakthrough change!

Now you can use In-Memory OLTP not only in the Enterprise Edition of SQL Server 2016 SP1 but also in the Standard Edition, Web Edition and even in the Express Edition! Also, you can use columnstore, dynamic data masking and much more!


Summary Table

Let’s see below a table of Enterprise features of SQL Server 2016 that are now available in other editions as well, after of course upgrading to Service Pack 1:


Advanced Features of SQL Server 2016 SP1 Now Available in Other SQL Server 2016 SP1 Editions
Feature/SQL Server 2016 SP1 Edition SQL Server 2006 SP1 Enterprise Edition SQL Server 2006 SP1 Standard Edition SQL Server 2006 SP1 Web Edition SQL Server 2006 SP1 Express Edition SQL Server 2006 SP1 Local DB Edition
Row-Level Security
Dynamic Data Masking
Change Data Capture
Database Snapshot
In-Memory OLTP
Always Encrypted
Fine Grained Auditing
Multiple File Stream Containers
For more information please check this MSDN blog article.

As you can see this is indeed a breakthrough change. Now, everyone can experience the full potential of SQL Server. Now these features will be used even more broadly. New development work will include them even more thus creating new generation data applications that make use of these features. The possibilities are endless!

I’m planning to start a series of articles covering all these features in simple words and with simple examples so stay tuned!


Strengthen your SQL Server Administration Skills – Enroll to our Online Course!

Check our online course on Udemy titled “Essential SQL Server Administration Tips(special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Learn More


Recommended Online Courses:



Featured Database Productivity and Performance Tools

Snippets Generator: Create and modify T-SQL snippets for use in SQL Management Studio, fast, easy and efficiently.

Snippets Generator - SQL Snippets Creation Tool

Learn more


Dynamic SQL Generator: Convert static T-SQL code to dynamic and vice versa, easily and fast.

Dynamic SQL Generator: Easily convert static SQL Server T-SQL scripts to dynamic and vice versa.

Learn more


In-Memory OLTP Simulator: Easily benchmark memory-optimized tables in SQL Server.

In-Memory OLTP Simulator: Easily benchmark memory-optimized SQL Server tables


Subscribe to our newsletter and stay up to date!

Check out our latest software releases!

Check out Artemakis’s eBooks!


Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (2 votes, average: 5.00 out of 5)


Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub