December, 2006
Automate Your Security Audits
Start with this stored procedure for tracking 15 commonly monitored checkpoints--and build on it by adding your own checks.
SQL Server Magazine
|
May, 2006
Build Your Own Automated Security Systems
Discover the keys to effective database-security testing: a well–thought-out testing plan, consistent reporting and bug-checking, and the use of scripts to automate testing tasks.
SQL Server Magazine
|
June, 2005
Pep Up T-SQL Procedure Testing
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.
SQL Server Magazine
|
September, 2004
Integration Testing
Piece by piece, then all together, test your application code by following this simple plan.
SQL Server Magazine
|
January, 2003
Unit-Test Your Stored Procedures
You're the one on the front lines; who better to drill your code to peak performance? Here's why and how to put stored procedures through their paces.
SQL Server Magazine
|