“It’s not often that a service pack release for Microsoft SQL Server deserves as much attention — let alone a keynote announcement — as the first service pack for SQL Server 2016 does.” This was the comment made by online magazine SQLMag in a recent article, referencing Scott Guthrie’s (Executive VP for Cloud and Enterprise at Microsoft) keynote at last month’s Connect(); 2016.
The reason this particular Service Pack is receiving so much attention is because it makes innovation more accessible to all applications by unlocking key Enterprise Edition features across all editions of SQL Server 2016, showing that the product is moving into a more unified development model.
Previously, SQL Server had locked down many of its key features, such as In-Memory OLTP, for the Enterprise Edition only. With this Service Pack developers can now build to incorporate such features because it delivers a common programming surface across all editions – no application re-write is necessary.
You can try SQL Server 2016 SP1 for yourself on Azure Virtual Machine here.