Viewing Windows Azure Storage using SSMS December 2nd, 2013

Vinod Kumar

Moving to cloud enabled services is inevitable and in my day job I get a chance to work on various technologies including Windows Azure. One of the tools I use big time is the Azure Storage Explorer. This is an awesome tool when we need to view or storage account. When playing around with SQL Server SSMS, I found it interesting to see we can query and look at Azure Storage using SSMS itself (lesser known to many – available even with SQL 2012). This was an interesting hidden gem which I thought was worth sharing with all.

To start this journey, the first step is to get the details of your storage account. On your Azure portal, Select “Storage”, Select the “Storage account” (mtcvinod in my example) and Select “Manage Access Keys”.

You will be presented with the Access Keys to your storage account. I have greyed out the values for obvious reasons you can guess :) … Select the “Copy” Button (before the regenerate button and close the dialog.

Now we have all the required information to start our SQL Server Management Studio. Goto Object Explorer – > Connect –> Azure Storage … This is shown below.

We will be presented with the dialog to what Storage account. Key-in your storage account and the Account Key you just copies from the above step. Click on Connect and we are good.

Now you will see the tree view structure on your SQL Server Management studio to all the blobs and objects inside that storage account.

I know this is just a start to viewing the Azure Storage account but the Azure Storage Explorer does a lot more than what SSMS can do. But given the quick access to this can always prove to be handy. Do let me know if you have every used this feature in your environments.

Tags: , , , , , , ,

This entry was posted on Monday, December 2nd, 2013 at 14:40 and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “Viewing Windows Azure Storage using SSMS”

  1. Jack Owens says:

    Hey Vinod

    I read your blogs as often as I can, thanks in advance for all postings
    I read this one ” Viewing Windows Azure Storage using SSMS”

    1) How about you create simple Videos & post them on YouTube, that will speed-up our reading by watching the video
    2) YouTube provided “PlayList” option, which you can use to CLUB all relevant videos

    My 2 cents:)

    • Vinod Kumar says:

      I have had this idea for a long time, but just that I have not got around the fact of doing video based editing extensively. I will surely consider this in the future more seriously. Thanks again for your note and taking time.

  2. […] shared 3 times • Viewing Windows Azure Storage using SSMS | Vinod Kumar (Blog home) […]

Leave a Reply