{"id":2263,"date":"2016-05-02T19:03:44","date_gmt":"2016-05-02T16:03:44","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=2263"},"modified":"2016-05-02T19:03:44","modified_gmt":"2016-05-02T16:03:44","slug":"microsofts-sql-server-2016-june-release","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/microsofts-sql-server-2016-june-release\/","title":{"rendered":"Microsoft’s SQL Server 2016 set for June 1 Release"},"content":{"rendered":"
Microsoft has announced the upcoming release of SQL Server 2016. The scheduled date is set for June 1st 2016. There is also a preview version which is immediately available.<\/p>\n
This announcement also comes after several rounds of testing of the many new features planned for SQL Server 2016 in its Azure cloud platform. This seems to be a direction which Microsoft will be taking in future by releasing features through the Azure Cloud.<\/p>\n
A lot has gone into the latest version of Microsoft’s flagship database product and the major focus has been on performance and security. Microsoft boasts 100x faster queries, 30x faster throughput and 30x faster operations on its database server. The speed improvements can be achieved without having to upgrade the current hardware.<\/p>\n
Speaking of queries SQL Server 2016 is capable of searching through encrypted data without the need to decrypt the data first.<\/p>\n
Data warehousing and big data analytics is also a big focus in\u00a0 SQL Server 2016 through its built-in R support. This database can also store and query both structured and unstructured data.<\/p>\n
SQL Server 2016 will be available in 4 versions. These will be the paid commercial Enterprise and Standard editions. There will be a toned down Express edition with limits such as RAM usage at 1 GB and Data storage caped at 10 GB. Finally there will be a developer version that has no restrictions other than it cannot be used for commercial purposes as is with the other three editions.<\/p>\n
The full editions of SQL Server 2016 will allow the database to scale up to 12 TB of memory\u00a0 and 640 logical processors with Windows Server 2016. Advanced analytics can be processed directly within the database thereby reducing latencies and operational costs.<\/p>\n