blogs.conchango.com

  This issue caught me out today whilst putting together some build scripts for reference data. So I thought I’d share it. USE [tempdb] GO CREATE TABLE [dbo].[Table_1](       [Col1] [int] IDENTITY(1,1) NOT NULL,       [Col2] [char](1) NOT NULL ) ON [PRIMARY] GO delete from ...

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 ...