Azure Data Studio is a data management tool that enables you to work with SQL Server, Azure SQL DB and SQL DW from Windows, macOS and Linux.
does Azure Data Studio save the Servers/connection configs to a flat file somewhere? seems like something I'd want to put into source control alongside .sql scripts so someone could just clone and start running scripts
@dkordik the config is save in a json file
on Windows it should be %appdata%\azuredatastudio\User\settings.json
Visual Studio Code has the option to have preferences not only for the user but for the specific folder you have opened, not quite sure if azure data studio has the same feature
it's called workspace settings and it works
just create a file ./.azuredatastudio/settings.json in your folder
Hi - can someone please help with an sql question ???
well, don't ask to ask, just hit us with your question ;)
I have 3 tables
Which is duck, pond and species
Ducks are confortable given their temp limit in the species table
I need to count how many ducks are happy with their habitat
I have done all joins etc
Just need help with extraction part
well, send the table definitions
i am trying to count a column containing integers
but i am having trouble
select androud_num, cells_info, count (*) AS Num_Devices from table where vrs = '71.0.0-rcrq.0.1.4' and dt >='2018-05-17'
can someone please help
@drethegreat1 this doesn't really sound like a sqlopsstudio issue but rather you having issues/questions about SQL in general, however it's pretty hard to help if we don't know the tables and if and which error you got
Hi, I am developing a Azure Data Studio extension. In the extension I am generating some SQLs and currently I just open those scripts in a new file. Is it possible to automatically run the SQL and directly show the table data to the user? Currently once the SQLs are open, the user has to click on Run to execute the SQL
One more guy trying to make an extension inside an azure data studio. Is it possible to make an separate UI inside the ADS- and activate it with extension ? I would use a react for the UI. Are there some more matierials and exapmles on how to make it all work ?
@konstantinmds let me know how it goes, that's exciting!
Hi @dzsquared , i reproduced the code structure and it seems that something is not valid. Here is my project structure in the pic above. Error is that in my out folder i don't get the extension.js file. Do you know where the problem might be ?
@konstantinmds I took a look at the example I shared and got stuck in a similar spot as you - am now working to build a react view manually into a webview extension. will share if I get anywhere
@dzsquared Awesome !
Hi, does anyone have any idea on how to change the snippets
I want to change the contents of sqlCreateStoredProc and sqlCreateTable
@joshuadapitan extensions/mssql/snippets/mssql.json is the file you're looking for; but instead you should probably add a custom snippet; in AzureDataStudio press F1 and type "Configure User Snippets"
Hi. When I connected my account to Azure and it lists all the databases in the subscription, is there a way for it to default the authentication type to Azure Active Directory - Universal with MFA Support when I select a database? It's defaulting to SQL Login, and I'd rather use my Microsoft account. Even if I change the auth every time, it is never remembered