SQL Server Extension for Visual Studio Code

In this episode, Robert is joined by Eric Kang, who shows the SQL Server extension for Visual Studio Code. With this extension, you can connect to SQL Server, Azure SQL Database and SQL Data Warehouses, create and manage connection profiles and most recently used connections, write T-SQL scripts with IntelliSense and Go to Definition, execute your scripts and view results in a simple to use grid, and save the result to json or csv file format and view in the editor.

Resources:

[FireMikeBrown]

24:40 You were the only source that showed how to properly create a connection profile after a fresh install. Spent way to long looking for it. Thanks!

[jakubpradeniak]

Official Microsoft Visual Studio channel - pesenting on MAC; analogicaly when I was on new IOS presentation some years ago, the guy run powerpoint on emulated Win10 from his Macbook PRO :D

[scottbass]

The video is ok-ish, but I found it rambling and "all over the place". 15 mins in and I'm *still* waiting for Eric to start talking about the SQL Server extension, which is the title and subject of this video.

[greenspand]

Awesometalk. Thx for sharing. Really love Visual Studio Code and the direction is going.

[rommelzapanta]

I have just started using VSCode for my SQL Coding and I love it. But I could not figure out how to insert all the fields from a table into my SELECT statement? Similar to dragging the “Columns” folder from the table in MSSQL Mgt studio.

[iancarr]

Subtitles are wonderful! "Developer working locally" is translated as "...unluckily!

[thunde]

yes, the Pick definition like variable, and

[Justhohe]

Is there any extension to connect to a sybase database?

[anchalsingh]

It's improving..sir...delta plzzz

[Ash]

Can you man execute query and connect to database to a key or key combination?

[ReynaldAdolphe]

Anyone else getting this error? : error DOTN
ET1012: The reference assemblies directory was not specified. You can set the location using the
environment variable.

[EL-qozl]

Interesting video. But I did not find the one thing I was looking for, which was how to connect via AD (not Azure).

[bgrahangkky]

Utanmanız yok mu Microsoft olarak apple pc kullanıyorsunuz! 0:19

[edu]

It's so ODD to see someone using MACBOOK but talking about Microsoft software...

[James-sclz]

I love how so many developers use apple machines. It must piss Microsoft off a lot which is wonderful

[chefmo]

please i want to learn how will help me

[FadiFakhouri]

STOP TALKING! get on with the information! Please let us just have the technical guys giving us the information. Jump to 10:01 for the real information!