Not all T-SQL is created equally. Whether you're refactoring your code or you've inherited a database with some interesting behaviors, these articles will help you work through the issues and fend off future problems.
Getting started with test-driven database development
Test-driven development is one of the key methods for bringing in shorter release cycles to your software development, but the database can be a blocker. Here we show how to apply TDD to the database so it can be a full part of the devops release lifecycle.
Getting started with tSQLt for automated database testing
Testing with tSQLt is popular because it allows you to write tests natively in T-SQL, making it a natural fit for database developers. These articles will help you get started writing tests for your databases.