SQL Server 2016: The Buzz Beyond Security

Key upgrade drivers to consider when planning for life after SQL Server 2005

Contributing Writer

The highlights of the newest version of Microsoft’s SQL Server 2016 take security and visibility upgrades of earlier versions and move toward availability, simplicity, and consistency. With only a few days to go before the end of support for SQL Server 2005, IT professionals are talking a lot about upgrades. While security is an important factor to consider, other improved features bring a lot to the table for SQL Server 2016 in Microsoft’s quest to meet the needs of today’s modern business.

Whether building or managing solutions on premises or in the cloud, the Always Encrypted technology protects data at rest and in transit. With even higher availability and improved scalability, and hybrid solutions that allow for stretched database and easy migration, the latest version of SQL Server 2016 has some new features that are creating a buzz for those enterprises looking for tools with revolutionary mission critical performance that offer deeper insight across data and devices.

Some of the highlights of the new product offering advances for mission critical performance include:

  • In-memory enhancements that allow for real-time operational analytic
  • In-memory OLTP enhancements with greater T-SQL surface area
  • Up to 30x faster transactions
  • Higher availability than SQL Server 2014 with improved ‘Always On’ secondaries
  • Ability to have up to 3 synchronous replicas
  • Enhanced data caching across multiple cores
  • Native JSON support
  • Temporal database to track historical changes

Access to data and deeper insights across data are additional advancements that provide enhanced performance, scalability, and usability across SQL Server Enterprise Information Management tools and Analysis Services. SQL Server 2016 allows for advanced analytics on a massive scale across data and devices with Mobile BI, enhanced reporting services, and built-in Advanced Analytics.

Read more announcements on the new public preview of next data platform that Microsoft is calling a breakthrough and “the biggest leap forward in Microsoft’s data platform history.”