The following query creates a table namely Student in BiztalkLookupDB. If you click “Explain” at the top, you will see the graphical query plan. This will run the query and return the results and messages panes below the query. By default, intellisense is enabled.Īfter writing the query we can click “Run” at the top. I could also do this in the File menu. We can start typing a query, like we would do in SSMS. On my Dashboard, I’ll click the New Query button. The main purpose behind ADS is to give you a query tool that consistently works on all platforms. If you click this, you see a list of extensions by Microsoft, other companies, and various individuals. The Extensions menu contains various add-ons for ADS, similar to add-ons for Visual Studio Code. Clicking Explorer on the left pane opens a different list For example, if I click the Servers button, it closes my connection list. On the far left is the menu column, which contains these items:Įach of these can be clicked and it will open or close the middle column, with details for that menu item. The dashboard takes up one of these areas. There are the tabbed areas where you work, which are the large areas. There are three sections in Azure Data Studio. On the left, we’ll see the server groups and then a set of menu icons on the far left. Let’s Click on Connect now to connect to the server. ADS will open a connection and give me a dashboard on the right side of the screen. If we select the “Add new group” option a new dialog will open where we can enter a name, description, and choose a colour for the connection. A drop down at the bottom of the connection dialog has options for picking an existing group or adding a new one. We can specify the server details, Authentication type as shown below to connect to a server.ĪDS also allow us to group servers. Once the wizard completes the installation, by default this will launch ADS when you click Finish. The one place to perhaps change the defaults is on this page.
Next, find the download file for your operating system.Ĭlick on Next for the Setup Wizard and go with the default options. You can browse to the download page for Azure Data Studio at: . The first step in getting started is to download the tool.
This blog post will examine how to get started with this tool and connect to your SQL Server instances. Microsoft decided to fork this tool and build a cross platform data management tool.Īzure Data Studio (ADS) is the result.
Porting SSMS would have been a very large project, and potentially not even possible, but Visual Studio Code was a development GUI that already ran on Windows, Linux, and macOS.
When SQL Server was ported to the Linux operating system, Microsoft realized that they needed a tool that could be used to work with SQL Server instances on that platform.
Getting Started with Azure Data Studio (ADS)