Several days ago, it shocked us when Microsoft broadcasted that it would soon transport its SQL Server database to Linux. However, It will take up until 2017 before SQL Server will be available on Linux. The company’s database attention rests directly on the upcoming release of SQL Server 2016, that is recently obtainable as a release candidate and that will become usually available later this year.
Microsoft is starting the launch period for SQL Server 2016 with an occasion in New York today and it is feeling so good about SQL Server that it broadcasted today a free migration offer for Oracle users, as well. There is one thing Sirosh specifically stressed is that SQL Server 2016 will be extremely faster than the prior version. “Without using any of the new features in the software, which include better support for in-memory computing, for example, queries should execute 25 percent faster on the same hardware. Once you start making use of new features like SQL Server 2016’s in-memory updatable columnstores, those speed-ups could hit 100x for some types of queries,“ according to sources.
Those type of speed gains, Sirosh noted, are not something you would possibly get from other relational databases like MySQL very soon. Of course, you could use those, “but with MySQL, you will need much more hardware,” he said and added that “you will pay in hardware what you save in software,” without gaining any of the enterprise-centric security features that Microsoft offers.”
Probably more importantly, although, these speed gains also mean SQL Server 2016 will permit for real time analytics instead of having to use a dedicated statistics warehousing solution.
On the analytics side, Microsoft is also increasing support for the statistical computing environment R right into SQL Server. This plan is the outcome of Microsoft’s acquisition of Revolution Analytics back in 2014. Data scientists can now use R directly on their databases rather than of having to remove and move data first.
Another quality that Sirosh stressed out in the discussion, “ Unlike previous versions, SQL Server 2016 can’t just encrypt data at rest but also query it without having to decrypt it, using a relatively new cryptographic technique called “homeomorphic called encryption.”
Microsoft observed at some of the existing styles in enterprise computing to lead the growth of its flagship database product. One of these is clearly a move in the direction of cloud computing. Although the on-premises version of SQL Server 2016 is still building its way to general accessibility, Microsoft has really been using the same codebase to power Azure’s SQL database service. Certainly, SQL Server 2016 presently runs on about 1.4 million machines and the firm has been using it there for nine months now.
“We built most of the features of SQL Server 2016 in the cloud,” Sirosh said and added that this means the software is already “battlefield tested.”
With SQL Server 2016, Microsoft is also putting more skill to “stretch” the warm and cold data from their on-premises database into Azure. Sirosh said that this could lead to main cost savings for enterprises, given that loading data in the cloud will probably be cheaper than behind the firewall. Although, the data will still be queryable from the on-premises version, according to the report.
Microsoft is so sure that firms will want to switch to SQL Server 2016 ,that it is releasing a new program for Oracle users. “Customers currently running applications or workloads on non-Microsoft paid commercial RDBMS platforms will be able to offset the costs of licensing, migration planning and training when moving SQL Server 2016,” Sirosh commented in today’s statement.
Precisely, which means Oracle database users who move to SQL Server can avail free licenses (have to subscribe to Microsoft’s Software Assurance service). Furthermore, they can also avail free training and helped deployment services. Enterprises will have to go through their account representatives to get this proposal.