September 19, 2017

Microsoft brings SQL Server to Linux

By Nina Mulamba

Microsoft will today be previewing an SQL Server for Linux that features the core relational database features of SQL Server 2016 as it awaits to launch the activities of the server on Thursday. This is to allow companies to be able to run their databases on Linux as well as on Windows server.

“SQL Server on Linux will provide customers with even more flexibility in their data solution. One with mission-critical performance, industry-leading TCO, best-in-class security, and hybrid cloud innovations, like Stretch Database which lets customers access their data on-premises and in the cloud whenever they want at low cost, all built in.” Said Microsoft’s executive vice president, Scott Guthrie.

The SQL server 2016 will be able to perform the following: Groundbreaking security encryption capabilities that enable data to always be encrypted at rest, in motion and in-memory to deliver maximum security protection and support for every workload with performance increases up to 30-100x In-memory database.

Also, Incredible Data Warehousing performance with the #1, #2 and #3 TPC-H 10 Terabyte benchmarks for non-clustered performance, and the #1 SAP SD Two-Tier performance benchmark on windows, Business Intelligence for every employee on every device – including new mobile BI support for iOS, Android and Windows Phone devices. Another function will be advanced analytics using new R support that enables customers to do real-time predictive analytics on both operational and analytic data.

Also, unique cloud capabilities that enable customers to deploy hybrid architectures that partition data workloads across on-premises and cloud based systems to save costs and increase agility.

 Microsoft already runs Linux in its cloud and recently announced a major partnership with Red Hat, for example. If it wants SQL Server to remain relevant, it needs to bring it to more platforms, including those that it previously regarded as competitors.

Microsoft says it currently uses the SQL Server 2016 code base to power more than 1.4 million SQL databases in its Azure cloud. SQL Server 2016, which is currently available as a public preview, will become generally available later this year as Microsoft  plans to open up access to SQL Server on Linux as it gets closer to general availability.

Related posts