Wouldn't it be great to cut the time it takes to unit test T-SQL stored procedures? Well, now you can! You can automate your testing by using nothing more than Query Analyzer and a little T-SQL code. Here's the solution in four easy-to-implement parts.
In managing a database or sometimes numerous databases, we often get caught up in the day-to-day maintenance and lose sight of the other principles we know are critical to ensuring optimal performance. Here’s a quick refresher....More