Study your Data

From SQL Guatemala, we wish you a happy new year 2018.  We hope this new year brings you joy and zero: production outages, corrupted databases, corrupted backups, full disks, and failed nodes hehehehe! Also we wish for you all your desired certifications, your new software licenses and tools you need, no dumb users with sa privileges, and of course... a salarial raise! Best wishes for all...

A very interesting feature was recently added to SQL Server Management Studio 17.4 (SSMS): The new SQL Vulnerability Assessment. What is it? SQL Vulnerability Assessment or VA, is a lightweight, easy to use tool to identify and help to remediate potential security vulnerabilities, these rules are based on Microsoft's best practices. This reports executes at database level. VA is included on SSMS 17.4 and it works for SQL Server 2012 and later. Using VA From the Management Studio,connect to the SQL Server database instance. Right click on the database to analyze and select Tasks > Vulnerability Assessment > Scan for vulnerabilities... Select the path to store the report and click OK. After a moment, the report is show. You can now see all the vulnerabilities encountered with a brief explanation and a suggested fix for each one: Failed rules Passed rules   Baseline You can also approve results to be marked as passed using the approve as