Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
99 questions
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
![](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
711
Reputation points
commented 2023-08-14T21:46:34.62+00:00
Oury Ba-MSFT
16,636
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
711
Reputation points
commented 2023-08-14T20:44:24.7533333+00:00
Erland Sommarskog
101.8K
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
711
Reputation points
commented 2023-08-06T06:52:45.5466667+00:00
Konstantinos Passadis
17,301
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
101.8K
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
711
Reputation points
commented 2023-08-04T22:13:17.79+00:00
Oury Ba-MSFT
16,636
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
13,751
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
97,566
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
711
Reputation points
commented 2023-07-25T16:42:06.5866667+00:00
Oury Ba-MSFT
16,636
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
711
Reputation points
commented 2023-07-25T16:41:42.2033333+00:00
Oury Ba-MSFT
16,636
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
711
Reputation points
answered 2023-07-24T09:15:43.0266667+00:00
ShaktiSingh-MSFT
13,751
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
711
Reputation points
answered 2023-07-24T08:54:26.5766667+00:00
ShaktiSingh-MSFT
13,751
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
27,717
Reputation points Microsoft Employee
1 answer
Azure Data studio migration extension not working
Hi Team, I am working on assessments and I have added the Azure SQL migration extension in Azure Data Studio(VM don't have internet connectivity) for assessments recommendations but I am getting the below error, can you please help me Failed to start…
asked 2023-06-26T12:02:38.36+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(214.4, 52%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sanjeev Reddy
5
Reputation points
answered 2023-07-12T13:45:12.5+00:00
Sanjeev Reddy
5
Reputation points
0 answers
Azure Data Studio - Not able to connect to Oracle DB -Getting ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA error
Hi I installed, Azure Data Studio, Downloaded the extension for Oracle . However while connecting to an Oracle database Im getting the following error ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA This is not an issue with the…
asked 2023-05-25T12:14:24.9233333+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(70.4, 94%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Anju Kirankumar
5
Reputation points
edited a comment 2023-07-12T13:33:12.15+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, 98%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Venetie van, Hans
0
Reputation points
0 answers
Invalid Object Name - Even after Intellisense refresh and studio restart
I have a table in my database that I am referencing in a stored procedure and in scripts. I have restarted studio several times, refreshed the intellisense and the stored procedure runs every day but I still get the red line under the table and any…
asked 2023-06-28T09:30:03.3866667+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(128, 8%, 22%)' 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)
Anonymous
commented 2023-06-30T05:49:43.11+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Azure Data Studio
Hi All, Can I remove Azure Data Studio from SQL Server Management Studio? I see that it is available in programs and features in control panel. Additionally, if removal is possible, does it have any impact in any on the components and functionalities of…
asked 2023-06-22T05:04:14.67+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(6.4, 41%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shuvajit Roy
166
Reputation points
commented 2023-06-27T06:25:31.89+00:00
Shuvajit Roy
166
Reputation points