Sheen Space

Useful SQL Server tools in Visual Studio

leave a comment »


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…”.

Capture

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!

Capture

Advertisements

Written by Ying

17/05/2017 at 15:42

Posted in Programming

Tagged with

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: