Announcement: New Features and changes to SQL IaaS Agent Extension
SQL Server on Azure Virtual Machines is powered by the SQL IaaS Agent extension which provides many features that make managing your SQL Server easy. This blog will discuss new features and changes we’ve recently released in this extension. Retiring Modes: SQL IaaS Agent extension traditionally used to have two modes, Lightweight and Full mode. In the Lightweight mode, customers were able to do license management, whereas the Full mode offers all the other manageability features. This differentiation of modes made it tough for customers to adopt the manageability features that the SQL IaaS agent extension offers. To address this, starting today there will be no management modes for SQL IaaS agent extension. Going forward, customers register with the SQL IaaS Agent extension and enable the required features they would like for their SQL Server on Azure virtual machines. Based on the features selected, the SQL IaaS agent extension would assume only the permissions required on the SQL Server to enable those features. If no features are enabled, there will be no Windows services installed. Upon enabling a specific feature, the extension will create Windows services to perform the tasks required by the feature. Licensing mode changes do not require any Windows services and can be managed from the SQL VM (virtual machines) portal immediately after the SQL IaaS Agent extension is enabled. Announcing General Availability of AAD authentication for SQL Server on Azure VMs: AAD authentication is one of the most important features that is introduced in SQL Server 2022. Enabling this feature is easy when you run your workload on Azure VMs. Customers simply need to follow 3 steps to get this enabled. Choose the managed identity they would like to use to enable AAD authentication. Both system and user-managed identities are supported. Make sure the selected managed identity has the necessary permissions in AAD. Please follow the instructions mentioned here to give the required permission. Click on Apply to enable AAD authentication. With GA, Azure also will check whether required permissions were assigned to the managed identity selected before going ahead and starting the deployment, hence customers do not have to wait for the deployment to complete to validate whether the specified managed identity has the correct permissions. Auto upgrade of the SQL IaaS Agent extension: SQL IaaS agent extension adds new features and improvements over time and customers currently get these features through lazy upgrades. A lazy upgrade occurs whenever a customer interacts with SQL VM portal or through CLI. Customers often want to keep extensions in all their VMs on the same version. This new auto upgrade option will keep all the SQL VMs on the same version of extension by upgrading extension to the latest version every month. This is now a default feature for all the new VMs being deployed in Azure. VMs that are already deployed can take advantage of this by going to the SQL VM portal and going to SQL IaaS Agent Extension Settings page.
Cumulative Update #18 for SQL Server 2022 RTM
The 18th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model, please visit: CU18 KB Article: https://learn.microsoft.com/troubleshoot/sql/releases/sqlserver-2022/cumulativeupdate18 Starting with SQL Server 2017, we adopted a new modern servicing model. Please refer to our blog for more details on Modern Servicing Model for SQL Server Microsoft® SQL Server® 2022 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?familyid=105013 Update Center for Microsoft SQL Server: https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updatesSQL Server 2022 for RHEL 9 and Ubuntu 22.04 is now Generally Available (GA)
We are happy to announce that Starting CU 10 release for SQL Server 2022 , SQL Server 2022 on RHEL 9 and Ubuntu 22.04 is now generally available (GA), meaning you can run production workload on SQL Server 2022 deployed on Red Hat Enterprise Linux (RHEL) 9 and Ubuntu 22.04. For SQL Server 2022 on RHEL 9, the SELinux integration that enables you to run SQL Server 2022 on RHEL 9 as confined application is also now generally available. If you've had the preview packages installed previously, we recommend that you please uninstall the preview bits and upgrade to SQL Server 2022 GA packages available at the following repos, for steps on how to update repos refer the Configure repositories for installing and upgrading SQL Server on Linux - SQL Server | Microsoft Learn documentation. For RHEL 9 use the repo: https://packages.microsoft.com/config/rhel/9/ For Ubuntu 22.04 use the repo: https://packages.microsoft.com/config/ubuntu/22.04/ For further details on getting started with the installation of SQL Server 2022 on RHEL 9 refer: RHEL: Install SQL Server on Linux - SQL Server | Microsoft Learn & for SQL Server on Ubuntu 22.04 refer: Ubuntu: Install SQL Server on Linux - SQL Server | Microsoft Learn SQL Server 2022 container images on RHEL 9 & Ubuntu 22.04 also generally available: SQL Server 2022 on RHEL 9 and Ubuntu 22.04 are also available as container images and generally available (GA). It is easy for you to get started. Like always, you can use both podman and/or docker tool. To pull and run the production ready SQL Server 2022 images on RHEL 9 use the tag: 2022-CU10-rhel-9.1 #Pull the image podman pull mcr.microsoft.com/mssql/rhel/server:2022-CU10-rhel-9.1 #Run a container using the above image podman run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourP@ssword>' -e 'MSSQL_PID=Developer' -h sql22rhel9 --name sql22rhel9 -p 1433:1433 -d mcr.microsoft.com/mssql/rhel/server:2022-CU10-rhel-9.1 To pull and run the production ready SQL Server 2022 images on Ubuntu 22.04 use the tag: 2022-CU10-ubuntu-22.04 #Pull the image docker pull mcr.microsoft.com/mssql/server:2022-CU10-ubuntu-22.04 #Run a container use the above image docker run -e 'ACCEPT_EULA=Y' -e 'MSSQL_SA_PASSWORD=<YourP@ssword>' -e 'MSSQL_PID=Developer' -h sql22ubu2204 --name sql22ubu2204 -p 1433:1433 -d mcr.microsoft.com/mssql/server:2022-CU10-ubuntu-22.04Cumulative Update #4 for SQL Server 2022 RTM
The 4th cumulative update release for SQL Server 2022 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model, please visit: CU4 KB Article: https://support.microsoft.com/en-us/help/5026717 Starting with SQL Server 2017, we adopted a new modern servicing model. Please refer to our blog for more details on Modern Servicing Model for SQL Server Microsoft® SQL Server® 2022 RTM Latest Cumulative Update: https://www.microsoft.com/download/details.aspx?id=105013 Update Center for Microsoft SQL Server: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/latest-updates-for-microsoft-sql-server
