A few simple questions to navigate Azure Data Studio

Susja 716 Reputation points
2023-07-20T23:48:10.3166667+00:00

Hello,

I was using Toad for many years and I love it for convenience and many features.

I'm also familiar with MS SQL Server Management Studio but not that much as with Toad.

Anyway .. I was moved to another environment where they don't have Toad and I have the choice: either used MS SQL Studio or Azure Data Studio.

Obviously I will check documentation later but for the quick start I need some heads-up that I'm missing both in MS SQL Studio and Azure.

From the first glance it looks to me that Azure has much more options than SQL Management which MS SQL Studio is designed. Hence I'm debating either use Azure or MS SQL Management Studio

The options that I am looking are:

  1. how to find history of executed queries ?
  2. is Azure editor convenient for various languages ... like html, python or etc?
  3. does Azure has VSC built-in and how to invoke it? Obviously I will have more questions and check myself ... but for quick start you heads-up would be helpful

Thanks

Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
106 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-07-24T09:15:43.0266667+00:00

    Hi
    Susja     •,,

    Azure Data Studio is built on top of Visual Studio Code and offers a lightweight, keyboard focused modern code workflow experience when working with SQL Server, Azure SQL Database, and Azure Synapse Analytics.

    Refer: https://medium.com/short-bits/azure-data-studio-vs-code-for-sql-databases-69747d71c915

    If your ask is like Can I use Visual Studio Code (VS Code) extensions with Azure Data Studio?

    Yes.

    However, not all VS Code extensions translate to Azure Data Studio.

    Regarding your second question, it is replied over another question raised by you.

    Hope this helps. Thanks.

    1 person found this answer helpful.
    0 comments
  2. ShaktiSingh-MSFT 14,281 Reputation points Microsoft Employee
    2023-07-21T14:18:42.0133333+00:00

    Hi
    Susja     •,

    Welcome to Microsoft Q&A forum and thanks for using Azure Services.

    As I understand, you have few questions related to Azure Data Studio. Below is the reply:

    1). We have Query history extension as illustrated here to view Queries History https://cloudblogs.microsoft.com/sqlserver/2019/10/02/the-october-2019-release-of-azure-data-studio-is-now-available/

    2). For different languages support, you may go to File and create Notebook:

    User's image

    3). does Azure has VSC built-in and how to invoke it? Could you please elaborate more on the requirement here.

    Thank you.

    0 comments