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
2
votes
1 answer

How can I use Azure Data Studio's SQL formatting with DBeaver?

I really love DBeaver as a database query tool, but I don't like the default SQL formatting that is has. I'm wondering if it's possible to point to the SQL formatting that is used by Azure Data Studio? DBeaver allows you to use External formatters,…
Frantumn
  • 1,725
  • 7
  • 36
  • 61
2
votes
0 answers

Is there anyway I can spell check my notebook in Azure Data Studio or VS Code

I am really enjoying using Jupyter notebooks in Azure Data Studio, especially the markdown sections between the code. I want to distribute the notebook to my client, however, I am a terrible speller and rely heavily on spellcheck normally. Is there…
2
votes
2 answers

How to increase the font size of result text in Azure Data Studio Notebook?

I have found how to increase the font size of about everything except the result text of a code cell in an Azure Data Studio notebook. Zoom works, but is not ideal. Does anyone know of a way to increase the font size of that text?
asharon.mori
  • 105
  • 2
  • 9
2
votes
0 answers

Azure Data Studio does not display the rows affected for UPDATE statements

I'm relatively new to working with databases and I'm having trouble with Azure Data Studio (v1.25.1) not displaying how many rows are being affected with UPDATE statements. I need to make some small changes to PostgreSQL databases in my day to day…
cs_monkey
  • 41
  • 1
2
votes
1 answer

Execute SQL from within an Azure Data Studio extension?

I want to create an extension for Azure Data Studio that accesses a database. The database (SQL Server) is already available in Azure Data Studio, as I am manually interacting with it. Reading the Extensible API documentation it seems to be possible…
stefan.at.kotlin
  • 15,347
  • 38
  • 147
  • 270
2
votes
1 answer

MacOs Catalina and Kerberos Config

I am trying to access on prem Sql Server via Azure Data Studio. However I am hitting with some errors in Kerberos. Below are the series of errors that getting thrown. When trying to connect Sql Server via Azure Data Studio , the below error is…
Alan B
  • 2,219
  • 4
  • 32
  • 62
2
votes
0 answers

Azure Data Studio will not connect to MSSQL server on Debian 10

I have a fresh install of Debian 10 on VirtualBox. Installed ADS from Microsoft package repository. When I try to create an MSSQL database connection the app just sits and spins with high CPU. ADS never connects. On the same VM I can connect to…
Mac
  • 21
  • 2
2
votes
1 answer

Error creating SQL Server on Azure Data Studio

My configuration is as follows: Nothing is changed in the advanced section. My error message: What's wrong here?
2
votes
1 answer

In Azure Data Studio, queries are all disconnected

I am trying to move from SSMS to Azure Data Studio, primarily to take advantage of the easy git integration. In Azure Data Studio, all my queries (the .sql files) all show up; everything works as expected. It was easy to add github integration. …
Knox
  • 2,909
  • 11
  • 37
  • 65
2
votes
1 answer

Azure Data Studio-server connection error on Mac bookpro

To run SQL Server on my Mac, I installed Docker and SQL Server Management Studio (Azure Data Studio) and got connected to the server. However, when I tried to reconnect another time, I got the error below. I've found much advice about how to fix the…
Tes
  • 151
  • 1
  • 7
2
votes
2 answers

Azure Data Studio "unknown property IsColumnSet"

I'm trying to use Azure Data Studio to connect to a SQL Server database. I am able to connect to the database and view the list of objects (tables, stored procedures, etc.). When I click to expand the "Columns" group inside a table, I get the…
jeffjenx
  • 17,041
  • 6
  • 57
  • 99
2
votes
1 answer

Azure Data Studio (formerly SQL Operations Studio) Chart Results

The chart function in Azure Data Studio produces a chart for the following query (under Results > Charts ) when really I want just a simple line chart of run time over time. Seems like the chart results feature in Azure Data Studio does not allow…
Chad Miller
  • 40,127
  • 3
  • 30
  • 34
2
votes
1 answer

How to access Server Properties in SQL Operations Studio?

In Microsoft SQL Server Management Studio, there is the option to right click on a server to get to: Server Properties - Security What is the equivalent of that in the new SQL Operations Studio ? Thanks.
unubar
  • 416
  • 6
  • 15
2
votes
0 answers

How to import an .xlsx file into a SQL Server database on MacOS?

I've set up an SQL server using Docker on MacOS computer. I've also installed SQL Operations Studio as a GUI. In SQL Operations Studio I'm trying to import list "Data" from a multiple-sheet AllData.xlsx file into a newly created table "Data_test"…
2
votes
1 answer

SQL Server Profiler, Management Studio and Operations Studio hang after updating XML Data option

I've been using SSMS, SQL Server Profiler and SQL Operations Studio for a while now without issue. However, when some query text (TextData column) was getting truncated in the profiler, I decide to increase the SSMS "XML Data" size to "5 MB". Now…
alan
  • 6,705
  • 9
  • 40
  • 70