Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,920 questions
1 answer
Which extensions to use to monitor server / database / queries in ADS
Hello, I am starting to use ADS. Most of the time I will run SQL queries but sometimes I will need also to monitor database and troubleshoot slow queries. In other words .. quite lightweight 'bad' query troubleshooting and basic monitoring. Which ADS…
1 answer
One of the answers was accepted by the question author.
Create a new Project in ADS
Hello I copied all my queries and Projects from Toad for SQL to ADS and put it in one folder. Now I want to create a new Project in the same folder. I see that Project from Toad have extension .tpf My goal is to have queries related to the same/similar…
1 answer
uploading csv file from local computer via Azure Data Studio
Hello, I am facing issues with uploading csv files from my local computer via Azure Data Studio . I have many columns in the table and Azure Data Studio maps them incorectly that the file is in the end not imported. I cannot check all the types of…
asked 2023-08-02T12:13:55.4+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 47%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Petra Carrion
0
Reputation points
answered 2023-08-16T11:22:44.4+00:00
Aamir Aziz
0
Reputation points Student Ambassador
1 answer
Create a new Project in ADS
Hello, I copied all my Queries and Project from Toad for SQL. I created Project in Toad to organize queries based on some common task. Now in ADS I see it with extension .tpf Question: how could I create a new project in ADS in the same folder I keep my…
asked 2023-08-14T13:44:19.2066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 94%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Susja
716
Reputation points
answered 2023-08-15T18:44:57.2633333+00:00
Javier Villegas
900
Reputation points MVP
1 answer
How to install downloaded extension 'Search Everywhere' in ADS
Hello, I noticed this extension 'Search Everywhere' ADS, I wanted to try it. It links to https://github.com/MikhailProfile/SearchEverywhere/releases/tag/ads I downloaded it on my Windows 2019 but don't know how to install it. Could someone advice? Thanks
asked 2023-08-13T00:04:54.3066667+00:00
Susja
716
Reputation points
commented 2023-08-14T21:46:34.62+00:00
Oury Ba-MSFT
16,986
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How to use SQL Profiler in ADS
Hello I am new to ADS. I have basic tasks: analyze slow queries, monitor current server status and etc. I think that ADS extension: SQL Server Profiles should fit my need. Hence I installed. I don't have experience how to use it hence I browsed some…
asked 2023-08-12T15:49:05.47+00:00
Susja
716
Reputation points
commented 2023-08-14T20:44:24.7533333+00:00
Erland Sommarskog
1L
Reputation points MVP
3 answers
One of the answers was accepted by the question author.
How to use bash shell in ADS terminal ?
Hello, I am used to work in bash shell but lately I was working on Windows .. hence my choice was Cygwin. Now I am using ADS and want to utilize Terminal option. I have Cygwin installed on my Desktop hence I could invoke executables from it but my point…
2 answers
One of the answers was accepted by the question author.
Unix/ Cygwin-like extension in ADS
Hello I started to use ADS recently and I like it but one thing I am missing. Quite often I have to switch from SQL running to Cygwin for some text analysis. I tried to use PowerShell terminal but it’s not as convenient as Cygwin-like syntax. BTW ……
1 answer
One of the answers was accepted by the question author.
Configure export file name in ADS
I used Toad for SQL for a long while and liked that it has a feature to configure file name. I mostly used .csv format and Toad by default appended current timestamp to the end of the file. Doing that way each file became unique and convenient to store.…
asked 2023-08-05T01:20:49.0633333+00:00
Susja
716
Reputation points
commented 2023-08-06T06:52:45.5466667+00:00
Konstantinos Passadis
17,376
Reputation points MVP
2 answers
'Include Live Query Statistics' using SQL Server Management Studio with Azure SQL Database? Is it supported?
Should I be able to use 'Include Live Query' statistics to observe query runtime performance as data flows through? I see examples of this using 'on prem' SQL Server, but I am not clear if this is supported in Azure SQL Database. When I try to use it…
asked 2023-08-04T13:53:20.4333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 1%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Derek Horrall
196
Reputation points
commented 2023-08-05T22:05:43.0466667+00:00
Erland Sommarskog
1L
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Do I need Notebook in ADS?
Hello, I am quite new to ADS. It looks attractive to me and I'm starting to understand it and see if it'll fit my need. Note: my daily work include run SQL queries, create/modify existing ones, some database maintenance, writing / modifying Python…
asked 2023-08-03T18:56:41.56+00:00
Susja
716
Reputation points
commented 2023-08-04T22:13:17.79+00:00
Oury Ba-MSFT
16,986
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
asked 2023-04-17T02:53:16.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 5%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
효준 이
25
Reputation points
commented 2023-08-04T11:01:18.47+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 49%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVG%3C/text%3E%3C/svg%3E)
vinish george
2
Reputation points
2 answers
One of the answers was accepted by the question author.
How to get mssql extention in ADS
Hello, I started to use ADS a few days ago. Here are settings: Version: 1.44.1 (system setup) Commit: 8f53a316fa00a98264f1ab119641cd540b5af25c Date: 2023-06-01T02:12:48.765Z VS Code: 1.70.0 Electron: 19.1.8 Chromium: 102.0.5005.167 Node.js: 16.14.2 V8:…
2 answers
Azure Data Studio, cannot add account
please help check the reason, I don't know why error adding account
asked 2023-07-18T07:42:06.5866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 98%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWD%3C/text%3E%3C/svg%3E)
Wendy Dong
0
Reputation points
commented 2023-07-26T07:42:42.08+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
14,166
Reputation points Microsoft Employee
1 answer
my certification not showing up passed on 24th July DP-900
my certification not showing up passed on 24th July DP-900
asked 2023-07-26T06:50:44.8666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 1%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Srinivasan Alagarsamy
0
Reputation points
answered 2023-07-26T06:55:23.2666667+00:00
Andreas Baumgarten
99,371
Reputation points MVP
0 answers
How to install mssql extension in ADS ?
Hello, I started to use ADS a few days ago. Here are the settings: Version: 1.44.1 (system setup) Commit: 8f53a316fa00a98264f1ab119641cd540b5af25c Date: 2023-06-01T02:12:48.765Z VS Code: 1.70.0 Electron: 19.1.8 Chromium: 102.0.5005.167 Node.js:…
asked 2023-07-25T15:17:13.32+00:00
Susja
716
Reputation points
commented 2023-07-25T16:42:06.5866667+00:00
Oury Ba-MSFT
16,986
Reputation points Microsoft Employee
0 answers
How to get mssql extension in ADS
Hello, I started to use ADS a few days ago. Here are the settings: Version: 1.44.1 (system setup) Commit: 8f53a316fa00a98264f1ab119641cd540b5af25c Date: 2023-06-01T02:12:48.765Z VS Code: 1.70.0 Electron: 19.1.8 Chromium: 102.0.5005.167 Node.js:…
asked 2023-07-25T15:14:47.24+00:00
Susja
716
Reputation points
commented 2023-07-25T16:41:42.2033333+00:00
Oury Ba-MSFT
16,986
Reputation points Microsoft Employee
2 answers
A few simple questions to navigate Azure Data Studio
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…
asked 2023-07-20T23:48:10.3166667+00:00
Susja
716
Reputation points
answered 2023-07-24T09:15:43.0266667+00:00
ShaktiSingh-MSFT
14,166
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Comparison between Toad and Azure Data Studio to implement same tasks
Hello I was using Toad for SQL for a long while and now have to switch to Azure Data Studio (ADS). Hence I would appreciate if you could give some help regarding “ how to implement similar tasks in ADS”. I will list a few things that I am missing now: …
asked 2023-07-23T11:15:02.2233333+00:00
Susja
716
Reputation points
answered 2023-07-24T08:54:26.5766667+00:00
ShaktiSingh-MSFT
14,166
Reputation points Microsoft Employee
1 answer
Is it possible reverse Sync databases from Azure SQL managed Instance to On-premises SQL Server 2019
Hi Team, We have been migrating the databases from on-premises SQL server to Azure SQL MI using Azure data Studio. Is there any migration tool to migrate the databases from Azure SQL MI to On-premises SQL server? Is it possible reverse sync data between…
asked 2023-07-03T10:13:01.32+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 30%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Thyagarajulu B M
121
Reputation points
commented 2023-07-20T16:58:27.2466667+00:00
GeethaThatipatri-MSFT
28,462
Reputation points Microsoft Employee