Best Practices for Validating Applications With Database Architecture


We’ve been troubleshooting an application set up involving multiple databases, and this process has required more time than we initially expected. Some of the problems we faced were missing dependencies in the database and application, how the final project should look, and gaps in understanding how applications interacted with the database. What are some best practices to avoid this in the future?


In this tip, we’ll begin by looking at the end of building an application that uses a SQL Server database from the view of the back-end. We are excluding the middle-ware and front-end in this tip. Troubleshooting can consume over half of the development time and if we don’t prepare with a validation roadmap, it may consume more time. One pushback I see against writing validation queries or scripts is “it takes some time.” This is true, but when I compare environments which use validation scripts to environments that don’t, the former environments save 80-90% more time with a significant reduction in troubleshooting. Creating validation scripts prepares for the inevitable troubleshooting that occurs when creating applications.