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:
Read more »
Azure Data Studio
Integrating Azure Data Studio with Git and GitHub
July 3, 2020In 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.
Read more »
Source Control using Git in Azure Data Studio (ADS)
July 2, 2020Azure 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.
Read more »
The SQL Server Assessment Extension for Azure Data Studio
June 30, 2020Azure 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.
Read more »
Digging deeper into Azure Data Studio: Extensions and Azure SQL DB Development
June 24, 2020In 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.
Read more »
Digging deeper into Azure Data Studio: More code and less GUI
June 23, 2020In 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.
Read more »
Developing your SQL Server database using Azure Data Studio
June 22, 2020In 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.
Read more »
Starting your journey with Azure Data Studio
June 19, 2020In 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!
Read more »
Server and Database dashboards in Azure Data Studio
May 14, 2020Azure 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.
Read more »
Create charts from SQL Server data using Azure Data Studio
May 13, 2020In this article, we will explore charts in an Azure Data Studio using data stored in SQL Server tables.
Read more »
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 »