SQL Antipatterns, Volume 1

Solution: Establish a Big-Tent Culture of Quality

Quality is simply testing to most software developers, but that’s only quality control—just a part of the story. The full life cycle of software engineering involves quality assurance, which includes three parts:

1. Specify project requirements and deliverables clearly and in writing.
2. Design and develop a solution for your requirements.
3. Validate and test that your solution matches the requirements.

You need to do all three of these to perform QA correctly, although in some software methodologies, you don’t necessarily have to do them in that order.

You can achieve quality assurance in database development by following best practices in documentation, source code version control, and testing ...