Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Mustafa Sadedil
    @sadedil
    Thanks.
    DerSandmann-Badcode
    @DerSandmann-Badcode
    Are all of the tutorials broken?
    The tutorials say to install the debug extension into vscode, but it's trying to run sqlops, intead of azuredatastudio?
    DerSandmann-Badcode
    @DerSandmann-Badcode
    Then again, this is probably dead
    Drew Skwiers-Koballa
    @dzsquared
    If you're looking for a tutorial for building an extension, I put together one: https://www.drewsk.tech/2018/10/11/sql-saturday-796-minnesota-2018/
    Dan Kordik
    @dkordik
    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
    Sebastian Pfliegel
    @SebastianPfliegel
    @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
    Sebastian Pfliegel
    @SebastianPfliegel
    it's called workspace settings and it works
    just create a file ./.azuredatastudio/settings.json in your folder
    Dan Kordik
    @dkordik
    ah great, thanks @SebastianPfliegel ! I didn't realize the Servers would be considered part of the workspace settings (thought that might just be for editor preferences a la VS Code). I see that settings file location in the expected spot from here (I'm on a Mac so slightly different than the above) https://docs.microsoft.com/en-us/sql/azure-data-studio/settings?view=sql-server-2017#settings-file-locations - copied that into my project's .azuredatastudio/settings.json and looks like I'm in business!
    Sebastian Pfliegel
    @SebastianPfliegel
    awesome! :thumbsup:
    drethegreat1
    @drethegreat1
    Hi - can someone please help with an sql question ???
    drethegreat1
    @drethegreat1
    ??
    Sebastian Pfliegel
    @SebastianPfliegel
    well, don't ask to ask, just hit us with your question ;)
    @drethegreat1
    drethegreat1
    @drethegreat1
    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
    Sebastian Pfliegel
    @SebastianPfliegel
    well, send the table definitions
    drethegreat1
    @drethegreat1
    Hi all
    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
    @drethegreat1
    ??
    Sebastian Pfliegel
    @SebastianPfliegel
    @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
    Spoorthi S
    @spoon611
    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
    Sebastian Pfliegel
    @SebastianPfliegel
    @spoon611 the Server Reports extension already does this, maybe you can check out the code: https://github.com/Microsoft/azuredatastudio/tree/master/samples/serverReports
    Drew Skwiers-Koballa
    @dzsquared
    Gerald Britton
    @gbritton1
    Hi! Just wondering if this room is still active?
    Sebastian Pfliegel
    @SebastianPfliegel
    @gbritton1 it sure is
    if you have a question, just shoot
    Gerald Britton
    @gbritton1
    Thanks @SebastianPfliegel ! I see issues in the github ads issue log about Powershell Notebooks but I don't see powershell as a kernel option. What am I missing?
    Gerald Britton
    @gbritton1
    Based on comments here (https://github.com/Jaykul/Jupyter-PowerShell) I think the work for Windows has been abandoned
    konstantinmds
    @konstantinmds
    Hi all, am i too late for asking a question ?
    konstantinmds
    @konstantinmds
    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 ?
    Drew Skwiers-Koballa
    @dzsquared
    @konstantinmds I haven't tried this example - but if I was interested in a react UI inside of ADS I would start here: https://github.com/rebornix/vscode-webview-react
    konstantinmds
    @konstantinmds
    @dzsquared Thank you, i 'll try with it.
    Drew Skwiers-Koballa
    @dzsquared
    @konstantinmds let me know how it goes, that's exciting!
    konstantinmds
    @konstantinmds
    image.png
    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 ?
    Drew Skwiers-Koballa
    @dzsquared
    @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
    konstantinmds
    @konstantinmds
    @dzsquared Awesome !
    Joshua Dapitan
    @joshuadapitan

    Hi, does anyone have any idea on how to change the snippets

    I want to change the contents of sqlCreateStoredProc and sqlCreateTable

    Sebastian Pfliegel
    @SebastianPfliegel
    @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"