I fully expect the feature set to potentially evolve as Microsoft embraces this "brave new world" and gets feedback on these changes from the industry. In most cases these "limitations" will not dramatically affect most customers as I expect them to take advantage of this new functionality using Standard Edition. This could potentially dramatically reduce the licensing cost for enterprise customers. For scale-out solutions the Head Node will need to be installed on an Enterprise Edition instance. Furthermore Polybase will only be able to be installed as a Compute Node on the lower editions. Polybase will not be available with LocalDB. Web Edition and Express Edition will be limited to 1 core per query.
With Standard Edition queries will be limited to 2 cores per query. With Columnstore Indexes Microsoft will be limiting the degree of parallelism for queries used by the Database Engine. In-Memory OLTP will not be available with LocalDB due to technical limitations. For example Change Data Capture will not work on LocalDB and Express editions due to a various dependencies. Because of the differences in how some of these editions work there will be some limitations. So from LocalDB all the way through to Enterprise Edition a developer will have the same, consistent programmability surface area. That is quite an impressive list of functionality which will now be available in all editions. Specifically the following features will be available in all SQL Server editions:
This is a first for Microsoft, who has to date only ever moved features from Enterprise Edition to Standard Edition between different versions of SQL Server. The delivery vehicle for these changes will be SQL Server 2016 Service Pack 1, which is available immediately! That’s right, all editions of SQL Server! In an unprecedented announcement at CONNECT() //2016 in New York City today, Microsoft has announced that a number of Enterprise Edition only features will now be available in all editions of SQL Server.
0 kommentar(er)
