Azure Data Studio

In this article, we’ll learn about Azure Data Studio, what it is, its different features and then initialize from the installation of the Azure Data Studio and get into deeper subject matter. This is the first part of multi-series of articles on Azure Data Studio.

Azure Data Studio 

Azure Data Studio is basically a database tool that is cross-platform routinely used by data engineers and professionals for both on-premises and cloud services throughout the operating system spectrum from Windows to macOS and Linux. There are numerous modern editor offerings with the Azure Data Studio from Code Snippets, IntelliSense, Integrated Terminal, Source Control Integration, and more. A great experience with charting of query results, customizable dashboards are supported built-in.

Features in Azure Data Studio

The Azure Data Studio provides features such as Query Editor which includes Chart Viewer, Live Query Stats, Exporting to CSV, XLSX, and JSON to more along with Shell features such as Dashboards and extensions, integrated terminal, object explorer, and many more. From Data Engineering to Database Administration to make sure of Backup and Restore, Flat File Import, Importing and Exporting DACPAC, the Azure Data Studio supports it all. Moreover, Azure Data Studio also offers some modern editor experience and features which are explained as follows.

Smart Code Snippets

Azure Data Studio makes it extremely easy to generate SQL Syntax through the SQL code snippets. From created databases to tables and view, stored procedures along with logins, users and roles, the smart SQL code snippets can do it all. Moreover, with the smart snippets, development and testing has never been easier to simply copy entire database just with the snippets. The INSERT and CREATE snippets perform this functionality. Furthermore, custom SQL code snippets can also be created.

Modern Code Editor 

The Azure Data Studio provides the offering of modern experience with the code editor which are enabled with IntelliSense, Code Snippets, Keyword Completion, Source Control Integration with Git, Code Navigation and more. The SQL Coding experience has never been this holistic and convenient where data professionals can now run on-demand SQL queries, organize their data connection, view and save in different formats like JSON, Excel and Text and edit them along with browse the database objects.

Database Dashboards 

Azure Data Studio enables data engineers, administrators and professionals to create dashboards that are rich and customizable in order to monitor and find out troubleshoot issues in any cases to prevent bottlenecks in performances in databases.

Integrated Terminal

Powershell, Bash, bcp, ssh, sqlmd – you name it, Azure Data Studio provides you with the range or command line tools. Pick your favourite from inside the Azure Data Studio user interface.

How to Install Azure Data Studio in Windows?

The Latest Version Azure Data Studio 1.33.0 which was released on Oct 27, 2021 can be downloaded for numerous platforms in different way from basically recommended user installer to system and .zip and .tar.gz file installation.

Step 1 

For Windows, you can have the User Installation from this Recommended Link. It is from the official website of Microsoft. Ie. https://go.microsoft.com/fwlink/?linkid=2176805 

Now, a file azuredatastudio-windows-user-setup-1.33.1.exe will have been downloaded to your system.

Step 2

Double Click the File. The following Setup Windows will run. Read the Agreement and Select Next.

Step 3 

Browse in the Location where you want to install Azure Data Studio and then Select Next.

Step 4 

Select if you want to Create a Start Menu Folder for Shortcut and incase of any other additional icons for Desktop and more.

Step 5 

Now, once everything is ready, Click on Install and the files will be extracted to the Destination Folder.

Step 6 

Once, the Setup is done, you’ll be presented with the option to Launch Azure Data Studio. Finally, Click on Finish.

Now, the Azure Data Studio will open for the first time in your system.

Conclusion 

Thus, in this article, we learned about the Azure Data Studio. We learned what it is and dived into the various features and functionality it supports. Thereafter, we learned the process to install it in Windows. This is primarily the first step to numerous other learnings that’ll be accessible to you on Azure Data Studio from my article that’ll follow in the days to come. In the follow-up articles, we’ll learn to connect to Azure SQL Database with the Azure Data Studio, learn to manage various servers, databases, preview other features of Azure Data Studio, experimentally learn about the Code Snippets discussed above in this article, and more.