First look at SSMS Vulnerability Assessment

Long awaited version of SSMS 17.4 was released few days ago and with it - new shiny Vulnerability Assessment. I decided to include it in my Autonomous Databases presentation and spend some time with it. Definitely useful but … Disappearing checks - high risk My first VA scan contained 52 tests results which is 12 more than in Azure Sql DB version (changed from 39 to 40 recently). Next scan that I run for different database showed just 50 tests - number mysteriously decreased by 2.

Workload Generator

Workload Generator tSql gist to generate all possible queries based on foreign key constraints.