Azure SQL Database: Embedding Documents and Query Results in SQL Notebooks

Embedding Documents and Query Results in SQL Notebooks

Question

You are writing a set of SQL queries that administrators will use to troubleshoot an Azure SQL database.

You need to embed documents and query results into a SQL notebook.

What should you use?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

B

https://www.mssqltips.com/sqlservertip/5997/create-sql-server-notebooks-in-azure-data-studio/

The correct answer is B. Azure Data Studio.

Azure Data Studio is a cross-platform database tool used to manage on-premises and cloud-based databases. It is an open-source tool developed by Microsoft and is used to write SQL queries, manage data, and visualize data. It is a lightweight tool that runs on Windows, macOS, and Linux.

Azure Data Studio provides the ability to embed documents and query results in a SQL notebook. This feature allows administrators to create detailed reports and share them with other users. Users can also use Markdown language to create documentation and attach it to queries.

Microsoft SQL Server Management Studio (SSMS) is a tool used to manage on-premises SQL Server databases. It is not designed to manage cloud-based databases, including Azure SQL databases.

Azure CLI and Azure PowerShell are command-line interfaces