Microsoft has unveiled details of SQL Server 2016 ahead of its release later this year.
The new release will offer security encryption capabilities to protect data, and provides in-memory database support for every workload.
SQL Server 2016 will also deliver a high level of data warehousing performance thanks to 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.
Employees will be able to benefit from better access to business intelligence thanks to mobile BI support for iOS, Android and Windows Phone devices, while advanced analytics using R support enables real-time, predictive analytics on operational and analytic data.
SQL Server 2016 also offers unique cloud capabilities that allow customers to deploy hybrid architectures. These partition data workloads across on-premises and cloud-based system, helping customers to increase agility and save money.
“These improvements, and many more, are all built into SQL Server and bring you not just a new database but 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,” said Scott Guthrie, executive vice president of the cloud and enterprise group at Microsoft. “Over the last year we’ve been using the SQL Server 2016 code-base to run in production more than 1.4 million SQL Databases in the cloud using our Azure SQL Database as a Service offering, and this real-world experience has made SQL Server 2016 an incredibly robust and battle-hardened data platform.”
Microsoft will also bring SQL Server to Linux, enabling a consistent data platform across both Windows Server and Linux. This move aims to provide customers with more flexibility in their data solution, and Microsoft is targeting availability in mid-2017.
“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.”
Share this story