I’m in the porcess of migrating and upgrading all previous versions of SQL server instances to 2016 at this stage. I’ve started to read about SQL 2017 and cannot wait to test a few new features out.
Vulnerability Assessment (VA) is a new feature of SQL Server Management Studio (SSMS) 2017 builds. I’ve tried it as the SSMS installation is seperated from the SQL server isntallation. There are plenty documentation of VA on the web, Microsoft Docs has a good artical on it as well.
Let me sidetrack to Microsoft Docs for 2 seconds here, I found that not everyone knows that there is a dowload PDF button (see below)! It’s a great option for offline reading.
Back to VA, the tool is light and easy to use but its lacking some features such as export the result to PDF or Excel, it would be great if Database Administrators (DBAs) can run this as a schduled task, etc. I’m sure Microsoft is working on them as I publis this post! 🙂
I’m very interested in the Automatic Tunning and Indexing features for SQL 2017. I’ve listed some reading materials for these at the end of the post. These features obviously will make DBAs’ lives easier in the future but how much control are we willing to relinquish to machine learning? System administrators might be a thing of the past soon.