http://www.sqlmag.com/authors/author/author/5777762/rss/5777762en-USFri, 25 May 2012 09:11:25 GMTFri, 25 May 2012 09:11:25 GMThttp://www.sqlmag.com/article/auditing/automate-your-security-auditsStart with this stored procedure for tracking 15 commonly monitored checkpoints--and build on it by adding your own checks.]]>Dan SawyerMon, 18 Dec 2006 00:00:00 GMThttp://www.sqlmag.com/article/auditing/automate-your-security-auditshttp://www.sqlmag.com/article/tsql3/build-your-own-automated-security-systemsDiscover 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.]]>Dan SawyerTue, 23 May 2006 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/build-your-own-automated-security-systemshttp://www.sqlmag.com/article/testing5/pep-up-t-sql-procedure-testingWouldn’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.]]>Dan SawyerWed, 22 Jun 2005 00:00:00 GMThttp://www.sqlmag.com/article/testing5/pep-up-t-sql-procedure-testinghttp://www.sqlmag.com/article/stored-procedures/integration-testingPiece by piece, then all together, test your application code by following this simple plan.]]>Dan SawyerTue, 21 Sep 2004 00:00:00 GMThttp://www.sqlmag.com/article/stored-procedures/integration-testinghttp://www.sqlmag.com/article/tsql3/unit-test-your-stored-proceduresYou’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.]]>Dan SawyerWed, 22 Jan 2003 00:00:00 GMThttp://www.sqlmag.com/article/tsql3/unit-test-your-stored-procedures