The AWS Toolkit for Visual Studio Code is an open source plug-in for the Visual Studio Code that makes it easier to create, debug, and deploy applications on Amazon Web Services. With the AWS Toolkit for Visual Studio Code, you will be able to get started faster and be more productive when building applications with Visual Studio Code on AWS. The toolkit provides an integrated experience for developing serverless applications, including assistance for getting started, step-through debugging, and deploying from the IDE.

Nuget Gallery provides a GUI similar to the full Visual Studio. How To Use: Install Nuget Gallery from extension marketplace. Launch from the menu bar View Command Palette or ⇧⌘P (Ctrl+Shift+P on Windows and Linux). Type Nuget: Open Gallery. The GUI above is displayed. You can filter just like in regular Visual Studio. Debugging Visual Studio extensions works like debugging any kind of project, as our final product is a Visual Studio extension so when we push F5 it is going to open a new Visual Studio window simulating to have the extension installed as follows. Here are a few particularly popular Visual Studio Code extensions and themes that you may find both fun and helpful. Rainbow Brackets. Add some fun into your editor with 🌈 Rainbow Brackets! This Visual Studio Code extension provides rainbow colors for round brackets, square brackets, and curly brackets.

Install Source Code User Guide

Get started fast

Select a quickstart serverless application template.

Click to enlarge

Develop serverless applications easily

Set breakpoints and debug serverless applications locally.

Click to enlarge

Deploy from the IDE

Deploy your serverless application in a few clicks.

Click to enlarge

What's new

AWS Senior Developer Advocate James Beswick blogs about how to create, debug, and deploy serverless applications with the AWS Toolkit for Visual Studio Code.

Read our announcement post on the AWS Toolkit for Visual Studio Code

Join the DZone community and get the full member experience.

Join For Free

Writing SQL queries is typically done with SQL Management Studio (SSMS). However, this tool is a bit of a beast, so let's look at how you could use Visual Studio Code instead.

Visual Studio Code is a free text editor — but it is so much more than just a text editor. Let's see how. (By the way, VS Code can be downloaded from here.)

To work with SQL Server, download the MS SQL extension. Press CTRL + SHIFT + P, select Install Extension, and type mssql.

Intellisense in Visual Studio Code is brilliant — better than SSMS. Let's look at how to get it all set up.

Visual Studio Code Extension Development

Create a new file and set the language type to SQL (press CTRL + K + M).

Open the command palette with CTRL + SHIFT + P and type SQL to show the MS SQL commands. Select the Connect command.

Then, select Create Connection Profile. This creates a profile to connect to your SQL Server. Follow the prompts to get it all set up.

Look in the bottom right corner of the status bar and you should see that you are connected!

Now, if you type sql, you will see a long list of SQL code snippets that you can use:

Choose a snippet to create and edit it as required. When you are happy, press CTRL + SHIFT + E to execute.

This is basically all there is to it! However, this is an incredibly powerful way of working; the Intellisense instantly tells you what database objects you can use in your query, and there is a wealth of different snippets you can use.

When returning data, you get a similar view to SSMS, but you can save as Excel, CSV, or JSON.

SSMS is a very graphical way of doing things. You can double-click a table and see its columns or indexes. VS Code relies on T-SQL commands, but you have access to exactly the same information.

Visual Studio Sample Code Download

For more information about VS Code and the MS SQL extension, check out this documentation.

Published at DZone with permission of Simon Foster, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.