I got pretty excited when I came across this. For all the back and forth about stored procedures / ad-hoc the thing that has been missing in the DBA world is a clean interface for DBAs with developers. I currently use database projects to version my stored procedures, but it's not all that elegant or impressive of a solution.
It seems like this is going to be addressed! It also allows for T-SQL unit testing which should be interesting. If Microsoft successfully pulls this off, does the whole argument about business logic in the classes vs stored procedures go away? Afterall, both a class and a stored proc exist as a file, and if they are now both in the solution and potentially you could "goto" the stored proc from the data layer code just like you could goto a class...
Food for thought.