Actually, I can remember being where you are right now. Cursing the changes that seem useless. Most of the stuff is backward compatible so you shouldn't be dead in the water, but as you slowly get better at Yukon, you'll start seeing the benefits.

I praise the devs for the new Create Login syntax. They're unifying the syntax for these things and it's wonderful. Now you dont have to try to remember the exact name of an SP to do something you want. It's all the same. Create Table, Create Procedure, Create Trigger, Create Login... see, it all fits.