Azure Data Studio

SQL Notebooks introduction and overview

May 20, 2019 by Rajendra Gupta

This article explains the SQL Notebook feature in Azure Data Studio along with the Markdown language to customize it.

SQL Code Snippets in Azure Data Studio

April 16, 2019 by Rajendra Gupta

This article will fully cover the code snippet SQL developer productivity feature in Azure Data Studio including a list of available snippets and examples of how to create custom code snippets

SQL Server Profiler in Azure Data Studio

December 28, 2018 by Rajendra Gupta

In this article, we will explore SQL Server Profiler in Azure Data Studio in detail including download and installation, execution plans, coding T-SQL and more.

SQL Server 2019 on Linux with Ubuntu and Azure Data Studio

November 29, 2018 by Rajendra Gupta

In the previous articles of this series on using SQL Server 2019 on Ubuntu, we have explored the following

SQL Server Data Import using Azure Data Studio

September 18, 2018 by Rajendra Gupta

Azure Data Studio is a new GUI based tool that works on Windows, Mac OS and Linux operating systems. It connects to SQL Server, Azure database, and SQL DW.

Getting started with Azure Data Studio (ADS); initial installation and configuration

August 14, 2018 by Prashanth Jayaram

Microsoft Azure Data Studio is a new GUI-based (vs CLI) lightweight tool for developing and managing your modern SQL databases. The tool resembles Microsoft’s lightweight code editor, the open source IDE Visual Studio Code in terms of functionalities and the UI in general. If you’ve used Visual Studio Code (or VS Code), you’d feel at home with Azure Data Studio. Azure Data Studio also integrates really well other products like Azure SQL Database and Data Warehouse has been made very simple. Azure Data Studio is a cross-platform tool available for Linux, Windows, and Mac to manage the SQL Server databases. You can go ahead and download Microsoft Azure Data Studio to try it out!

Backup and Restore operations with SQL Server 2017 on Docker containers using Azure Data Studio

July 19, 2018 by Prashanth Jayaram

In this 18^th article of the series, we will discuss the concepts of database backup-and-restore of SQL Server Docker containers using Azure Data Studio. Before proceeding, you need to have Docker engine installed and Azure Data Studio configured on your host machine.

This article covers the following topics:

Overview of Azure Data Studio (ADS)
How to use Azure Data Studio integrated terminal
Definition of Docker containers
Step by step instructions to initiate backup-and-restore of SQL Server 2017 Docker containers using the Azure Data Studio interface
And more…

How to install and configure Azure Data Studio for Windows

February 1, 2018 by Marko Zivkovic

Azure Data Studio is free, lightweight database development and operations cross-platform tool for private and commercial usage, that can be installed on Windows, macOS, and Linux for SQL Server, Azure SQL Database and Azure SQL Data Warehouse.

Azure Data Studio is built to simplify work of database developers, database administrators, and system administrators. Azure Data Studio boosts your productivity with smart code snippets, keyword completion, IntelliSense, source control integration, the ability to view and save results in CSV, Excel, JSON format, and the capability to organize and manage favorite database connections, etc. The first version of Azure Data Studio was released in November 2017.