Web directory

Microsoft unveils SQL Server release candidate for Linux • The Register

Just weeks after rolling out SQL Server 2022 Release Candidate 0 for Windows, Microsoft is following up with a release candidate for Linux systems.

Specifically, Redmond said this week that SQL Server 2022 RC 0 is now available for systems running Red Hat Enterprise Linux (RHEL) and Ubuntu operating systems. Microsoft launched its Linux port of SQL Server in 2016 and has (cough, cough) embraced open source ever since, eschewing former CEO Steve Ballmer’s view that “Linux is cancer.”

The Linux version of this latest offering not only includes the features included SQL Server 2022 RC 0 unveiled August 23 for Windows, but also supports several Azure-related cloud functions, wrote Amit Khandelwal, senior product manager for SQL Server, in a blog post this week.

Features included in RC 0 include Query Store to monitor system performance by automatically capturing query history, plan history, and runtime statistics. These can be viewed and reviewed by developers and greater management capabilities through built-in speedups and snapshot backups.

There are also language additions in RC 0, including Approx Percentile Disc which Microsoft says “returns the value of a group’s set of values ​​based on the supplied percentile and sort specification”, and Approx Percentile Cont, which “returns an approximate interpolated value from the set of values ​​in a group based on the percentile value and the sort specification.”

The version for Linux also supports Azure Synapse Link, which allows developers to use Azure Synapse Analytics to easily and directly access the Azure Cosmos DB analytical store.

“Integration Runtime (IR) cannot be installed on a Linux environment, so you will need to run the IR on a Windows machine that is on the same network as the Linux machine running the SQL Server instance it is running on. connects,” Khandelwal wrote. .

It also supports Azure Active Directory authentication, although currently SQL Server containers do not support the feature, he wrote.

According to market research firm Statista, the software ranked third behind Oracle and MySQL in a list of the most popular database management systems in August and ahead of others such as PostgreQL, MongoDB and Redis.

Mobile application developer AppInventiv also placed SQL Server third behind Oracle and MySQL in May in a list of the best databases for web applications, noting its strengths both on-premises and in the cloud, its presence in Windows and Linux systems and its support. for structured, semi-structured and spatial data.

“It’s not as inventive or advanced as other modern…popular databases, but it has undergone considerable improvements and revisions over the years,” the developer company wrote.

As The register described in an in-depth analysis this month, software engineers take a look at open source databases. A Stack Overflow survey of about 70,000 programmers this year found that nearly all of them use one of two major open source relational database management systems, PostgreSQL (at 46.5%) or MySQL (45.0%). .7%), as well as other systems.

So Microsoft continues to add features and functions to SQL Server for Linux systems and makes it a growing part of its Azure enterprise cloud services, which makes sense in a rapidly changing computing world that is increasingly more cloud-enabled and distributed. ®