SQL Server 2017 on Linux helps increase performance for companies

Microsoft has bet more on its love for open source when bringing SQL Server 2017 to Linux. This can help ease the burden on businesses that already have Linux experts and are in need of SQL. Although it has not been officially released until the end of this year, the first user has gained many benefits thanks to this new Linux support.

Dv01 is a software enterprise that makes reports and analyzes, sends it to financial institutions to provide customer loans, has tried SQL Server 2017 on Linux instead of Windows for some. my job. It gave the company the features they needed on SQL to reduce data storage requirements, management time, simplify the work DevOps, vice president of engineering Dean Chen told Microsoft.

This brings another benefit that the company does not need to support two operating systems anymore. 'It helps us improve the workflow because currently many engineers are still working on Macs,' Chen said. Previously, the company used SQL Server 2016, not Linux support. Microsoft said in March, DV01 tested SQL Server 2017 on its largest database.

SQL Server 2017 on Linux helps increase performance for companies Picture 1
Microsoft brought its key product SQL Server 2017 to Linux

'The biggest benefit is that we can migrate SQL Server to Linux without having to downgrade other areas,' Chen said. This month, they will move SQL Server 2017 on Linux's Docker to the production network.

When Microsoft CEO Satya Nadella announced that SQL would support Linux in the spring, everyone was surprised by Linux as a rival to Microsoft. Subsequently, vice president Scott Guthrie said that the company planned to release SQL Server for Linux in the middle of the year. Their goal is to provide a stable data base on both Windows and Linux.

SQL Server on Linux will bring the key features users expect of a server software, including Stretch Database, which allows administrators to send data from the physical server to the Azure cloud for storage, in When applications need special data tables are still accessible.

'This is an important decision of Microsoft, which allows to provide a well-known and reliable database to more customers,' said an analyst at IDC Al Gillen. 'By putting this key product on Linux, Microsoft is making a commitment to become its multi-platform solution provider'.