Azure SQL Database
An Azure relational database service.
5,174 questions
3 answers
One of the answers was accepted by the question author.
Azure Data Studio - Integration runtime pre-requisites
Hello Everyone, We are migrating SQL server 2016 from on-prem to Azure SQL MI(Business Critical tier). Due to lack of private connectivity between the source and the destination, we have decided to use Azure Data Studio tool with SQL migration extension…
asked 2023-10-05T02:10:09.09+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(60.8, 55.00000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Mohammed Thahif BK
341
Reputation points
answered 2023-10-25T05:05:29.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(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
One of the answers was accepted by the question author.
How to re-map keyboard binding on MacBook
Hello I am using ADS on my MacBook. In order to open a new Query editor I click 'command' + N keys. At the same time I use ADS on remote Windows PC where I RDP from my MacBook. In order to open Query editor on remote PC I have to click‘Control' + N…
1 answer
Azure Data Studio via SSH Tunnel to Azure SQL Server
I have installed Azure Data Studio on Mac M1, and can connect to my Azure SQL Server over public IP, but I want to do the same over a SSH Tunnel. The tunnel is set for port 1433 on mac and I can transmit data through to tunnel over port 1433 fine, but…
asked 2023-10-13T10:59:14.5033333+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(156.8, 70%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHE%3C/text%3E%3C/svg%3E)
Ho, Eddie
15
Reputation points
commented 2023-10-16T22:01:37.56+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
During database migration in online mode using Azure data studio status is restoring only on sqlmi.
During database migration in online mode using Azure data studio status is restoring only on sqlmi. it's not changing since long time. Though Azure data studio shows restored and Data migration service shows ready for cutover. Data is around 24 GB only.
asked 2023-10-11T09:35:48.61+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(246.4, 97%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Pratibha Agrawal
0
Reputation points
answered 2023-10-11T12:04:41.4+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
How to disconnect servers after N minutes? (Set server connection timeout.)
I have Azure Data Studio Desktop App Version 1.45.1 (Oct 2023) on Windows 11. I am doing tutorials to learn ADS, so I'm a beginner here. I put my computer to sleep and left ADS running. I had 2 servers connected. This morning they were still connected.…
asked 2023-10-10T09:36:56.7033333+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, 77%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Chuck Roberts
45
Reputation points
commented 2023-10-10T10:30:43.62+00:00
Chuck Roberts
45
Reputation points
1 answer
One of the answers was accepted by the question author.
How to backup a database in "Azure Data Studio" Desktop app.
I'm watching a LinkedIn video from Aug 2022. I'm very new to the Azure world. The ADS desktop app interface has changed as each server connection now has the database listed on it, so there is no database tab or any option to backup or restore a database…
asked 2023-10-05T11:29:50.18+00:00
Chuck Roberts
45
Reputation points
accepted 2023-10-05T12:01:21.26+00:00
Chuck Roberts
45
Reputation points
1 answer
One of the answers was accepted by the question author.
How to create SQL Connection from Mac to Windows
Hello I am using ADS on Windows I have created a few SQL Connections from my Windows PC to SQL servers Now I have to use MacBook and I still want to connect to the same Windows SQL servers I connected before from Windows PC I installed Visual Studio…
1 answer
i have installed extension for oracle in azure data studio but it is not showing in connection types ?
oracle is not showing in connection type.
asked 2023-09-19T06:36:46.3966667+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(89.60000000000001, 1%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Ayush Mishra
0
Reputation points
answered 2023-09-19T08:56:00.0633333+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure SQL Server error message - Query failed: The file exists
I have a SQL database resource in Azure that I've been using for a few months. Using Azure Data Studio I can log in to my Azure SQL Server database with my user ID using Authentication Type "Azure AD - Universal with MFA Support", see all of…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,174 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
979 questions
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.
99 questions
asked 2023-09-07T12:31:03.0533333+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(192, 67%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
Dan Falcone
35
Reputation points
commented 2023-09-09T15:21:11.05+00:00
Amira Bedhiafi
15,831
Reputation points
0 answers
How to get the data from dataverse(CRM) to azure bot(Bot framework composer)
Hi, I've registered an app and configured all settings within the Azure Portal. Successfully implementing OAuth login has allowed me to obtain the token as expected. However, despite adding the app to the CRM system and performing the necessary…
Azure AI Bot Service
Azure AI Bot Service
An Azure service that provides an integrated environment for bot development.
751 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
979 questions
Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,716 questions
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.
99 questions
asked 2023-08-29T08:58:50.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(272, 66%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Nisha Kashyap
0
Reputation points
edited the question 2023-09-04T04:37:37.51+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(281.6, 17%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGM%3C/text%3E%3C/svg%3E)
Givary-MSFT
28,486
Reputation points Microsoft Employee
2 answers
Azure Data Studio - Hide specific output components in notebooks.
I am trying to learn Azure Data Studio to see if I can expand my knowledge beyond SSMS. I am finding it to not be very intuitive or user friendly. It must be more useful for users approaching from different development platforms, languages,…
asked 2023-08-30T22:23:43.79+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, 43%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
B_Gage
5
Reputation points
answered 2023-09-01T15:45:05.26+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Export ADS setting to another Desktop
Hello i installed ADS on my another Desktop and want to export my settings I.e. preferences and etc. to another Desktop How could I do it?
asked 2023-08-06T12:32:55.1433333+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
edited the question 2023-08-30T19:53:53.7066667+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Multiple Results Tabs in ADS
Hello, My previous SQL client was Toad for SQL hence I'm subconsciously trying to compare some features. One is that in Toad I was able to run same query a few times but slightly changing some parameters. For each run it generated Results Tab ( default…
2 answers
View the query plan from 'slow query widget' in ADS
Hello, I am continue to follow steps in https://learn.microsoft.com/en-us/sql/azure-data-studio/tutorial-qds-sql-server?view=sql-server-ver16 and stuck at the point where need to analyze Query Plan. I followed all steps in tutorial and now I opened 'Run…
asked 2023-08-19T03:19:55.8766667+00:00
Susja
711
Reputation points
commented 2023-08-28T05:43:51.5+00:00
ShaktiSingh-MSFT
13,751
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
how to sign out my github account on Azure Data Studio of Mac OS version?
I have downloaded Azure Data Studio for Mac OS. I installed the GitHub Copilot extension. Firstly I log in my GitHub account. Then I find there is a problem. I can not logout or signout my GitHub account to religion with another GitHub account.
asked 2023-08-19T05:47:13.6766667+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(156.8, 65%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tang, Shixin
25
Reputation points
accepted 2023-08-25T03:48:42.4533333+00:00
Tang, Shixin
25
Reputation points
2 answers
How to convert time in 'slow query widget' in ADS?
Hello, I wanted to follow steps described in article 'how to analyze' ADS widget ' slow query' I opened 'Manage' from right-click on database. Then I selected 'Show Details'. Selected one query and see that max_duration was 390180823 Now I want to…
asked 2023-08-18T21:40:34.1866667+00:00
Susja
711
Reputation points
commented 2023-08-21T16:10:23.9+00:00
Oury Ba-MSFT
16,636
Reputation points Microsoft Employee
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
Susja
711
Reputation points
answered 2023-08-15T18:44:57.2633333+00:00
Javier Villegas
895
Reputation points MVP