News

SQL Server 2016 Hits Release Candidate Stage, Gets Linux Support

Microsoft on Monday issued a release candidate (RC0) of its upcoming SQL Server 2016 database system, as well as announced its plans to enable 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," said Scott Guthrie, executive vice president of Microsoft's Cloud and Enterprise Group, in a blog post. "We are bringing the core relational database capabilities to preview today, and are targeting availability in mid-2017."

In addition to the Linux capability, Microsoft also announced a new RC of SQL Server 2016 that includes a preview of the SQL Server Stretch Database service, which lets enterprises "stretch" their on-premises data to a service in the Microsoft Azure cloud.

"Right now, with SQL Server 2016 RC0, when you enable stretching to Azure from SQL Server Management Studio, the default behavior is to stretch to Azure SQL Database," the SQL Server team said in a blog post. "If you would like to preview the new Stretch Database service, you can enroll in the preview and we'll provide instructions for configuring your SQL Server 2016 database for this new service. For future builds of SQL Server 2016, Stretch Database service will be the default target location for stretching."

Microsoft made the announcements as a prelude to a Data Driven event this Thursday surrounding the RC0 preview in New York. General availability of SQL Server 2016 is scheduled for later this year.

Guthrie said the 2016 version of the software will provide:

  • New 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.

  • Better data warehousing performance with the No. 1, No. 2 and No. 3 TPC-H 10 terabyte benchmarks for non-clustered performance, and the No. 1 SAP SD Two-Tier performance benchmark on Windows.

  • Business intelligence (BI) for every employee on every device -- including new mobile BI support for iOS, Android and Windows Phone devices.

  • Advanced analytics using new R support that lets customers do real-time predictive analytics on both operational and analytic data.

  • Unique 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.

IDC analyst Al Gillen weighed in on the plan to bring SQL Server to Linux, one of the best indications yet that Microsoft has changed its proprietary ways.

"This is an enormously important decision for Microsoft, allowing it to offer its well-known and trusted database to an expanded set of customers," Microsoft quoted Gillen as saying. "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."

About the Author

David Ramel is the editor of Visual Studio Magazine.

Featured

  • The 2019 Microsoft Product Roadmap

    From the next major update to Windows 10 to the next generation of HoloLens, here's what's on tap from Microsoft this year.

  • 2019 Microsoft Conference Calendar: For Partners, IT Pros and Developers

    Here's your guide to all the IT training sessions, partner meet-ups and annual Microsoft conferences you won't want to miss this year.

  • Microsoft Ends Development on Windows To Go

    The May 2019 update of Windows 10, also known as version 1903, will be the last Windows client OS to have support for Windows To Go.

  • Microsoft Finally Releases Hyper-V Server 2019

    Conceding that it has taken "way too long," Microsoft has announced that Hyper-V Server 2019 is now available for download.