AdminMicrosoft SQL Server
(Admin, Microsoft Azure)
My feedback
-
2 votes
-
1 vote
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
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
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
Upvotes: 1
We are looking into this one.
AdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
-
6 votes
Upvotes: 2
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
-
2 votes
Upvotes: 15
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
this item could be combined with this one: https://feedback.azure.com/admin/v3/suggestions/33531871/activity
-
4 votes
maybe this item becomes combined with this one: https://feedback.azure.com/admin/v3/suggestions/33532654/activity
-
33 votes
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?
-
0 votes
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
Do you mean some other settings than what are included in Tools/Options/Query Results/Sql Server/Results to Grid ?
-
15 votes
We’ll investigate for a future release.
I've moved it to the "SQL Server" forum, where this can discovered more easily by us (SSMS feature Team).
-
0 votes
Upvotes: 0
Thank you for the suggestion. Vulnerability Assessment can now be run using SSMS 17.4.
AdminMicrosoft SQL Server
(Admin, Microsoft Azure)
shared this idea
·
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