SSMS 17.4 has been released


The SQL Server Management Studio became a standalone product that has a separate release cycle from the SQL Server itself. I think this is a good direction, as the SSMS can be developed now in much faster pace and meet the demand for features more timely.

The recent version 17.4, announced a few days ago, contains a number of bug fixes, improvements and minor updates, but the most prominent feature is the Vulnerability Assessment report.

The report scans your database and detects any potential security issues you might have introduced. It is a useful addition to the tool belt of a DBA, but also developers, QA testing teams and devops teams can use it to ensure that they design, test and deploy safe databases. 

SQL Vulnerability Assessment

 The utility allows you also to save a baseline of your security data, so that you can compare it with subsequent runs of the report to detect any anomalies that might have been introduced to the database by developers for example.

Here are two links that you can follow to learn more about the utility.

SQL Vulnerability Assessment article on Microsoft Docs site.

What's new in SSMS 17.4: SQL Vulnerability Assessment Technet blog post, with a Channel 9 video showing the utility in use.

Well worth having a look - you might be surprised by your own database!

 


SelectCompare can compare your data as long as you can connect to your data source and write a SELECT query. That's easy!

Write your queries with filters and aggregations and receive the comparison results in no time. Reuse the queries and comparison definitions - save time!

Try SelectCompare today!


Featured Products



Leave a comment


Please note, comments must be approved before they are published