blogs.conchango.com

I work predominantly in the data integration space and I suspect most of you reading this do too. One of the most common data integration scenarios is discovering what records in one table don't exist in another and I have previously written about how to achieve that in my tool of choice, SQL Server Integration Services. Recently another tool ...

I found this new article written by Sachin Rekhi on Database Unit Testing with Team Edition for Database Professionals. I think it's an excellent read.  The only thing I don't think it covers is what is not included in the product.  The most notable piece of Team System Unit Testing functionality that isn't included with DB Pro is Code ...

I recently put up a post with a unit test for check constraints validating all were defined with the NOT FOR REPLICATION option.  I thought it might be helpful to put up a post with tests for all the other object types that can have this option set. select object_id,name,is_not_for_replication from sys.foreign_keys where ...

Recently I had a need to create some unit tests for a change to the database that was under development.  I needed to change the database so that the NOT FOR REPLICATION option was set on all keys, constraints, indexes and triggers.  Following an agile engineering best practice I created a schema unit test for ...