Share via

Review tool to check security risks, code review

venkatesh padmanabhan 181 Reputation points
2020-09-02T12:02:02.857+00:00

Hi.

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

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,053 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. m 4,271 Reputation points
    2020-09-03T06:18:44.16+00:00

    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

    1 person found this answer helpful.
    0 comments
  2. Erland Sommarskog 103.2K Reputation points MVP
    2020-09-02T21:51:53.053+00:00

    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.

    0 comments
  3. m 4,271 Reputation points
    2020-09-04T01:29:18.783+00:00

    Hi @venkatesh padmanabhan ,

    Is the reply helpful?

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

    0 comments