SQL Server 2022, the latest version of Microsoft's relational database management system, has been released for both Red Hat Enterprise Linux (RHEL) 9 and Ubuntu 22.04, two of the most popular Linux distributions. This means that users can now enjoy the benefits of SQL Server 2022 on their preferred Linux platform, whether it is on-premises or in the cloud.
SQL Server 2022 is the most Azure enabled release yet, with continued performance, security, and availability innovation. It integrates with Azure Synapse Link and Azure Purview to enable customers to drive deeper insights, predictions, and governance from their data at scale. It also supports new features such as contained availability groups, object storage integration, data lake virtualization, and more.
One of the key advantages of SQL Server 2022 on Linux is that it offers a consistent experience across platforms and environments. Users can leverage the same tools, languages, and features that they are familiar with on Windows, such as SQL Server Management Studio (SSMS), Azure Data Studio (ADS), Transact-SQL (T-SQL), and PowerShell. They can also use native Linux tools and frameworks, such as systemd, OpenLDAP, Kerberos, and Docker.
SQL Server 2022 on Linux also provides high availability and disaster recovery options, such as Always On availability groups, Pacemaker clusters, and link to Azure SQL Managed Instance. Users can easily migrate their existing databases to SQL Server 2022 on Linux using tools like Azure Database Migration Service (DMS) or SQL Server Migration Assistant (SSMA).
What SQL Server 2022 on Linux Brings
Microsoft is targeting a general availability release of SQL Server 2022 for Linux in the fourth quarter of 2023. In the meantime, the preview release is available for download from the Microsoft website.
The preview release of SQL Server 2022 for RHEL 9 and Ubuntu 22.04 includes a number of new features and improvements, including:
- Support for the latest hardware and software platforms, including Intel Cascade Lake and AMD EPYC processors
- Enhanced performance and scalability for large-scale data warehouses and analytics workloads
- New security features, such as Always Encrypted and Dynamic Data Masking
- Improved integration with Azure services, such as Azure Synapse Analytics and Azure Data Factory
SQL Server 2022 on Linux is a powerful and versatile solution for data management and analytics. It offers users the flexibility to choose their preferred Linux distribution and deployment option, while delivering the same enterprise-grade features and performance that they expect from SQL Server.