SQL Server 2016 To Be Released June 1

Microsoft's venerable RDBMS gets a major update, with a developer-enabled version that unclutters the enterprise database solution development process.

Microsoft's SQL Server team announced an official release date for a major update to its venerable SQL Server relational database management system.

General availability for SQL Server 2016 is June 1. The announcement comes with specific information on features per edition.

"Today we are announcing the features in our editions, including Enterprise, Standard, and Express," writes Tiffany Wissner, senior director of Microsoft's Data Platform Marketing group, in a blog post. "With Enterprise, customers benefit from low cost of ownership with the full capabilities of SQL Server built into a single offering including our mission critical database, high performance data warehouse, rich data integration capabilities, end-to-end mobile business intelligence and built-in advanced analytics."

As Wissner describes in her post, SQL Server 2016 Enterprise is the most feature-complete version, with support for unlimited number of cores, advanced data and security integration features, cloud and mobile BI capabilities and the Microsoft R statistical computing programming language fully integrated among the vast array of capabilities.

A version of Enterprise, dubbed SQL Server 2016 Developer Edition, is built specifically for developers who need access to the Enterprise version's complete feature set for solution building and testing. It is expected to be free to developers who use it in conjunction with a Visual Studio Developer Essentials membership.

A step down from there is SQL Server 2016 Standard, which is limited to 24 cores, row-level security and policy-based management, support for JSON, some basic connectivity to R, and Stretch Database capabilities.

Microsoft will offer a free, stripped down version called SQL Server 2016 Express. It supports up to four cores, and has basic reporting and policy-based management features.

A full set of features for each division can be viewed in this PDF posted to the Microsoft site.

About the Author

You Tell 'Em, Readers: If you've read this far, know that Michael Domingo, Visual Studio Magazine Editor in Chief, is here to serve you, dear readers, and wants to get you the information you so richly deserve. What news, content, topics, issues do you want to see covered in Visual Studio Magazine? He's listening at [email protected].

comments powered by Disqus


  • Death of the Dev Machine?

    Here's a takeaway from this week's Ignite 2020 event: An advanced Azure cloud portends the death of the traditional, high-powered dev machine packed with computing, memory and storage components.

  • COVID-19 Is Ignite 2020's Elephant in the Room: 'Frankly, It Sucks'

    As in all things of our new reality, there was no escaping the drastic changes in routine caused by the COVID-19 pandemic during Microsoft's big Ignite 2020 developer/IT pro conference, this week shifted to an online-only event after drawing tens of thousands of in-person attendees in years past.

  • Visual Studio 2019 v16.8 Preview Update Adds Codespaces

    To coincide with the Microsoft Ignite 2020 IT pro/developer event, the Visual Studio dev team shipped a new update, Visual Studio 2019 v16.8 Preview 3.1, with the main attraction being support for cloud-hosted Codespaces, now in a limited beta.

  • Speed Lines Graphic

    New for Blazor: Azure Static Web Apps Support

    With Blazor taking the .NET web development world by storm, one of the first announcements during Microsoft's Ignite 2020 developer/IT event was its new support in Azure Static Web Apps.

  • Entity Framework Core 5 RC1 Is Feature Complete, Ready for Production

    The first release candidate for Entity Framework 5 -- Microsoft's object-database mapper for .NET -- has shipped with a go live license, ready for production.

Upcoming Events