‘SQL Server 2016 is the foundation of Microsoft’s data strategy, encompassing an innovation that transforms the data into intelligent action.’ The new release delivers an end-to-end data management and business analytics solution with mission critical intelligence for your most demanding applications along with insights on your data on any device.
The company states,
“Recently, we had the opportunity to showcase the exciting capabilities and what customers are doing with SQL Server 2016 at our Data Driven event.”
Today Microsoft announces the following, as per the official blog,
“SQL Server 2016 will be made available generally on June 1, 2016. This would allow you to build mission-critical along with business critical intelligent applications with the most secure database, the highest performance data warehouse, end to end mobile BI on any device, in-database advanced analytics, in-memory capabilities optimized for all workloads, and a consistent experience from on-premises to cloud. These capabilities are built-in to SQL Server for industry-leading low cost of ownership.”
“New SQL Server 2016 performance benchmarks. Today, Lenovo published a new #1 TPC-H 30 TB world record3 using SQL Server 2016 and Windows Server 2016 on Lenovo System x2950 X6. This result, in addition to recent benchmarks by software and hardware partners, as well as key applications across variety of workloads, proves that SQL Server 2016 is the fastest in-memory database on the planet for your applications.”
“The SQL Server 2016 editions include Enterprise, Standard, Express, and Developer. In March, we announced that the SQL Server 2016 Developer edition will be a free download to enable broad access to and development on the full capabilities of the latest SQL Server release.”
SQL Server general availability
SQL Server 2016 will generally be available on June 1, 2016. SQL server 2016 is a comprehensive high performance high scale data platform for your most demanding application and insights available on your data on any device. SQL Server 2016, easily manages both relational and beyond relational (JSON, XML, Hadoop) data, it integrates structured data with Hadoop data and it also integrates on-premises data with cloud data. SQL Server 2016 is ideal for the following:
- Mission critical intelligent applications delivering real-time operational intelligence by combining built-in advanced analytics and in-memory technology without having to move the data or impact end user performance.
- Enterprise scale data warehousing with enhanced in-memory columnstore that increases query performance by over 100x vs disk based solutions. With SQL Server 2016, you can also access optimized MPP scale out software that can be combined with scale out appliance architecture with our Analytics Platform System (APS).
- Applications requiring the highest levels of security with new Always Encrypted technology that protects your data at rest and in motion without impacting database performance.
- Comprehensive business intelligence solutions on mobile devices with an end-to-end mobile BI solution built-in that can deliver insights on any device. You can also manage all of your KPIs, mobile reports and traditional reports from a modern web portal.
- New big data solutions that require combining relational data with non-relational data with PolyBase technology built-in that allows you to query structured and unstructured data with the simplicity of T-SQL.
- Hybrid cloud solutions that can reduce storage costs, improve high availability and simplify IT operations with new Stretch Database technology. This keeps more of your historical data at your fingertips by transparently and securely stretching warm and cold OLTP data to Microsoft Azure on-demand without application changes. In addition, faster replicas can be placed in Azure to give you cost effective disaster recovery and backups.
Microsoft states,
“Today, Lenovo published a new #1 TPC-H 30 TB world record using SQL Server 2016 and Windows Server 2016 on Lenovo System x2950 X6.4 This result, in addition to recent benchmarks by software and hardware partners, as well as key applications, show that SQL Server 2016 is the fastest in-memory database on the planet for your applications.”
They also states,
“Today we are announcing the features in our editions, including Enterprise, Standard, and Express. 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.”