data-konzept

'Starting with today’s release of SQL Server 2016 Service Pack 1, Standard Edition now has a lot more of the features of Enterprise Edition. Here’s the list from Microsoft’s announcement post

• Performance features – in-memory OLTP (Hekaton), in-memory columnstore, operational analytics
• Data warehousing features – partitioning, compression, CDC, database snapshots
• Some security features – Always Encrypted, row-level security, and dynamic data masking

The updated edition comparison page (Update 16 Nov – I’m hearing this grid isn’t quite right still) shows that these things still aren’t in Standard Edition:

• Full Always On Availability groups (multiple databases, readable secondaries)
• Master Data Services, DQS
• Serious security features – TDE, auditing
• Serious BI – mobile reports, fuzzy lookups, advanced multi-dimensional models and tabular models, parallelism in R, stretch database

Why would they be so generous? It’s simple: they need to drive SQL Server 2016 adoption. Lately, Standard Edition users just haven’t had a big reason to upgrade.

And now they do. If you’re on pre-2016 builds, it’s time to start having 2016 upgrade discussions with management. Go get ’em, tiger, and check out the full list of new and improved features.'...

https://www.brentozar.com/archive/2016/11/sql-server-2016-standard-edition-now-many-enterprise-edition-features/?utm_source=Brent+Ozar+Unlimited%C2%AE+List&utm_campaign=4f08c8d8d9-RSS_EMAIL_CAMPAIGN&utm_medium=email&utm_term=0_8e3e861dd9-4f08c8d8d9-296247489