On November 16, 2016, Microsoft announced significant changes to all editions of the the SQL Server data platform offering. These changes mean numerous advanced performance, manageability, security and scalability features that were previously available only in Microsoft SQL Enterprise Edition are now available for all Microsoft SQL editions.
Microsoft disrupted its long-standing feature/edition-based approach. They are now providing organizations that hold licenses across all SKUs with access to almost all of the SQL Server features when they upgrade to SQL Server 2016.
This approach is a true game changer. Microsoft is now offering a common feature surface area across editions and differentiating editions via the usage of SKU-specific resource limitations rather than feature set limitations.
What does this mean for you?
Although previous SQL Server releases (SQL 2008, SQL 2012 and 2014) have each introduced new advanced features, these features have primarily been limited to the Enterprise Edition product SKU. This often meant that non-enterprise edition customers didn’t have a compelling reason to upgrade. But this has all changed.
If you haven’t thought about upgrading your SQL Server environment before, you now have a number of compelling reasons to do so.
1. SQL Server now provides a consistent programmability surface area (CPSA) for developers and organizations across SQL Server editions.
- This reduces the TCO by allowing organizations to develop a singular software branch leveraging a common feature set across editions. This is particularly relevant for ISV’s and organizations with internally developed applications leveraging MSSQL.
- Allows organizations to build applications that seamlessly scale across editions based on application resource requirements rather than feature utilization.
- Provides organizations an opportunity to evaluate and substitute current or planned enterprise edition instances with standard edition. This applies to use cases in which feature set and not application scale was the primary enterprise edition requirement.
2. More than a dozen advanced features are now available to SQL 2016 standard edition customers at no additional cost.
- Performance features including In-Memory OLTP and Columnstore technologies
- Scalability features including Partitioning and Data CompressionSupportability features including Change Data Capture, Enhanced Auditing, and Query Store
- Security features including AlwaysEncrypted, Dynamic Data Masking, and Row-Level Security.
- Cloud Integration features including Stretch Database and PolyBase
3. SQL Server 2016 just runs faster.
- SQL Server 2016 introduces significant core database engine performance and concurrency enhancements that are unavailable in any edition of previous versions.
- TPC-H Benchmarks have scored Microsoft SQL 2016 38.4% more performant than an identical Microsoft SQL 2014 configuration, when measured in query-per-hour performance (QphH).
Pythian can help you take advantage of all that SQL 2016 has to offer.
We’ll assist with your upgrade to Microsoft Server 2016, and there is even the possibility of Microsoft funding. Contact us, and we’ll tell you how.
Want to talk with an expert? Schedule a call with our team to get the conversation started.
Interested in working with Richard? Schedule a tech call.