I have to admit that I am not very impressed yet with the current version of Microsoft’s Sql Server tools. Sql Server Management Studio (SSMS) seems to be a bulky application with reduced functionality from the previous version. My aversion to SSMS let me to find a lightweight replacement for the good old Sql Query Analyzer.
Recently I have run across a couple of add-ins for SSMS, thanks to The Daily Grind, which have increased the functionality a bit to a degree where I am becoming more apt to use it.
CRUD Stored Procedure Generator generates the SELECT, INSERT, UPDATE and DELETE stored procedures for a selected table.
Enisly Add-in generates INSERT scripts for the data in a selected table similar to the way you can do it in Firebird and MySQL.
Bravo to the authors of these add-ins!