All about SQLServer: SQL Vulnerability Assessment for Azure SQL Database and on-premises SQL Server

SQL Vulnerability Assessment (newly introduced feature in SSMS) can help to discover, track,

and remediate potential database vulnerabilities. We can use it to proactively improve database security.

From SSMS - > Object Explorer :

Expand Databases, right-click a database, point to Tasks, select Vulnerability Assessment,

and click on Scan for Vulnerabilities…

We can run a scan that checks for server-level issues by scanning one of the system databases.

All about SQLServer