AdminMicrosoft SQL Server (Admin, Microsoft Azure)

My feedback

  1. 2 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      under review  ·  1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
      AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

      If I close SSMS uncleanly with documents open, I get a dialog asking me if I want to recover or not. I can choose not to recover some or all of them. Are you saying this dialog takes too long to load, or is not being shown?

      Also, I think you can turn off auto recover altogether in tools\options\AutoRecover

    • 1 vote
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
      • facebook
      • google
        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 →
        AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

        hi Varsham
        I tried to repro your steps and got lost in the step - "Start typing anything.." Could you rephrase it?
        In addition, could you share a screenshot?

        -- Dinakar

      • 2 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
        • facebook
        • google
          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 →
          AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

          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?

        • 69 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
          • facebook
          • google
            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 →

            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

          • 2 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
            • facebook
            • google
              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 →
              AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

              We are looking into this one.

              AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 
            • 6 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
              • facebook
              • google
                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 →
                AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                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.

                AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 
              • 1 vote
                Sign in
                Check!
                (thinking…)
                Reset
                or sign in with
                • facebook
                • google
                  Password icon
                  Signed in as (Sign out)

                  We’ll send you updates on this idea

                  started  ·  1 comment  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
                • 2 votes
                  Sign in
                  Check!
                  (thinking…)
                  Reset
                  or sign in with
                  • facebook
                  • google
                    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 →
                    AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

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

                    AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 
                  • 17 votes
                    Sign in
                    Check!
                    (thinking…)
                    Reset
                    or sign in with
                    • facebook
                    • google
                      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 →
                      AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 
                    • 4 votes
                      Sign in
                      Check!
                      (thinking…)
                      Reset
                      or sign in with
                      • facebook
                      • google
                        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 →
                        AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                        maybe this item becomes combined with this one: https://feedback.azure.com/admin/v3/suggestions/33532654/activity

                      • 33 votes
                        Sign in
                        Check!
                        (thinking…)
                        Reset
                        or sign in with
                        • facebook
                        • google
                          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.

                          AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                          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?

                        • 0 votes
                          Sign in
                          Check!
                          (thinking…)
                          Reset
                          or sign in with
                          • facebook
                          • google
                            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 →
                            AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                            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.

                          • 2 votes
                            Sign in
                            Check!
                            (thinking…)
                            Reset
                            or sign in with
                            • facebook
                            • google
                              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 →
                              AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

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

                            • 15 votes
                              Sign in
                              Check!
                              (thinking…)
                              Reset
                              or sign in with
                              • facebook
                              • google
                                Password icon
                                Signed in as (Sign out)

                                We’ll send you updates on this idea

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

                                I've moved it to the "SQL Server" forum, where this can discovered more easily by us (SSMS feature Team).

                              • 0 votes
                                Sign in
                                Check!
                                (thinking…)
                                Reset
                                or sign in with
                                • facebook
                                • google
                                  Password icon
                                  Signed in as (Sign out)

                                  We’ll send you updates on this idea

                                  1 comment  ·  SQL Server » Suggestions  ·  Flag idea as inappropriate…  ·  Admin →
                                  AdminMicrosoft SQL Server (Admin, Microsoft Azure) commented  · 

                                  Thank you for the suggestion. Vulnerability Assessment can now be run using SSMS 17.4.

                                  AdminMicrosoft SQL Server (Admin, Microsoft Azure) shared this idea  · 

                                Feedback and Knowledge Base