https://developerpublish.com/sql-server-101-how-to-add-a-column-with-a-default-value-to-existing-table/
SQL Server 101 - How to add a column with a default value to existing table ?