- 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.