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 table
It’s in preview status and requires version 1.19.0 (this month’s version) of Azure Data Studio at a minimum.