Management Studio is a monster. I was using for years and every so often someone would show me a feature I was totally unaware of that blew my mind.

Visual Studio also had "Database Project" which was amazing. Not seen anything like it. I think everyone moved over to using EF or Fluent Migrations but I loved the Database Projects.