Articles by ALEX KUZNETSOV

Close Those Loopholes: Lessons learned from Unit Testing T-SQL

Alex has done some pioneering work on the testing of stored procedures over four years, and has learned a great deal in the process. In this article, he spells out the lessons learned from a wealth of experience in Unit Testing T-SQL.

Yet Another SQL Strategy for Versioned Data

By Alex Kuznetsov

There is a popular design for a database that requires a built-in audit-trail of amendments and additions, where data is never deleted, but merely superseded by a later version. Whilst this is conceptually simple, it has always made for complicated SQL for...