Today is Sunday, so letting us have some fun thing to discuss and think about. If you have not read my earlier blog post SQL SERVER – Connecting to Azure Storage with SSMS. I have discussed about how to connect to the SQL Azure storage via SSMS. Here is a follow up question I have on the same subject.
Question: When we connect to object explorer via the main toolbar menu, we get a prompt where we can connect to Azure Storage but when we open first object explorer why do we see the option to Azure Storage.
To better explain my question, please see the image attached herewith.
Do you have any answer for the same? If yes, please share.
Reference: Pinal Dave (https://blog.sqlauthority.com)
My guess is that the server types visible in the “Connect to Server…” dialog box are all “discoverable” services, i.e. SSMS can enumerate across the network to find out the various server types and then display the server types based on what it can connect to (e.g. Express edition may not be able to connect to all server types) The Object Explorer is directly based on the SSMS capabilities and hence can be hard-coded to show “Azure Storage”.