At Ignite, Microsoft announced a public preview of SQL Server 2016 to be released this summer. Touted as 'the biggest leap forward in Microsoft's data platform', they've already announced a slew of new features. Notable features include:
- Enhanced encryption technologies toting their 'Always' brand.
- 'Stretch Databases' - automatically 'stretch' cold data on azure storage while warm data remains local.
- In Memory and analytical improvements.
I took a gander at the data sheet for some more information, some of the smaller print had some interesting features:
- Up to 3 synchronous always on replicas for automatic failover across domains.
- Round robin load balancing of replicas. Nice!
- Enhanced Database Caching: Cache data with automatic, multiple TempDB files per instance in multi-core environments. This one is particularly interesting as it has been a best practice to implement multiple tempdb data files. I'm interested to see how MS implements this.
There are a ton more features you can read about here
. I'm eagerly looking forward to getting my hands on the public preview.