When updating a table with a new column first I'd do something like:
alter table myTable add isGreat bit null
then fill that column with a value like so:
update myTable set isGreat = 0 where IsConfirmed IS NULL
Turns out there's a shortcut to that sucker:
alter table myTable add isGreat bit null default 0 with values;