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
    Thank you @kburtram, no problem
    Aamer Khan Mohammed
    @Aamer_Khan_gitlab
    Hi
    after installing the app white screen is appearing with a menu bar and nothing is working
    image.png
    does anyone get this issue ?
    Sebastian Pfliegel
    @SebastianPfliegel
    The readme file links to the non existent https://gitter.im/Microsoft/azuredatastudio
    Karl Burtram
    @kburtram
    @SebastianPfliegel thanks for letting me know. This was a find\replace error that I'll correct. I could see how to transparently rename this Gitter
    Victor Hugo Garcia
    @vhugogarcia
    Hello friends!
    Excuse me, do you know if Azure Data Studio supports Graph DB?
    Mustafa Sadedil
    @sadedil

    Hi everyone, i'm trying to implement Save as XML feature for the AzureDataStudio. Firstly i've contributed to SqlToolsService project and my Pull Request was accepted. Then i've forked the AzureDataStudio and made the code changes. But when trying to execute my scenario i'm getting an error at this line return this._queryManagementService.saveResults(saveResultsParams)

    But the worst part of this error, i'm getting the error object value as null. So i don't have any clue, what's wrong or where is wrong?

    My question below:

    image.png
    Question: Is there any way to debug sqltoolsservice and azuredatastudio together?
    I need to put breakpoint to sqltoolsservice to see what's happening inside.
    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?
    https://docs.microsoft.com/en-us/sql/azure-data-studio/tutorial-create-extension?view=sql-server-2017 this documentation seems out of date
    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
    @spoon611 this is possible, here's the API function I believe you would use: https://github.com/microsoft/azuredatastudio/blob/d74c2d6c8d637d07e251183f50c02d949b497859/src/sql/azdata.proposed.d.ts#L4001
    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