Ability to code analyse existing database (SPs, triggers, etc.)
SQL Prompt provides the ability to improve your on-the-fly coding according to standards and best practices defined locally or within the organisation.
How about the ability to analyse an existing database and isolate problematic areas, code smells and provide not only recommendations but also the ability to refactor the database code based on rule-sets?
This would be really great and a time-saver to improve the code quality in the whole database.
Thanks, Jochen Kirstätter, MVP