Useful SQL Server tools in Visual Studio

A less-known fact with Visual Studio is that, core SQL tool set is already included, but hidden, working behind the scenes.

This is convenient for developers because you no longer need to install a separate SQL Management Studio to access local/remote SQL server. For example, if you are developing Azure service using Visual Studio, it is easy-peasy to directly manipulate test data on the cloud through the VS GUI. Here is how to do it:

1. Use Ctrl-Q to search “SQL” or open menu item “New Query…”.


2. The connection dialog lists all available servers for you to choose: local / network/ Azure

2017-05-17 (1)

3. The opened new window tab resembles what you are used to in SQL Management Studio, Enjoy the query!



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s