Step 3 seems to have issues

UPDATE tl_2008_us_state

SET BoundaryGeog = GEOGRAPHY::STGeomFromWKB(BoundaryGeom.MakeValid().STAsBinary(), 4326)

WHERE NAME NOT IN('Massachusetts', 'New Mexico', 'Wyoming', 'Montana', 'Texas', 'North Carolina', 'Arizona', 'Tennessee', 'Utah')

Msg 4121, Level 16, State 1, Line 1

Cannot find either column "BoundaryGeom" or the user-defined function or aggregate "BoundaryGeom.MakeValid", or the name is ambiguous.