The new version of SSMS takes advantage of the new language services that the team has been working on for so long now.  So far it’s actually looking pretty good.  You can finally refactor columns throughout all of your code because the language service comes directly from the engine it knows everything about the code you’re looking at.  It’s more of a dev feature, but plenty of DBAs will find this useful as we all wind up doing dev anyway. 

There’ll be more on that in the future, but I just wanted to write this blurb to let everybody know that the language service is coming along.  This is the first real step in bringing us a much better intellisense.  Does that mean you’ll no longer need Red-Gate’s tool?  No, because SSMS still won’t format your code for you or do some of the other cool things SQLPrompt will do.  Things like * expansion, and uniform table aliases are just 2 of the things Red-Gate brings to the table.  Unfortunately for them though, the new SSMS will start to close the gap so they’ll have to come up with something else if they wanna stay in that game.