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?
B. Azure Data Studio is a cross-platform database tool that allows you to embed documents and query results into a SQL notebook. It supports Azure SQL databases, SQL Server, and other databases. It also has built-in support for SQL Notebooks, which allows you to mix markdown, code, and results in a single notebook. This makes it a great tool for creating documentation and troubleshooting guides for administrators to use when working with Azure SQL databases.
Just an FYI - SSMS is not just an on-prem product. SSMS can also connect to Azure (I've used it for the last 6 years on Azure projects). IaaS: SQL Server VM PaaS: Azure SQL DB. You can also connect to Synapse SQL Pools. SSMS has native integration with Data Studio. I still use SSMS for everything because I do DBA/arch/dev work across on-prem & cloud. But Data Studio is cross-platform & has real coding languages.
This is a nice Azure Data Studio vs SSMS comparison (and which one is better for what type of task):
https://mindmajix.com/azure-data-studio-vs-ssms
... but, yes, the answer to this question itself is Data Studio.
Just wanted people to know that they can still use SSMS in Azure. The tool is exactly the same regardless of on-prem or cloud.
It is still B but if you use the current SSMS you'll get the Az Data Studio automatically ;-)
https://learn.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver16#windows-installation
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Fellipo
Highly Voted 3 years, 9 months agoAshodwbi
Highly Voted 3 years, 10 months agoSwamy90572
Most Recent 1 week agob9f0525
2 months, 3 weeks agoAZFabio
11 months, 3 weeks agochiiiweiii
1 year, 5 months agoJoanna0
1 year, 6 months agoPinha
1 year, 7 months agoiesRuben
1 year, 8 months agoJA2018
1 year, 10 months agoColoradoChick
1 year, 1 month agoBambi0074
1 year, 10 months agoEltooth
2 years, 1 month agocormorant
2 years, 4 months agoRichMelbourne
2 years, 4 months agoAshutosh344
2 years, 5 months agotheLazyGuy
2 years, 10 months agoxiban
2 years, 10 months ago