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.
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
- Always Encrypted
- Dynamic Data Masking
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 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)
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)