Just to quickly answer the final question:
So, is anyone doing CI with SQL server yet?
These days, it seems everyone is doing CI with SQL Server. Redgate (sponsors of this forum) have a suite of products dedicated to just that. Just click the Redgate link at the top right of any page on this forum then click on DLM. (Disclaimer: I do not work for Redgate and we are not using DLM where I work)
Redgate are hardly alone in this space! There are plenty of other players and lots of home-grown solutions.
Gerald Britton, Pluralsight courses