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

Problem with consuming modules into my VS Code extension using require('')

I'm having trouble using the standard "require" statement when importing a module from another package in my VS Code extension, targeting Azure Data Studio. I am currently making the call at the beginning of the "activate" function, no other logic…
Rickard Hermansson
  • 11
  • 1
1
vote
2 answers

How to import pyodbc into Azure Data Studio for use in notebook?

I have installed the latest version of Azure Data Studio (1.6.0) I don't have access to a SQLServer 2017/2019, only 2016, but would like to run some Python against it anyways from the notebooks now available in Azure Data Studio. I would use pyodbc…
Peter Tilsted
  • 116
  • 1
  • 11
1
vote
1 answer

How can I extend the window reuse code paths in vscode and Azure Data Studio?

I am working in the microsoft/azuredatastudio github repo, which is largely forked from vscode. I am trying to extend our command line processing to handle the window reuse parameter such that if we pass a server connection along with -r that we…
David Shiflet
  • 53
  • 5
1
vote
0 answers

I could not connect to SQL Server using SQL Operations Studio. azure

Issue Type: Bug I could not connect to SQL Server using SQL Operations Studio. In firewall, I already add my IP address but this software does not detect it. SQL Operations Studio version: sqlops 0.30.6 (df7e3ec, 2018-06-19T21:34:32.192Z) OS…
Naoto Munekiyo
  • 21
  • 4
1
vote
0 answers

SQL Operations Studio on Mac cannot connect to SQL Server

I have a problem with SQL Operations Studio on a Mac. SQL OS cannot connect to a MS SQL Server Database. On the bottom right, the notification "mssql not supported" pops up. When I try to connect to a server, it'll just load endlessly. This is not…
MiepMiep
  • 111
  • 1
  • 9
1
vote
0 answers

share "user settings" between Visual Studio Code and SQL Operations Studio

How can I share "user settings" between Visual Studio Code and SQL Operations Studio? For [a contrived] example, if I set "editor.detectIndentation": false, then that should be reflected in both applications. I'm hoping there's a way to simply have…
Travis
  • 2,135
  • 17
  • 29
0
votes
1 answer

Azure Data Studio 'login failed for user '' with MFA Support authentication

While trying to set up access for a user to access a SQL Server via Azure Data Studio, they are receiving the following error message: 'login failed for user '' The authentication type is 'Azure Active Directory -…
Tscott
  • 465
  • 6
  • 21
0
votes
0 answers

SQL Azure DataStudio shows DB running out space - but when I query the tables they sum to more than allocated space for the DB

I have the following alert. But when i script to show tables and indexes on DB - the result is actually combined much higher than the Max storage size for this DB. I thus, cannot reconcile then where 4.28 GB is remaining.
MoOriginal
  • 49
  • 1
  • 8
0
votes
1 answer

Is there a way to generate table aliases in TSQL statements using SQL snippets in Azure Data Studio?

In a user snippets the following work, SELECT * FROM ${1:TableName} as ${2|a,b,c,d,e,f|} but it only presents you with a list of the 6 letters ( a to f) for an alias like this: SELECT * FROM Currency as a I want the snippet to use the first 4…
callisto
  • 4,921
  • 11
  • 51
  • 92
0
votes
1 answer

Do any keyboard shortcuts work on Azure Data Studio on macOS?

The microsoft ADS docs say F5 is "Run". It does nothing on my macOS.
WestCoastProjects
  • 58,982
  • 91
  • 316
  • 560
0
votes
0 answers

Azure Data studio Build failed. Check output pane for more details. Process was killed with SIGTERM

I am new to Azure Data Studio using latest version 1.45.1 and trying to build a SQL database project. However, I encountered an error: "Build failed. Check output pane for more details. Process was killed with SIGTERM." .There are round 1000 to 2000…
prasad
  • 25
  • 1
  • 7
0
votes
1 answer

Unable to change kernel into Python 3 in Azure Data Studio

Trying to implement Python code in Azure data studio Failed to change kernel. Kernel SQL will be used. Error was: Notebook process exited prematurely with error code: 1. StdErr Output: Traceback (most recent call last): File…
Mr. Pradhan
  • 1
0
votes
0 answers

azure data studio to expand wildcard as column name feature

I knew there was an introduction for expanding wildcard. However, I cannot do this. Does anyone know what is the feature name to amend to the corresponding shortcut key? Or this feature was removed due to some reason? BTW it seems that I cannot hit…
Coty Huang
  • 11
  • 2
0
votes
1 answer

Azure Data Studio use SQL parameters

Is it possible to use SQL parameter markers by specifying the parameter somewhere in Azure Data Studio? For example, a query query.sql like SELECT * FROM table WHERE foo = ? and having the parameter specified somewhere outside the query when run…
qwr
  • 9,525
  • 5
  • 58
  • 102
0
votes
2 answers

Incorrect syntax near AS error in user defined function when trying to create an alias

I created a user-defined function where you put in a code for an object and it finds the minimum of the prices. I'm having trouble on trying to define an alias 'Lowest Price' for the output column. Every time I use AS 'Lowest Price' I get the…
Castaspella
  • 5
  • 1
1 2 3
…
16 17