SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards

Each organization has its own coding standards and enforcement rules. It is sometime difficult for DBAs to change the code following code review, as it may affect many different layers of the application. In large organizations, many stored procedures are written and modified every day. It is smart to keep watch on all stored procedures, at frequent intervals, before code comes to final code review. Pre-code reviewing in this manner will save lots of time. I run a few scripts every day to check the status of all the stored procedures on our development server. Doing so gives me a good indication about which stored procedures are not up to coding standards.

SQL SERVER - Pre-Code Review Tips - Tips For Enforcing Coding Standards standard

Read my complete article SQL Server Pre-Code Review Tips

Read SQL SERVER Database Coding Standards and Guidelines Complete List Download

Reference : Pinal Dave (https://blog.sqlauthority.com)

, , ,
Previous Post
SQL SERVER – T-SQL Script to Add Clustered Primary Key
Next Post
SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation

Related Posts

2 Comments. Leave new

  • iT IS VERY GOOD SITE BUT if supposed we have to go for certification MCDBA , which is the best sit for downloding the dumps .

    Reply
  • iT IS VERY GOOD SITE BUT . i ot several god things from this site

    Reply

Leave a Reply

Menu