Questions tagged [azure-data-studio]

Azure Data Studio is a cross-platform database client from Microsoft that enables working with SQL Server, Azure SQL DB and SQL DW

Filter by
Sorted by
Tagged with
0
votes
0answers
29 views

Azure Data Studio PowerShell Error when updating Python

I am trying to do some testing with notebooks and when I open ADS I get prompted to update Python. When I click yes and the install begins, I get this error. Could not start session: Installing ...
0
votes
1answer
51 views

How to change results cell padding in Azure Data Studio

In Azure Data Studio, I am trying to change the padding on the cells in the results grid. According to the settings page, this is editable in the settings.json: However, when I navigate to that file ...
0
votes
1answer
24 views

Using Temp Tables in Azure Data Studio Notebooks

tl;dr I want to use temp tables across multiple cells in a Jupyter Notebook to save CPU time on our SQL Server instances. I'm trying to modernize a bunch of the monitoring queries that I run daily as ...
3
votes
1answer
50 views

How to Parse a query in Azure Data Studio?

In Sql Server Management Studio, we can click a "Parse" button (or Ctrl+F5) to verify that a SQL statement is syntactically correct (without executing it). How can I do it the same in Azure Data ...
1
vote
0answers
16 views

Is there a way Azure data studio to find and add local databases under a list automatically?

When I create a database locally in SSMS it does not show up automatically in ADS. I have to add it as a connection each time. Generally I use SSMS but am trying to switch away (or just try for fun) ...
2
votes
1answer
1k views

How to generate Entity Relationship (ER) Diagram of a on-premises database using Azure Data Studio (macOS)?

I found a similar question for SQL Server Management Studio. But I use latest Azure Data Studio on macOS. We use on-premises SQL Server (not Azure cloud). How can I use Azure Data Studio to generate ...
3
votes
1answer
286 views

Change expired user password on sql server from linux

I have got a colleague (software developer) working on Linux only. He connects to our SQL Server using a sql login with password. Occasionally the password expires and he has to choose a new one. Up ...
1
vote
0answers
705 views

Incorrect syntax near 'BULK' for bulk INSERT in Azure Data Studio

I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is ...