Skip and go to main content

Design & Technology March 08, 2016

SQL Server 2016 released with plans to run on Linux

Image

Microsoft has begun a wave of launch activities for its most significant release of SQL Server 2016, with general availability planned for later this year.

This latest release includes some key new capabilities, including:

  • Advanced security encryption capabilities that enable data to always be encrypted at rest, in motion and in-memory to deliver maximum security protection.
  • In-memory database support for every workload with performance increases up to 30-100x.
  • Data Warehousing performance with the #1, #2 and #3 TPC-H 10 Terabyte benchmarks for non-clustered performance, and the #1 SAP SD Two-Tier performance benchmark on windows.
  • Advanced analytics using new R support, that enables customers to do real-time predictive analytics on both operational and analytic data.
  • Cloud capabilities that enable customers to deploy hybrid architectures that partition data workloads across on-premises and cloud based systems, to save costs and increase agility.

These improvements provide a complete platform for data management, business analytics and intelligent apps – one that can be used in a consistent way across both on-premises and the cloud.

SQL Server to also run on Linux

Microsoft will also be enabling SQL Server to run on Linux. This will enable SQL Server to deliver a consistent data platform across Windows Server and Linux, as well as on-premises and cloud. The core relational database capabilities are available to preview, with general availability in mid-2017.

SQL Server on Linux will provide customers with even more flexibility in their data solution. One with mission-critical performance, industry-leading TCO, best-in-class security, and hybrid cloud innovations – like Stretch Database which lets customers access their data on-premises and in the cloud whenever they want at low cost – all built in.

This is an enormously important decision for Microsoft, allowing it to offer its well-known and trusted database to an expanded set of customers”, said Al Gillen, group vice president, enterprise infrastructure, at IDC. “By taking this key product to Linux Microsoft is proving its commitment to being a cross platform solution provider. This gives customers choice and reduces the concerns for lock-in. We would expect this will also accelerate the overall adoption of SQL Server.

Gartner recently named Microsoft as leading the industry in their Magic Quadrant for Operational Database Management Systems in both execution and vision. It’s also a leader in Gartner’s Magic Quadrant for Data Warehouse and Data Management Solutions for Analytics, and Magic Quadrant for Business Intelligence and Analytics Platforms, as well as leading in vision in the Magic Quadrant for Advanced Analytics Platforms.

Questions? We are here to help!