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

 

image

 

This includes showing execution plans:

 

image

Managing Server logins and Database users:

image

 

Executing, debugging and showing the code of stored procedures on my SQL Server LocalDb instance:

image

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.