Session Spotlight

Write More Testable T-SQL

If you've worked with a legacy business application, you've probably encountered database stored procedures, and they've probably been a fragile, scary mess. They typically have hundreds of lines of procedural code with many branches, convoluted logic, and overloaded variables. And there's no way to test anything because running the procedure makes all sorts of changes. You might think that's just the way things are done in a database and there's no fixing it. But I can tell you there is a better way. You can move all of that logic into composable, testable components. You can test your code without risking any data modification. You can even quickly generate thousands of tests which will show the business exactly how your code will behave in every conceivable scenario. Once you experience SQL done right, you might even grow to like it.