The main goal for this change is to allow the developers to develop and build the applications that depends on these features on any SQL Server Edition installed in the customer’s environment. For In Memory OLTP feature, it becomes available in all SQL Server Editions except for the Local DB Edition as it requires creating filestream file groups that is not possible in Local DB due to insufficient permissions. For Change Data Capture, it becomes available only in the Standard and Web SQL Server Editions as this feature requires SQL Server Agent which is not available in the Express and Local DB Editions. The features list includes Database Snapshot, ColumnStore, Table Partitioning, Compression, Always Encrypted, Fine Grained Auditing, Multiple Filestream Containers and PolyBase.

In SQL Server 2016 SP1, a group of features that were available only in the Enterprise Edition, are now available now in the Standard, Web, Express, and Local DB SQL Server Editions. In this article, I will introduce you to these new features and enhancements.Įnterprise features added to Standard, Web, Express and Local DB editions It comes with a bunch of new features and enhancements as a result of customer and community feedback. Thom, it's an honour to be confused with Sue_H :).SQL Server 2016 SP1 is released as announced by Microsoft. Yes, I would not expect a full install to patch an existing instance.

Does it also have a way to 'upgrade from a previous patch level' (i.e., SP1 to SP2)? If it has all of these other options in one wizard to bring you current, then why not this too? I know the SQL Server 2016 SP2 installation wizard has many options to get you to that version/level like installing a new instance, upgrading from a previous version, upgrading from a previous edition. SP1 to SP2 isn't an upgrade though, it's a patch.ġ) Does it make sense that the full SQL Server 2016 SP2 install file wouldn't patch my SP1 instance of the same version/edition to SP2?Ģ) If you wouldn't expect the full install file to patch a SP1 instance of the same version/edition to SP2 by default, then is there a way (through some option or something I'm missing) to run it that would patch my instance to SP2?

Sql server 2016 express sp1