Microsoft’s next version of SQL Server :
Microsoft announced on may 2 that they going to launch their new Microsoft’s flagship database product(The next version of SQL Server), on June 1 2016. Besides all of their updates ,The biggest difference between this release cycle and others is that the company itself tested many of the new features of SQL Server 2016 in its Azure cloud.As they informed earlier this year, the main focus of this update is on speed and security (by this new ability to perform some queries on encrypted data without having to decrypt it first),and with this new version, Microsoft is also planing on positioning SQL Server as a solution for data warehousing and big data analytics, thanks to both its built-in R support and its ability to store and query both structured and unstructured data.
The most excited features of this are Speed-ups, as their update promises-even without making any modification in hardware this will run most queries on an average of 25 % faster than before . They also announced a new Lenovo benchmark that shows SQL Server 2016 running on Windows Server 2016 (which is still in preview) handling a standard database test using 30 terabyte of data faster than any of its competitors.
SQL Server 2016 will come in four editions: Enterprise, Standard, Express and Developer.
Tiffany Wissner says that , the pricing for the Enterprise and Standard Editions or getting this Developer edition for free, will offer all the features of the full Enterprise Edition but won’t change from what Microsoft currently charges for the 2014 version — though its license forbids using it for production use cases. The other free edition is the Express edition, which can be used in production, but it can only use up to 1GB of RAM and the maximum database size is 10 GB. It also doesn’t offer some of the more high-end features of the Standard and Enterprise editions, including some of the advanced high-availability, security, business intelligence and data warehousing features.
By " Tech Post "