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
0
votes
2 answers

Where to set environment variable in Azure Data Studio Python Notebook?

I started using Azure Data studio Notebook, I am having some credentials in environment variables. How can I use those environment variables in Azure Data studio?
muTheTechie
  • 1,443
  • 17
  • 25
0
votes
1 answer

Why can't i query synapse serverless view from azure data studio or databricks?

When i query my delta table from synpase studio, i can see the data all good. But when i am connecting trough data studio via sql login (or databricks), It seems that i can not query it : CREATE or alter view stock as SELECT * FROM OPENROWSET( …
OrganicMustard
  • 1,158
  • 1
  • 15
  • 36
0
votes
1 answer

SQL Server, temporary table, SELECT statement not working

I am trying to run a query in Azure Data Studio from a temporary table that I've created. However, in my SELECT statement, it does not recognize column name(s). The column names in the SELECT statement (i.e. FirstPlayer, SecondPlayer, Score) are…
Tony Correia
  • 29
  • 6
0
votes
2 answers

Sending a "Select functionname001" to SQL to easily identify long running queries and where called from

We had a performance issue with one of our queries in our application that was taking 20 seconds to run. Using azure data studio we figured out the SQL that was long running and then eventually traced that back to the entity framework query that…
Jaydel Gluckie
  • 328
  • 4
  • 12
0
votes
1 answer

Azure Data Studio - cannot find backup option

I need to backup a database I've got access to, but cannot find the option. According to https://learn.microsoft.com/en-us/sql/azure-data-studio/tutorial-backup-restore-sql-server?view=sql-server-ver15 I can simply right-click the database, go to…
user25730
  • 517
  • 2
  • 6
  • 24
0
votes
0 answers

Azure Data Studio not respect specified casing with PostgreSQL

Using Azure Data Studio with PostgreSQL Extension, the soft change the case of query, that leads to error. Here is my Query : SELECT * FROM workspaces JOIN member on workspaces.id = member.workspaceId Here is the error: column member.workspaceid…
Alexy
  • 780
  • 6
  • 22
0
votes
0 answers

Problem connecting asp.net core app to SQL server in a docker container

I have setup asp.net core applicaiton using SQL Server Management Studio on Windows OS, to be able to run same project on Mac OS I have setup docker container and running SQL server using azure data studio for management. However I have tried…
Amir Dora.
  • 2,831
  • 4
  • 40
  • 61
0
votes
1 answer

Backup and restore Azure database using Azure Data Studio

I have a database hosted on Azure and I have connected to it from mac machine using Azure Data studio. I want to take a backup of this database and then restore it in localhost to access it locally for better speed during development. I don't see…
Asif Hameed
  • 1,353
  • 9
  • 25
  • 46
0
votes
1 answer

Prevent saving changes that require table re-creation in SQL

I have a problem working in Azure Data Studio. In SQL Server Management Studio my problem can be fixed with a change to Tools >> Options >> Designers >> Table and Database Designers >> Uncheck – Prevent saving changes that require table re-creation.…
duc nguyendinh trung
  • 73
  • 1
  • 9
0
votes
1 answer

Parse string into property bag and loop through its keys to display its values in an extended column

I am ingesting a log that ends up putting a lot of good data in the "AdditionalExtensions" field. This is an example of the data: Action=Allow;User=test.test@test.com;SrcIpAddr=192.168.1.146;SrcPortNumber=64694 I am trying to figure out if there is…
Rakim
  • 167
  • 11
0
votes
1 answer

Azure Data Studio: How to save a notebook. Also, how to rename it

Just tried Azure Data Store and I really like what I see. However, this is rediculus, I 've been around to remember the physical version of the "3d save button" and I cannot find it here. I have created a bunch of notebooks AzDS named Notebook-0…
ntg
  • 12,950
  • 7
  • 74
  • 95
0
votes
1 answer

Azure Data Studio: Settings for newly installed extensions not found/ don't appear in settings

Trying to install new extensions in Azure Data Studio but settings not found for newly installed extensions. Same is case with any other extension. Given in the screenshot is version info, it is not latest but I don't think that could be the issue.
Varun Kuntal
  • 97
  • 1
  • 5
0
votes
0 answers

Azure data studio : writing python with hints

In visual studio code , when I write python code , it can intelligently provide you hints . for example are there any similar things in Azure data studio ? thanks
mytabi
  • 639
  • 2
  • 12
  • 28
0
votes
1 answer

Azure Data Studio connection issue

Cannot connect to mssql localhost instance via Azure Data Studio. Get: 'login failed for user sa'. In the same time I'm able to successfully connect via terminal: mssql -u sa -p myPassword mssql is in docker with status up sudo docker run -e…
Nicolas
  • 74
  • 11
0
votes
2 answers

Is there a way to look for unordered values ​that change position?

There is a table with 50 columns and they all contain numbers from 1 to 99. If I wanted to search, e.g. 8,36,52 no matter where they are, as long as they are in the same tuple, would I do it? I'm stuck because if I specify the column, I limit the…
Gustavo H. C. Silva
  • 11
1 2 3
…
16 17