Introducing SQL Assessment API (Public Preview)
SQL Assessment API is a new mechanism to evaluate configuration of your SQL Server for best practices. The API methods are used by means of a SQL Server Management Object (SMO) extension and new cmdlets in SqlServer PowerShell module. API is delivered with a ruleset that is highly customizable and extensible. It can be used to assess SQL Server versions 2012 and higher, both on Windows and Linux.Released: SQL Server Assessment Extension for Azure Data Studio (Public Preview)
SQL Server Assessment Extension for Azure Data Studio provides a user interface for evaluating your SQL Server instances and databases for best practices. It uses SQL Assessment API to achieve this. In this preview version, you can: - Assess a SQL Server or Azure SQL Managed Instance and its databases with built-in rules (Invoke Assessment) - Get a list of all built-in rules applicable to an instance and its databases (View applicable rules) - Export assessment results and list of applicable rules as script to further store it in a SQL tableSQL Server Cumulative Updates (CU) through the end of calendar year 2020
This has been a tough year and we are supporting our teams to spend time with their families. Due to minimal operations over the upcoming holidays and new year, we will not be releasing any additional SQL Server Cumulative Update (CU) releases for the rest of calendar year 2020. Applicable to SQL Server mainstream support products: SQL Server 2019, SQL Server 2017, and SQL Server 2016 Service Pack 2 (SP2). If you have a product issue and you have confirmation a specific fix is scheduled for the next CU release, we encourage you to work with our support channels as documented in our help and feedback page.
Cumulative Update #7 for SQL Server 2019 RTM (Removed)
There is a known issue with using database snapshots in SQL Server 2019 CU7, and it was removed from the Download Center, the Microsoft Update Catalog, and Linux repositories. Note that using DBCC CHECKDB is also affected because it generates a database snapshot. This issue will be fixed in the upcoming SQL Server 2019 Cumulative Update (CU).Released: SQL Assessment API (GA)
SQL Assessment API is a new mechanism to evaluate configuration of your SQL Server for best practices. The API methods are used by means of a SQL Server Management Object (SMO) extension and new cmdlets in SqlServer PowerShell module. API is delivered with a ruleset that is highly customizable and extensible.SQL Server 2016 SP3: Last Service Pack for SQL Server
The 3 rd and final Service Pack release for SQL Server 2016 is now available for download at the Microsoft Downloads site. This is also the last Service Pack for any SQL Server version, as previously announced in the Modern Servicing Model for SQL Server.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 Release Candidate 0 is now available on Linux
Following our release cadence, we are pleased to announce the release of SQL Server 2022 Release Candidate 0 (RC 0) for Linux. To download the latest RC 0 container images, please use the ‘2022-latest’ tags for both RHEL and Ubuntu based container images. Please see SQL Server 2022 public preview is now available on Linux blog for detailed instructions on how to get started with the container images. To install the SQL Server 2022 RC 0 packages, follow these steps: For RHEL based installations see RHEL: Install SQL Server on Linux - SQL Server | Microsoft Docs For Ubuntu based installations refer: Ubuntu: Install SQL Server on Linux - SQL Server | Microsoft Docs In addition to the new features added in RC 0, this release for Linux now supports the following features. Azure Synapse link - The integration runtime (IR) cannot be installed on Linux environment, so you will have to run the IR on a Windows based machine that is on the same network as the Linux machine running the SQL Server instance to which it connects. For more information, see Known limitations and issues with Azure Synapse Link for SQL (Preview) - Azure Synapse Analytics | Microsoft Docs. Azure Active Directory authentication (AAD) – SQL Server on Linux now includes AAD support. For the time being, SQL Server containers do not support this feature. For Distributed availability groups, changing REQUIRED SYNCHRONIZED SECONDARIES TO COMMIT is supported. For more information on the features supported, see : Editions and supported features of SQL Server 2022 Preview - Linux - SQL Server | Microsoft Docs, and for release notes, see Release notes for SQL Server 2022 Preview on Linux - SQL Server | Microsoft Docs.
