Stack Overflow
Stack Overflow

Questions tagged [azure-data-studio]

Use this tag for issues related to Azure Data Studio and try tagging the platform as well. Ask the question on superuser.com if you are facing issues with installation

Azure Data Studio is a data management tool that enables working with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux. This is similar to Sql Server Management Studio, but works on all platforms.

Github: https://github.com/Microsoft/azuredatastudio

253 questions
1
vote
1 answer

Azure SQL DB - added size restriction on NVARCHAR column and the size of my DB bloated. Why did this happen?

I have an Azure SQL DB Table with about 700k records and 9 columns. Most of those columns were initially set to NVARCHAR(max) I decided to then apply a SQL Script to limit the column size as I felt this should optimize performance. I ran the…
Allen S
  • 3,471
  • 4
  • 34
  • 46
1
vote
2 answers

NOT LIKE '%%' query on JSON data returns incorrect results

I have this query: select * from t where JsonColumn like '%A%' and JsonColumn not like '%"A": null%' I can see that JsonColumn of several rows contains the value present in not like clause i.e. some json values contain this content: {…
Bassie
  • 9,529
  • 8
  • 68
  • 159
1
vote
1 answer

How to troubleshoot Azure Data Studio "error occurred during the pre-login handshake" when adding on-prem SQL Server connection?

Azure Data Studio verison 1.35.1 is installed on my MacBook Pro running macOS Monterey version 12.3.1. Here are the steps I took to generate this error. In "Accounts", I added a Windows Server domain level account authenticated via "Azure Active…
2myCharlie
  • 1,587
  • 2
  • 21
  • 35
1
vote
0 answers

Error restoring a sql server database on mac using a docker

I am trying to restore a backup to a docker container that contains the sql server 2019 service. I am using Mac and for which I am using Azure Data Studio for the connection Script in Azure Data Studio RESTORE FILELISTONLY FROM DISK = …
Deybi Tabora Paz
  • 171
  • 3
  • 11
1
vote
3 answers

Mac M1 running MS SQL on Docker, unable to connect from Azure Data Studio

Environment: MacBook Pro - Chip: Apple M1 Pro, macOS Monterey 12.2.1 How do I run a docker MS SQL (any version) on Mac M1 and connect from Azure Data Studio? I was able to create a docker image of azure-sql-edge. Pod is running OK. INFO: Connection…
alwisr
  • 11
  • 1
  • 3
1
vote
0 answers

Unable to see the "Properties" option on right clicking the user database and column under the table in Azure Data Studio [ MAC SYSTEM ]

Steps 1.Created a user database - DB1 2.Created a table - TB1 with columns - cm1 and cm2 3.Installed the extension - "Database Administration Tool Extension" 4.Relaunched the application 5.Right clicked on the database - DB1…
Ritu
  • 11
  • 1
  • 4
1
vote
1 answer

How to write SQL query to find duplicates in tables

I'm currently trying to write a SQL query that finds any conflicts where any rows have the same x and y values. Here are the tables I'm currently working with: CREATE TABLE Slot ( sid INT, wall varchar(200), x FLOAT, y …
ppboi
  • 13
  • 4
1
vote
1 answer

Shap rendering in Azure Data Studio

I'm unable to run shap.initjs() in Azure Data Studio Notebooks. Gave up looking up the issue on Azure community forum or elsewhere. shap.initjs() test_sample = test_x.iloc[:2000,:] shap_values_sample =…
Patricio Lobos
  • 108
  • 11
1
vote
0 answers

Move settings.json to a different folder for Azure Data Studio

According to this link Azure Data Studio looks at %APPDATA%\azuredatastudio\User\settings.json on Windows for the settings. Can I tell Azure Data Studio to use a different folder for the settings.json file? Why? I recently lost my Windows profile. I…
Wallace Kelly
  • 15,565
  • 8
  • 50
  • 71
1
vote
0 answers

Extension for Azure data studio that run after execute query

Is there an event that can be listened after run the query? If not, can i subscribe keybinding event on "F5" but that the query run first, and then my extension? UPDATE: I partly solved the second option. i looked on keyboard shortcuts and i got…
Dawid Mikołaj Alejski
  • 11
  • 2
1
vote
1 answer

X System.Net.Sockets.SocketException (22):Invalid argument - Azure SQL Database - Upload data Error

I am new Azure. I have created SQL Server & SQL database, trying to upload .csv file data to SQL database. I am using Azure Data Storage to upload data. I connected to Azure -> Import wizard -> chose file -> Preview Data -> Modify Columns ->…
Jay Prakash Thakur
  • 545
  • 7
  • 20
1
vote
1 answer

Azure Data Studio Database Project - Unable to Build

I have a new install of Azure Data Studio with SQL Database Projects, SQL Server Dacpac and SQL Server Schema Compare extentions. I created a database project from an existing database (AdventureWorks2019) installed on SQL Server 2019 Developer…
Randal Matthew
  • 13
  • 4
1
vote
2 answers

Azure Data Studio - Why Is Restore Option Missing Entirely?

I am doing a simply .bak restore using Azure Data Studio. Following the instructions available…
Jay
  • 2,648
  • 4
  • 29
  • 58
1
vote
1 answer

Azure Data Studio produced Excel spreadsheet displays cell values as text (not the result of the formula's execution)

Original Problem: Within Azure Data Studio, I have saved the results of a SQL query into Excel spreadsheet. When I bring up the spreadsheet, a cell containing a formula (a URL hyperlink) is showing as text to display as opposed to results of…
chaotic3quilibrium
  • 5,661
  • 8
  • 53
  • 86
1
vote
0 answers

How to change username and password for localhost database in azure data studio on linux?

I use azure data studio for my localhost database on manjaro linux. I want to change my username and password for the localhost database, but I don't know how. I know I can't do that with a query and I searched on the internet how to do that but all…
programmingDracula2699
  • 47
  • 8
1 2 3
…
16 17