Code review checklist and Secure best practices for SQL, SSIS

venkatesh padmanabhan 181 Reputation points
2020-09-02T11:52:17.997+00:00

HI.
Is there a document for : Code review checklist for SQL, SSIS and Secure best practices for SQL, SSIS ?

Could anyone please point to these ?
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.
12,690 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,451 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,891 Reputation points
    2020-09-03T01:54:40.91+00:00

    Hi venkatesh ,

    1.Code review checklist for SQL, SSIS
    SQL: SQL Server Code Review Checklist for Developers
    SSIS: Checklist for testing and reviewing SSIS packages

    2.Secure best practices for SQL, SSIS
    SQL: Top 10 security considerations for your SQL Server instances
    SSIS: Security Overview (Integration Services)

    Best Regards,
    Mona

    ----------

    If the response is helpful, please click "Accept Answer" and upvote it.

  2. Monalv-MSFT 5,891 Reputation points
    2020-09-04T06:12:05.277+00:00

    Hi venkatesh,

    Please refer to the following links:
    Download SQL Server
    Download SQL Server Management Studio (SSMS)
    Download SQL Server Data Tools (SSDT) for Visual Studio

    Best Regards,
    Mona

    ----------

    If the response is helpful, please click "Accept Answer" and upvote it.