SQL Authority News – Download SQL Server 2016 Service Pack 1 (SP1)

Microsoft has earlier released SQL Server 2016 Service Pack 1 (SP1). This particular SP1 is one of the kind service pack and I will say it is a milestone move by Microsoft.

Now with this SQL Server 2016 Service Pack 1, Standard Edition will have many of the features which existed in only in Enterprise Edition. In simple words, now SQL Server 2016 Standard Edition will have many of the exclusive features of SQL Server 2016 Enterprise Edition after installation of SQL Server 2016 Service Pack 1.

SQL Authority News - Download SQL Server 2016 Service Pack 1 (SP1) sqlserver2016-800x281

Solarwinds

For example now SQL Server 2016 Standard edition users can also use the following features without upgrading to SQL Server 2016 Enterprise Edition.

  • In-memory OLTP
  • Operational Analytics
  • CDC
  • Always Encrypted
  • Dynamic Data Masking
  • Partitioning
  • PolyBase

The matter of the fact many of the above features are now available in SQL Server 2016 Express Edition as well. Regarding R Integration the basic integration is available in all the versions of SQL Server but Advanced R integration (ScaleR) is still available in Enterprise and Developer Edition.

SQL Server 2016 SP1

SQL Server 2016 SP1 Feature Pack

I personally think this is a great move by Microsoft and it will for sure encourage users to upgrade to SQL Server 2016. I recommend this to everyone who is using SQL Server 2016.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
,
Previous Post
10th Anniversary of SQL Authority – Thank YOU!
Next Post
WordPress – How to Move from HTTP to HTTPS – The Simple Complete Tutorial

Related Posts

1 Comment. Leave new

  • Wilfred van Dijk
    November 17, 2016 1:38 am

    That’s great news! Here’s a hint for SP2 release: increase the number of databases in a replica and make the 2nd replica usable for read/backup (this will kill Enterprise)

    Reply

Leave a Reply

Menu