Use correct SQL in migrations to not allow NULL for existing rows with default value.

[metaskills]

As my co-worker pointed out.

alter table add column blah blah default x WITH VALUES

[metaskills]

http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx