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.
Jeff Shurak is an Anexinet SQL Server Architect focused on Disaster Recovery and Cloud Migration with over 14 years of data technology experience in ETL development, three-dimensional cube development, and database administration.