Welcome!

Think first. Code later.

Adam Grocholski

Subscribe to Adam Grocholski: eMailAlertsEmail Alerts
Get Adam Grocholski via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Related Topics: PC Security Journal, Ubuntu Linux Journal, SEO Journal, Azure Cloud on Ulitzer, Security Journal, Telecom Innovation

Blog Feed Post

Azure CLI Day 50 – sql firewallrule show

bash-azure

HAPPY THANKSGIVING!

In my previous post (http://thinkfirstcodelater.com/blog/?p=3490) I showed you how to use the Windows Azure cross platform command line tools to list the firewall rules for a SQL database server. In this post I’ll show you how to use the tools to display the details of a specific firewall rule.

Once again, just a reminder that I’m using the command line tools on a MacBook Air with OSX (Mavericks) installed, and I’m using Google Chrome as my default browser. However, the experience should be identical on Windows and Linux as well.

Open an instance of your command line (Terminal, Bash, Command Prompt, etc.) and type the following:

azure sql firewallrule show -h

Screen Shot 2013-11-01 at 4.31.42 PM

As you can see, the azure sql firewallrule show command is the command to use to show the details of a specific firewall rule. There are two parameters you need to provide:

  • serverName, the name of the SQL database server the rule is attached to.
  • ruleName, the name of the firewall rule.

Enter the following into your CLI, substituting where appropriate:

azure sql firewallrule show ‘[YOUR SQL SERVER NAME]‘ ‘[YOUR FIREWALL RULE NAME]‘

I entered the following:

azure sql firewallrule show ‘thbmcjr7xb’ ‘the internet’

Screen Shot 2013-11-01 at 4.36.15 PM

That’s all for now! In my next post I’ll show you how to delete a firewall rule from a SQL database server using the Windows Azure cross platform command line tools.

Did you know you can try Windows Azure for free for 30 days? Just go to http://aka.ms/thecloud and sign up.

Read the original blog entry...

More Stories By Adam Grocholski

Hey there! My name is Adam Grocholski, and I'm a Technical Evangelist at Microsoft where I spend time focusing on Windows, Windows Phone, and Windows Azure. I live in the frozen tundra of Minnesota and run thinkfirstcodelater.com. You can also follow me on twitter at @codel8r.