Azure Data Studio

Upgrade SQL Server Management Studio (SSMS) along with Azure Data Studio

October 20, 2021 by Rajendra Gupta

This article explains upgrading SQL Server Management Studio (SSMS) and Azure Data Studio (ADS) to their latest version with a single installation.

Migrating on-premises databases to Azure SQL Database in Azure Data Studio

June 23, 2021 by Haroon Ashraf

This article teaches how to migrate a lightweight on-premises SQL database to an Azure SQL database using Azure Data Studio.

Using the DB Snapshot Creator Extension in Azure Data Studio

June 8, 2021 by Haroon Ashraf

This article talks about the steps required to add and use the DB Snapshot Creator extension in Azure Data Studio.

Two ways to build SQL Database Projects in Azure Data Studio

February 18, 2021 by Haroon Ashraf

This article talks about the two standard ways of building SQL Database Projects in Azure Data Studio along with the simple steps of implementation.

Build a Google BigQuery report with Google Data Studio

December 25, 2020 by Frank Solomon

Introduction

In the two-part SQL Shack article, Build a Google BigQuery Resource, I showed how to build a Google BigQuery resource, and then link it to an Azure SQL Server resource. This article will expand on that first part, showing how to build a BigQuery report with Google Data Studio.

Link Google BigQuery resources into an Azure SQL resource

November 20, 2020 by Frank Solomon

In previous article Build a Google BigQuery Resource, we saw how to build a BigQuery resource, and then build a Google OAuth refresh token. In Part Two here, we’ll build an Azure SQL data resource, and then build, configure, and test the Azure Data Factory that will link the cloud resources we built.

Build a Google BigQuery Resource

November 12, 2020 by Frank Solomon

Introduction

We can rely on Azure SQL to build reliable, high-quality relational database solutions. In the cloud, Google offers BigQuery as a big data product that has large data capacities, and a standard SQL syntax. Although it can handle data manipulation, it works better as a data warehouse product because of certain product limitations. If we can integrate these products, they become even more useful. This two-part article will show how to link these products together. Part one here will show how to build a BigQuery resource, and then build a Google OAuth refresh token, or security key. Part two will show how to set up an Azure SQL data resource, and build, configure, and test the Azure Data Factory that will link those resources.

Develop your extensions for Azure Data Studio

October 20, 2020 by Rajendra Gupta

Azure Data Studio (ADS) is a popular cross-platform (Windows, Linux) tool for database professionals. It provides various useful features such as T-SQL editor, Visualizations, insights, Peek definitions, Notebooks, Git integration, extensions and more. Extensions add new functionality in the ADS. Microsoft provides several useful extensions. We have already covered few useful extensions in the Azure Data Studio category on SQLShack.

Working with Git components in Azure Data Studio

July 9, 2020 by Rajendra Gupta

This article gives an insight into the terms in the Git repository of Azure Data Studio. In the previous articles, we learned the following things:

Integrating Azure Data Studio with Git and GitHub

July 3, 2020 by Rajendra Gupta

In the last article, Source Control using Git in Azure Data Studio (ADS), we explored the following topics:

The requirement of Source control for SQL scripts
Git installation on Windows
Integrate Git in Azure Data Studio
Create Git repository, add SQL scripts, modify files, commit into source control
View different versions using the Git timelines

In this article, we will take a step forward and integrate Git installed locally on the GitHub.

Source Control using Git in Azure Data Studio (ADS)

July 2, 2020 by Rajendra Gupta

Azure Data Studio is a tool for both developers and database administrators with exciting features. You can install ADS on both Windows and Linux platforms. You can go through various Azure Data Studio articles on SQLShack to be comfortable with the tool and its features.

The SQL Server Assessment Extension for Azure Data Studio

June 30, 2020 by Rajendra Gupta

Azure Data Studio extensions enable adding new functionality for development and administrative tasks. It is an open-source functionality and allows Microsoft as well as third party extensions using Marketplace. We explored a few useful extensions in the Azure Data Studio category of articles.

Digging deeper into Azure Data Studio: Extensions and Azure SQL DB Development

June 24, 2020 by Ahmad Yaseen

In the previous articles listed below, we went through the Azure Data Studio tool, starting from the installation procedure, showing the purpose of each component, how to organize your connections, and develop the different types of SQL Server database objects using the interactive query editor in that data studio.

Digging deeper into Azure Data Studio: More code and less GUI

June 23, 2020 by Ahmad Yaseen

In the previous two articles, Starting your journey with Azure Data Studio and Developing your SQL Server database using Azure Data Studio, we introduced the Azure Data Studio tool by describing the main components of that data studio and showed how we can take advantages from it in developing and organizing the database related projects.

Developing your SQL Server database using Azure Data Studio

June 22, 2020 by Ahmad Yaseen

In the previous article, Starting your journey with Azure Data Studio, we put the first stone that helps you to be familiar with the Azure Data Studio and start using it to interact with your database objects.

Starting your journey with Azure Data Studio

June 19, 2020 by Ahmad Yaseen

In this article, we will introduce the Azure Data Studio in a way that makes it easy for you to start using it. Enjoy the reading!

Server and Database dashboards in Azure Data Studio

May 14, 2020 by Rajendra Gupta

Azure Data Studio (ADS) is an integrated, lightweight database development for supporting both on-premises and cloud databases. It can be installed on Windows as well as Linux operating system. I am assuming you are familiar with the SQL Server Management Studio. If you work on Linux based SQL Server instance, you can install only ADS in those systems. We can use integrated terminals to execute the PowerShell and Terminal sessions for the Linux system.

Create charts from SQL Server data using Azure Data Studio

May 13, 2020 by Rajendra Gupta

In this article, we will explore charts in an Azure Data Studio using data stored in SQL Server tables.

View Execution Plans in Azure Data Studio

April 24, 2020 by Rajendra Gupta

This article gives an overview of viewing execution plans in the Azure Data Studio.

Scheduling SQL Notebooks in Azure Data Studio

April 10, 2020 by Rajendra Gupta

SQL Notebooks are an interactive way of creating documents, executing T-SQL queries along with Python and PowerShell codes. It is available in Azure Data Studio, a cross-platform client tool that works on both Windows and Linux operating systems.

Learn Markdown language for SQL Notebooks in Azure Data Studio

February 26, 2020 by Rajendra Gupta

Microsoft supports SQL Notebooks in Azure Data Studio. It is an exciting feature that allows creating a notebook for multiple languages such as Python, SQL, PowerShell. You might have heard about the Jupyter notebook. It is a popular web-based notebook that provides rich programming language support. SQL Notebook is an inspiration for the Jupyter notebook.

Learn Jupyter Notebooks for SQL Server

February 25, 2020 by Rajendra Gupta

Introduction

The Jupyter notebook is a powerful and interactive tool that supports various programming languages such as Python, R, Julia. This open-source utility is popular among data scientists and engineers. This notebook integrates both code and text in a document that allows you to execute code, view visualization, solve mathematical equations.