Review tool to check security risks, code review

Question

Hi.

Is there a Microsoft recommended review tool to check security risks, code review for SQL, SSIS?

Thanks

Answer 1

Hi @venkatesh padmanabhan ,

Is there a Microsoft recommended review tool to check security risks, code review for SQL, SSIS?

Security: SQL Vulnerability Assessment

Code Review: SSIS Code Check

Others may be helpful: Free SQL Tools

If you are going to code review, this checklist may be helpful: sql-server-code-review-checklist-for-developers

Reference this for error handling: how-to-implement-error-handling-in-sql-server

If the reply is helpful, please do “Accept Answer”.
BR,
Mia

Answer 2

There is the Vulnerability Assessment tool which is built-in to recent versions of Managment Studio.

Microsoft also has services in Azure that track attacks. Google for "Advanced Threat Protection".

I should add that these answers are not a perfect match with what you are asking for. These tools more look at server configuration and will not review code.

Answer 3

Hi @venkatesh padmanabhan ,

Is the reply helpful?

If the reply is helped,please click "Accept Answer" and upvote.
BR,
Mia