You have to learn to crawl before you learn to walk...but eventually we all want to run.
My recent series of articles on Test Driven Development with SQL Server was all about helping you learn to crawl. If TDD was a completely new concept for you, I wanted to take you through the process one step at a time. Once you understand the concept, though, you will soon find that the manual steps get tedious.
Having learned to walk, you now want to learn how to run.
Get Running with tSQLt
If you want to apply the TDD concept on a larger scale, you will want a framework that takes care of the tedious parts of the process.
Big thanks to reader B.C. for introducing me to such a framework for testing in SQL Server. Here's an excerpt from B.C.'s comment (emphasis added):
Is there a reason why you wouldn't want to use a testing framework like tSQLt?
To be completely honest, I had never heard of tSQLt before reading that comment. I have since looked at the project website and it looks like a great tool for unit testing SQL Server. I still haven't used the project, but it's got official backing from premier SQL Server toolmaker Redgate (which lends it some major credibility).
Here are some quick links to get started:
If you try it out (or if you're already a user), let me know your experience with it in the comments below.