If you are developing an application that has a SQL Server database as backend, then during development you probably will have Microsoft Visual Studio 2010 and Microsoft SQL Server Management Studio open. The free SSDT Power Tools Microsoft Visual Studio 2010 extension enables me to do most of the tasks I did using Microsoft SQL Server Management Studio by using the SQL Server Object Explorer in Microsoft Visual Studio 2010.
First make sure the SQL Server Data Tools are installed: http://msdn.microsoft.com/en-us/data/hh297027
To install the SSDT Power Tools, open Microsoft Visual Studio 2010 > Tools > Extension Manager > Online Gallery
This includes showing execution plans:
Managing Server logins and Database users:
Executing, debugging and showing the code of stored procedures on my SQL Server LocalDb instance:
