News

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

Featured

  • Compare New GitHub Copilot Free Plan for Visual Studio/VS Code to Paid Plans

    The free plan restricts the number of completions, chat requests and access to AI models, being suitable for occasional users and small projects.

  • Diving Deep into .NET MAUI

    Ever since someone figured out that fiddling bits results in source code, developers have sought one codebase for all types of apps on all platforms, with Microsoft's latest attempt to further that effort being .NET MAUI.

  • Copilot AI Boosts Abound in New VS Code v1.96

    Microsoft improved on its new "Copilot Edit" functionality in the latest release of Visual Studio Code, v1.96, its open-source based code editor that has become the most popular in the world according to many surveys.

  • AdaBoost Regression Using C#

    Dr. James McCaffrey from Microsoft Research presents a complete end-to-end demonstration of the AdaBoost.R2 algorithm for regression problems (where the goal is to predict a single numeric value). The implementation follows the original source research paper closely, so you can use it as a guide for customization for specific scenarios.

  • Versioning and Documenting ASP.NET Core Services

    Building an API with ASP.NET Core is only half the job. If your API is going to live more than one release cycle, you're going to need to version it. If you have other people building clients for it, you're going to need to document it.

Subscribe on YouTube