View the query plan from 'slow query widget' in ADS
Hello, I am continue to follow steps in https://video2.skills-academy.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…
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.
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/m1bbfS1QxEOKmNJUqVDIMg.png?8DB89C)
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…
![](https://techprofile.blob.core.windows.net/images/PAxjl2BhAQAAAAAAAAAAAA.png?8DA620)
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
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
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…
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 ……
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.…
![](https://techprofile.blob.core.windows.net/images/KhnRGP5_AwAAAAAAAAAAAA.png?8DBA61)
'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…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
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…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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:…
Azure Data Studio, cannot add account
please help check the reason, I don't know why error adding account
my certification not showing up passed on 24th July DP-900
my certification not showing up passed on 24th July DP-900
![](https://techprofile.blob.core.windows.net/images/as_Tu4nfLUeUI0EOf39xtg.png?8D9529)
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:…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)
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:…
![](https://techprofile.blob.core.windows.net/images/kjzQAO5Oq0Oj37wdNf6qTQ.png?8D8E42)