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

Azure Data Studio Profiler doesn't show DBNames and LoginNames

I am using Azure Data Studio-Profiler to get all the events triggered by the users in my organisation, but I am unable to see the Login Name and Data Base Name those fields are populating empty. Can anyone help me is there any setting or any query…
Ravi Kiran
  • 151
  • 1
  • 1
  • 6
0
votes
2 answers

SQL Server 2019 - Connecting to Databricks Cluster using SSMS or Azure Data Studio

Has anyone used SSMS v18.2 or Azure Data Studio to connect to a DataBricks Cluster and so query on DataBricks tables and/or the DataBricks File System (dbfs)? Would like to know how you can set this up to show a DataBricks server in connections…
Ernest Ega
  • 1
  • 1
  • 3
0
votes
1 answer

How to open only selected database in Azure Data Studio connection

Previously in Azure Data Studio, when clicking on a saved connection the application immediately opened the database specified in the connection details. But, now (in recent update?) when clicking on one of the saved connections ADS instead open…
Mystogan
  • 547
  • 4
  • 21
0
votes
0 answers

Distinguishing multiple docker containers on one Mac

I have made two Docker containers using: docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Password1234" -p1433:1433 --name sql2019 -d mcr.microsoft.com/mssql/server:vNext-CTP2.0-ubuntu and I distinguished them by changing the -p and --name section,…
Bytes2048
  • 344
  • 1
  • 6
  • 16
0
votes
2 answers

SQL Server 2019 Polybase Create External Table error "This operation requires PolyBase to be enabled in the target server"

I`m using SQL Server 2019 preview version (15.0.1000.34) with Polybase services installed on localhost/SQL2019 named instance (Windows 10) and Azure Data Studio, I wish to add an External Table from Oracle db (remote server) and getting an error…
Alexey Chibisov
  • 188
  • 1
  • 10
0
votes
2 answers

how to grant permission to execute but not view stored procedure in sql server

I am a developer and want my DBA to give a group of users permissions to execute stored procedures in a schema [Rptg] and view the results but not be able to view the t-sql code in the stored procedure. They will be using Azure Data Studio to…
Marzipan
  • 13
  • 4
0
votes
1 answer

Adding column to select statement brings in all historical data

Good evening all! I'm running into a really odd issue that I'm having trouble understanding. I have 3 tables (parts table, parts move history and a parts detail table). What I'm trying to do is have the result set return lot#,part#,product…
Drezriel
  • 15
  • 3
0
votes
2 answers

Sql Server 2019 Polybase feature issue

I'm trying to configure PolyBase on SQL Server 2019 to test some new features. I already installed this feature and performed all steps from below instruction: Install PolyBase on Windows I get an error notification when trying to configure…
bhuiokmnb7891
  • 3
  • 1
  • 5
0
votes
1 answer

Which server connection is used by query window in Azure Data Studio / SQL Operations Manager

I've recently started using Azure Data Studio (Formerly SQL Operations Studio) instead of SSMS. I can't see an obvious way to tell which query windows relate to which connections. Example: I have 2 DB servers, and each has the same…
Beakster
  • 348
  • 1
  • 12
0
votes
1 answer

Query all rows in server where 2 columns match at least n number of times, with multiple conditions

I have a table in SQL Operations Studio (SQL Server) with columns A, B, C, D. I want to query all rows with the following conditions: EDITED WITH SAMPLE DATA A B C D 1 a b c r 2 g b c r 3 n h f r 4 k u …
thepez87
  • 221
  • 2
  • 12
0
votes
1 answer

How to connect docker SQL Server linux with SQL Operations Studio (in windows)

As I mentioned, I have not managed to connect the container to SQL Operations Studio. I am using docker compose to mount the containers, this is created correctly, but when I enter the credentials in SQL Server Operations Studio, it does not…
chalo
  • 1,019
  • 2
  • 14
  • 27
0
votes
1 answer

Can Microsoft SQL Operations Studio be used to access MYSQL database on Mac?

I am trying to use Microsoft SQL Operations Studio to access a MYSQL database on my local, but am receiving the following error: Error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…
Da Zeemasta
  • 19
  • 1
  • 4
-1
votes
1 answer

How to drop a column default value 'NULL' in Azure Data Studio And add a new constraint on the same column for primary key

I have a table in database (Azure Data Studio)and while writing the create table script I forgot to add the primary key constraint. In order to add primary key constraint I have to alter the table and before that the default NULL has to be removed…
Nezko1
  • 15
  • 4
-1
votes
1 answer

How to connect to a SQL Server from an m1 chip macbook

I am working on a project with a friend and he has deployed a SQL Server database. He uses a PC and can access the database using Microsoft SQL Server Management Studio (SSMS). However I have a Macbook with an M1 chip and so I cannot use SSMS and…
user20451823
  • 1
  • 2
-1
votes
1 answer

How and what can I correct and compete in my tsql code?

Write an SP that, given as input the customer code CustomerID and the category code CategoryID, checks whether or not the customer has placed orders for products in the specified category. In the event that products are found to have been ordered,…
Cepp0
  • 23
  • 4
1 2 3
…
16
17