In this article, we will explore charts in an Azure Data Studio using data stored in SQL Server tables.
Read more »
Azure Data Studio
View Execution Plans in Azure Data Studio
April 24, 2020This article gives an overview of viewing execution plans in the Azure Data Studio.
Read more »
Scheduling SQL Notebooks in Azure Data Studio
April 10, 2020SQL 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.
Read more »
Learn Markdown language for SQL Notebooks in Azure Data Studio
February 26, 2020Microsoft 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.
Read more »
Learn Jupyter Notebooks for SQL Server
February 25, 2020Introduction
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.
Read more »
Access PostgreSQL databases using the Azure Data Studio extension
January 16, 2020This article installs PostgreSQL on Ubuntu 16.4 operating system and connects the database using Azure Data Studio.
Read more »
Generate data scripts using SSMS and Azure Data Studio
January 13, 2020This article explores different ways to generate data scripts using Azure Data Studio and SQL Server Management Studio.
Read more »
Encrypting passwords with Python Scripts in SQL Notebooks of Azure Data Studio
January 6, 2020This article explores the Python scripts for encrypting and decrypting passwords in SQL Server using Azure Data Studio SQL Notebooks.
Read more »
Use Python SQL scripts in SQL Notebooks of Azure Data Studio
December 25, 2019This article explores the Python SQL scripts in SQL Notebook of Azure Data Studio.
Read more »
Database Administration Tool Extension for Windows in Azure Data Studio
December 17, 2019Azure Data Studio provides a modern and productive experience for managing on-premise and cloud-based SQL Server instances. Previously, we discussed many useful features of it, and you can explore these articles in Azure Data Studio category.
Read more »
SQL Server Schema Compare extension in Azure Data Studio
December 5, 2019This article explores the SQL Server Schema Compare extension in the Azure Data Studio.
Read more »
Exploring the SandDance Visualizations extension in Azure Data Studio
November 6, 2019Azure Data Studio is an open-source, cross-platform and lightweight data management tool. We can use it for on-premise SQL Server, Azure SQL database and Azure SQL data warehouse. Previously we knew this tool as SQL Operations Studio.
Read more »
A handy SQL Notebook for the purposes of troubleshooting in Azure Data Studio
November 5, 2019This article prepares a handy SQL Notebook for DBAs. You can use this notebook to troubleshoot performance issues and for getting SQL Server instance details.
Read more »
SQL Notebooks introduction and overview
May 20, 2019This article explains the SQL Notebook feature in Azure Data Studio along with the Markdown language to customize it.
Read more »
SQL Code Snippets in Azure Data Studio
April 16, 2019This 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
Read more »
SQL Server Profiler in Azure Data Studio
December 28, 2018In 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.
Read more »
SQL Server 2019 on Linux with Ubuntu and Azure Data Studio
November 29, 2018In the previous articles of this series on using SQL Server 2019 on Ubuntu, we have explored the following
Read more »
SQL Server Data Import using Azure Data Studio
September 18, 2018Azure 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.
Read more »
Getting started with Azure Data Studio (ADS); initial installation and configuration
August 14, 2018Microsoft 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!
Read more »
Backup and Restore operations with SQL Server 2017 on Docker containers using Azure Data Studio
July 19, 2018In this 18th 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, 2018Azure 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.
Read more »