AdminMicrosoft SQL Server (Product Manager, Microsoft Azure)

My feedback

  1. 6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    unplanned  ·  1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Hello
    Please use Debugging feature in SSDT. TSQL Debugging has been deprecated for now.

  2. 6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Sorry folks, but we are not able to repro this issue (either using SSMS 17.9.1 or SSMS 18 Preview 7).

    Since multiple people out there are reporting this issue, it is obvious that we are missing something that is specific to your environment or configuration.

    Could you help us out and try to describe a little better your subscription/environment/account/permissions?

    For example, does the following mainstream scenario works for you all:
    1) Connect to Azure Portal
    2) Create SQL server+database
    3) Go to SSMS and connect to
    4) Add firewall rule

    If it does, then can you identify what is different between the case where it works and the case where it does not?

    Thanks,
    -Matteo

    Please try with latest GA - 17.9.1 or 18 Preview 6 and post back if you still see the issue.

  3. 2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    In the first case:
    EXEC sp_execute_external_script @language = N’Python’,
    @script = N’import re, pandas
    Ret = InputDataSet
    Ret[“an”] = pandas.Series([re.sub(”[^0-9]”, “”, i) for i in Ret[“an”]], index = Ret.index, dtype = “int32″)‘,
    @input_data_1 = N’SELECT an FROM alphanum’,
    @output_data = N’Ret’

    we would treat @output_data as a user defined parameter and expect the params clause. There is no way for us to know whether @output_data is a misspelling of @output_data_1_name or the user wants a parameter @output_data.

    There are two issues in the second example:
    EXEC sp_execute_external_script @language = N’Python’,
    @script = N’import re, pandas
    Ret = InputDataSet
    Ret[“an”] = pandas.Series([re.sub(”[^0-9]”, “”, i) for i in Ret[“an”]], index = Ret.index, dtype = “int32″)‘,
    @input_data_1 = N’SELECT an FROM alphanum’,
    @output_name = N’Ret’,
    @params = N’@Ret int’

    @params should be before @output_name and should contain the declaration of the @output_name parameter, not the value N'Ret'. Something like:

    EXEC sp_execute_external_script
    @language = N'Python',
    @script = N'...',
    @input_data_1 = N'SELECT an FROM alphanum',
    @params = N'@output_name nvarchar(max)',
    @output_name = N'Ret'

  4. 4 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    9 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Thank you for reporting this. This will be fixed in the next CU for SQL Server 2016 SP2.

  5. 5 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    need-feedback  ·  4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Does this happen consistently or only the first initiation of SSMS?
    Also, please share version info for SSMS/SSIS and what instances they are connecting to so we can figure this out.

    thanks,
    Dinakar

  6. 2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Could you validate if the issue exists with the latest version of SSMS - 17.9.1 and post back?
    Also, please validate with SSMS 18 Preview 5.

    thanks
    Dinakar

  7. 11 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  SQL Server » Setup + Deployment  ·  Flag idea as inappropriate…  ·  Admin →

    Upvotes: 51

    <=-=Nov 11 2014 11:50AM=-=>

    I agree with Keith. I also manage multiple SQL Server instances. This is a persistent annoyance for nearly the last decade.

    <=-=Jan 6 2015 1:21PM=-=>

    The bug is over 10 years old. The SSMS team keeps saying they can’t reproduce it. It feels like they never actually use their product.

    Problem seems to occur more frequently when you store multiple remote servers. It’s probably very reproducible once you have 3 remote servers stored.

    Microsoft did try to contact me directly and use LiveMeeting to my computer. If I recall right, Microsoft couldn’t get LiveMeeting to work and then they pretty much abandoned attempting to fix this and claimed they cant repro it. I was working with chandrag@microsoft.com .

    <=-=Mar 7 2015 10:05AM=-=>

    This issue is so annoying. My SSMS 2014 remembered my DB’s password for maybe 2-3 weeks and it hasn’t remembered it since…

    We made some improvements in this area for SSMS 18.
    Could you see if you can repro the issue with the latest Preview 5?

    thanks,
    Dinakar

  8. 5 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Do you get any syntax error when creating Certificates or Keys?

    Thanks,
    Dinakar

  9. 4 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    need-feedback  ·  2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    The error you report indicates that we are unable to read the Vulnerability Assessment rule store which is embedded as a resource in one of the SqlServer module’s dlls.
    Unfortunately, we have been unable to reproduce this error. Perhaps you can provide some more information on how to reproduce. Specifically:
    1. What environment are you running on? Are there any special restrictions applied to your PowerShell environment?
    2. Have you tried on other machines? Does it reproduce there too?
    3. Are you running just the Invoke-SqlVulnerabilityAssessmentScan cmdlet or is something taking place before that? What happens when you just run the one command?
    4. Any other information that you think may be pertinent to reproducing?
    Thanks

  10. 2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    need-feedback  ·  1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    so this is a bit lame but in SSMS 17.x you need to set this environment variable to the DNS suffix of blob storage for the cloud you want: AZUREBLOBDNSNAME
    The default is blob.core.windows.net.
    For US Government cloud I think you would set AZUREBLOBDNSNAME environment variable to "blob.core.usgovcloudapi.net"

    I think this is fixed in the SSMS 18 preview, can you try it there?

  11. 97 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    this is the current list from the v18 NuGet

    Microsoft.SqlServer.ConnectionInfo.dll
    Microsoft.SqlServer.Management.Dmf.dll
    Microsoft.SqlServer.Management.Sdk.Sfc.dll
    Microsoft.SqlServer.Management.SmoMetadataProvider.dll
    Microsoft.SqlServer.Management.XEvent.dll
    Microsoft.SqlServer.Management.XEventDbScoped.dll
    Microsoft.SqlServer.Management.XEventDbScopedEnum.dll
    Microsoft.SqlServer.Management.XEventEnum.dll
    Microsoft.SqlServer.Smo.dll
    Microsoft.SqlServer.SmoExtended.dll
    Microsoft.SqlServer.SqlEnum.dll

  12. 3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    We are looking into this one.

  13. 6 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    There's a devious way to change the server name in the connection dialog - switch to the Additional Connection Parameters tab and add "Data Source=servername,portnumber"
    That may not unblock this entire scenario, though.

  14. 3 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
  15. 2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Do you happen to know if visual studio 2013/2015 exhibit the same behavior?

  16. 25 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  2 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  17. 4 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    planned  ·  3 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
  18. 35 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    Hi, thanx for the feedback.
    As Ben points out, if you know which fields on the Database object you need, you can use Server.SetDefaultInitFields to make sure the collection is initialized with all those fields in the first query.

    Is there a particular scenario, using the latest SMO NuGet, where use of SetDefaultInitFields isn’t sufficient to speed up the query noticeably?
    If you have an Intellitrace or XEvents trace I could use for reference it’d be a great help.

    we've made changes to the "bad query" in recent versions of SMO to improve the worst case time. Previous versions where joining on DMVs like db_hasaccess and such that really slowed things down. Do you see any improvement in recent SMO NuGet package versions?

  19. 1 vote
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  2 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →

    When you close a query window SSMS tries to ping the server to see if the connection has any open transactions. Depending on your connection string and the version of the .Net framework installed, the version of SQL connected to, etc, making that connection active after a long idle period can take some time.

  20. 2 votes
    Sign in
    (thinking…)
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    need-feedback  ·  3 comments  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →

    Do you mean some other settings than what are included in Tools/Options/Query Results/Sql Server/Results to Grid ?

← Previous 1

Feedback and Knowledge Base