May 29, 2023 at 8:58 pm
In Brent Ozar's list of links today, I learned that Microsoft has removed the Vulnerability Assessment tool from SSMS as of v19.1.
I recently started using it in my SQL Server environment and found it a great tool -- I was able to demonstrate to management why some of their security shortcuts were a bad idea. There doesn't seem to be any advance notice that this was going to happen -- the Microsoft Learning page is dated Feb 2023, so clearly this was a recent decision. My Google-fu finds nothing except for the SSMS release notes and Brent's announcement of same.
Does anyone know why this decision was made? Is there any similar tool out there?
May 29, 2023 at 10:27 pm
I would not consider it a big issue for now - you can still install prior versions of SSMS and keep using it.
July 10, 2023 at 4:45 pm
Erin discusses that the "SQL Server Vulnerability Assessment in SSMS does not consume findings from Defender for Cloud" here.
You can also scan for vulnerabilities with PowerShell.
July 10, 2023 at 6:38 pm
Erin discusses that the "SQL Server Vulnerability Assessment in SSMS does not consume findings from Defender for Cloud" here.
You can also scan for vulnerabilities with PowerShell.
Thanks for these links, very helpful!
The Powershell option looks to be the best for our particular scenario - I'll admit I didn't even think to look there.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply