By Adam Grocholski |
Article Rating: |
|
November 20, 2013 11:00 AM EST |
Reads: |
1,676 |

In my most recent set of posts in this series I showed you how to use the Windows Azure cross platform command line tools to manage a Windows Azure Mobile Service. I’m now going to change focus and look at how you can use the cross platform command line tools to manage a SQL database. I’ll start by showing you how to create a SQL database server.
%7Cutmccn%3D(direct)%7Cutmcmd%3D(none)%3B&utmu=qB~)
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 server create -h

The azure sql server create command is the command to use to create a SQL database server. There are several parameters/options to specify:
- —administratorLogin. The administrator’s login for the SQL database server.
- —administratorPassword. The administrator’s password for the SQL database server.
- —location. The location where the SQL database server should be created.
- —defaultFirewallRule. Adds a rule to the SQL database server allowing access from Windows Azure.
To create a server in West US, enter the following into your CLI, substituting where appropriate:
azure sql server create —defaultFirewallRule ‘[YOUR ADMIN NAME]‘ ‘[YOUR ADMIN PASSWORD]‘ ‘West US’
I used the following:
azure sql server create —defaultFirewallRule ‘adam’ ‘MY PASSWORD’ ‘West US’

Once the command completes and the SQL database server is created, the name of the server will be in the output of the CLI. You can go to the Windows Azure Management Portal to verify the server has been created.

That’s it for now. In my next post I’ll show you how to use the cross platform command line tools to list your SQL servers.
Did you know you can try Windows Azure for free for 30 days? Just go to http://aka.ms/thecloud and sign up.
IoT & Smart Cities Stories
By Zakia Bouachraoui  At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug... Feb. 20, 2019 05:00 AM EST |
By Yeshim Deniz  Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that deliver strategic business outcomes. Atmosera's expertise simplifies the process of cloud transformation and our 20+ years of experience managing complex IT environments provides our customers with the confidence and trust tha... Feb. 20, 2019 04:15 AM EST |
By Zakia Bouachraoui  The Japan External Trade Organization (JETRO) is a non-profit organization that provides business support services to companies expanding to Japan. With the support of JETRO's dedicated staff, clients can incorporate their business; receive visa, immigration, and HR support; find dedicated office space; identify local government subsidies; get tailored market studies; and more. Feb. 19, 2019 04:15 PM EST |
By Zakia Bouachraoui  At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug... Feb. 19, 2019 10:15 AM EST |
By Pat Romanski  AI and machine learning disruption for Enterprises started happening in the areas such as IT operations management (ITOPs) and Cloud management and SaaS apps.
In 2019 CIOs will see disruptive solutions for Cloud & Devops, AI/ML driven IT Ops and Cloud Ops.
Customers want AI-driven multi-cloud operations for monitoring, detection, prevention of disruptions. Disruptions cause revenue loss, unhappy users, impacts brand reputation etc. Feb. 19, 2019 07:00 AM EST |
By Yeshim Deniz  At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug... Feb. 18, 2019 07:45 AM EST |
By Zakia Bouachraoui  As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations.
Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility.
As they do so, IT professionals are also embr... Feb. 17, 2019 05:00 PM EST |
By Elizabeth White  In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential.
Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at D... Feb. 16, 2019 04:45 PM EST Reads: 14,062 |
By Roger Strukhoff  As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations.
Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. Feb. 14, 2019 05:00 PM EST |
By Elizabeth White  Today's workforce is trading their cubicles and corporate desktops in favor of an any-location, any-device work style. And as digital natives make up more and more of the modern workforce, the appetite for user-friendly, cloud-based services grows. The center of work is shifting to the user and to the cloud. But managing a proliferation of SaaS, web, and mobile apps running on any number of clouds and devices is unwieldy and increases security risks. Steve Wilson, Citrix Vice President of Cloud,... Feb. 13, 2019 08:15 PM EST |