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
10 views

How can you see PostgreSQL procedures in Azure Data Studio?

If I use pgAdmin 4 to query PostgreSQL, I can see procedures section under materialized views. But, If I use Azure Data Studio I cannot see the procedures section. Any idea how to get to see the ...
1
vote
2answers
36 views

Alternative to SQL Server Management Studio and Azure Data Studio to initially change my password

Background I'm having to connect to a customer's Microsoft SQL Server. I generally don't need to do much in databases besides your average SQL, so using the database features in IntelliJ IDEA have so ...
0
votes
1answer
24 views

Check constraint age 18< [closed]

Hello I need to create a constraint that chekc the user is 18< before listenning to certain songs but idk how... I tried this : ALTER TABLE Historique_ecoute DROP CONSTRAINT IF EXISTS ...
0
votes
0answers
22 views

CommandLine for Exporting All MS SQL Tables to CSV

On my Mac, I have a docker container running an Ubuntu version of MS SQL. I have a DB running in it and I can access it via Azure Data Studio, and I can view each table individually and export it to ...
0
votes
0answers
45 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
225 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
110 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
112 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
17 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) ...
3
votes
2answers
2k 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
358 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
846 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 ...