Microsoft’s next-generation relational database operating system will become publicly available on June 1, the company announced Monday.
Advertisement
Customers with a Microsoft Software Assurance contract can get free lifetime licenses and additional technical support if they transfer their allegiances from Oracle by the end of June.
The Express and Developer editions will be available as a free download, making the capabilities of SQL Server 2016 broadly available to developers.
Some of the key components of Microsoft’s SQL Server 2016 include the “Always Encrypted” capability; the “Stretch Database” technology; Polybase engine for more easily managing relational and non-relational data; Dynamic Data Masking; Row-level security; new in-database analytics with R integration; and enhanced Microsoft “Hekaton” in-memory technologies for real-time analytics.
The newest edition of Microsoft’s data management and business analytics software will deliver a few significant new features previously unavailable in older versions. Enterprise-scale data warehousing boosts query performance by over 100x compared with disk-based solutions.
On the security side, SQL Server 2016 will come with Microsoft’s new Always Encrypted feature, which analyzes data without decrypting it using homomorphic encryption.
Microsoft recently released what execs said was the fourth and final release candidate of SQL Server 2016. In March Microsoft made the SQL Server 2014 Developer edition free for Visual Studio Dev Essentials members and announced the same will be true when SQL Server 2016 is released.
“SQL Server 2016 owns the top TPC-E performance benchmarks for transaction processing, the top TPC-H performance benchmarks for data warehousing, and the top performance benchmarks with leading business applications like PROS and KPMG”, said Microsoft. Mobile and traditional reports can also be managed from a Web portal.
Advertisement
This will allow you to build mission-critical, and 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. “In addition to leading performance benchmarks, SQL Server 2016 also delivers top price/performance for both workloads”.
