This is a very interesting article. As far as I know, none of our SQL objects are in source control. Well, except for what we, the developers, write in order to create tables and views. But there's no migration, nothing. All that's there is the latest CREATE TABLE or CREATE VIEW command.
I've got a question about Red Gate's SQL Source Control. Does it work with TFVC? Personally, I prefer to use Git, but my employer has settled on TFVC, so either SQL Source Control works with TFVC or it won't be considered.