• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

Service Pack 1 for SQL Server 2016

January 20, 2017

In Novemeber Microsoft released Service Pack 1 (SP1) for Microsfot SQL Server 2016. It is very good a step forward for all companies in my opinion.

The main reason is that Microsoft decided to open up a few features that were previously available only in the Enterprise Edition.


It means that several Enterprise features are now available in Standard, Web, Express and LocalDB.


For example:


 - ColumnStore Index

 - Partitioning

 - Compression

 - In Memory OLTP

 - Polybase

 - Always Encrypted

 - Change Data Capture

 - Create or Alter


Here is the complete list of new features available in SP1!



IMHO, this change forces a lot of companies to upgrade their old version of SQL Servers to SQL Server 2016.


You can find more information on MSDN Blog


See you later guys!


Please reload

Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon