Thanks for the article. We plan to ETL the CDC data on a nightly basis. Nevertheless, I'm put off by the fact that we can't add columns to tables without disabling/re-enabling CDC. Disabling of course drops the cdc_ table, so goodbye data.
It would be nice if CDC could pick up the new column. DDL changes like this can now be propagated to replication subscribers; it would be nice if CDC could as well.
And what is up with not being able to reindex a CDC-enabled table?