SQL Code Analysis
Published 29 October 2019
SQL Prompt comes with a list of static code analysis rules you can run on your queries, as you review them, or as you type them. Static Code analysis parses the code as a compiler would, but with the objective of checking the syntax, rather than compiling it. For databases, static analysis is very useful in checking routines, such as functions and procedures, for 'code smells' that require code itself to be analyzed.
The rules encourage good coding practices, and alert the team to code that, for example, flouts code style rules, uses deprecated syntax, demonstrate poor design (such as missing clustered indexes) or could at some point cause performance problems, unpredictable behavior, or even security vulnerabilities. This helps the team detect and correct issues early in the development cycle, increasing the reliability of database builds. It will allow the Governance and Operations team visibility into production readiness of the code, warning them of security loopholes and vulnerabilities, reducing the delays between build and deployment.