Microsoft doesn’t provide macro guidance for naming convention, however, sometimes it is useful to have a place to start. Also, there are times when flexibility with naming conventions are necessary. So, here is a quick set of SQL Server naming conventions, which may be helpful if you find yourself working with a customer who doesn’t have an established set of naming convention standards and you need to assemble a set fast.
Basic SQL Server Object Naming Convention Guidance
Each project will have its own schema.
Schema represents the project
First letter of each word in table/Column starts with Uppercase.
Put Underscore(_) between words of table/Column name
Peer code review happens during the development phase and focuses on the overall quality and compliance to standards of code and configuration artifacts. However, the hard part of performing a Peer code review isn’t, performing the review, but rather to achieving consistency and thoroughness in the review. This is where a checklist can contribute significantly, providing a list of things to check and providing a relative weight for the findings. I hope this template assists with your DataStage job review process.
A peer review is an examination of a Software Development Life Cycle (SDLC) work product by team members, other than the work Product’s author, to identify defects, omissions, and compliance to standards. This process provides an opportunity for quality assurance, knowledge sharing, and product improvement early during the SDLC life cycle.