In addition to Windows Azure Management Portal, SQL Commands or PowerShell you can also manage your Windows Azure SQL Database using SQL Database Management REST API.
In this article I’ll show you how to connect, authorize and execute REST API commands from your applications.
First of all you need to Create a Management Certificate and upload it to Windows Azure Management Portal.
It’s pretty easy to manage Windows Azure SQL Database firewall rules. In this article I’ll summarize the required steps to add firewall exceptions for your Windows Azure SQL Database.
You can add new firewall rules in 7 easy steps.
For a general overview of securing your Windows Azure SQL Database please check my previous article : Secure Your Windows Azure SQL Database.
You can manage your Windows Azure SQL Database firewall rules using SQL Commands.
There are two types of Windows Azure SQL Database firewall rules
1. Server-Level Firewall Rules 2. Database-Level Firewall Rules
1. Server-Level Firewall Rules
2. Database-Level Firewall Rules
You can manage Server-Level or Database-Level using SQL Commands.
You can run these commands using :
Windows Azure SQL Database is a full featured relational database-as-a-service offering formerly known as SQL Azure.
You can attach more than one subscription with your Microsoft Account and every subscriptions can have more then one Windows Azure SQL Servers and every Windows Azure SQL Server can have more than one Windows Azure SQL Databases.
A simple illustration for provisioning model for Windows Azure SQL Database service. When you create a Windows Azure SQL Server (Note that these are logical servers, not dedicated physical servers), a master database (System Database) has been created by default. You should not put any data in master DB. Master DBs are used for credentials and audit. We’ll need to work with master DBs while securing our database, creating or tracking logins but not for storing our data. Master DBs are free. Every DB in Windows Azure SQL Database services has been replicated between 3 physical servers for high availability. Windows Azure SQL Database Service is using TDS Protocol. TDS Protocol is used by Microsoft SQL Server also. Which means TDS (version 7+) enabled applications should be able to connect to
I’ve talked about Windows Azure SQL Database on our weekly community call, you can reach to the recordings at MEA Windows Azure Champ Call #6 Windows Azure SQL Database.
In this blog entry I’ll cover different methods of Windows Azure SQL Database creation.
1. Create a Windows Azure SQL Database using Windows Azure Management Portal
2. Create a Windows Azure SQL Database using SQL Commands or programmatically
3. Create a Windows Azure SQL Database using Microsoft SQL Server Management Studio or Visual Studio
4. Create a Windows Azure SQL Database using PowerShell
You can also create your Windows Azure SQL Database with SQL Database Management REST API.
Recently, I’m getting a lot of questions about automated scripting capabilities of Windows Azure. Although you can manage your cloud services with Windows Azure Management Portal a lot of scenarios may benefit from advanced scripting features to save time.
Actually it’s really easy to start managing your Windows Azure Subscription with PowerShell. Assuming that you already have a Windows Azure account to manage just follow the steps below
1. You need to go download & install Windows Azure PowerShell cmdlets from Management Downloads page : http://www.windowsazure.com/en-us/manage/downloads/
Today, in our weekly champ call we’ve talked about Windows Azure SQL Database. As you know Windows Azure SQL Database is a full featured relational database-as-a-service offering formerly known as SQL Azure.
In our call, we’ve talked about
A very good opportunity to increase your Windows Azure knowledge, on November 14 attend to the free Windows Azure Conf Event.
What is Windows Azure Conf :
It's a Windows Azure Community Event
Generally, I write about Windows Azure:) But this time, I want to underline a wonderful research presentation, it's about flying robots:)
Yes, it's true "Flying Robots". I've studies Astronautics Engineering years ago and I've always wanted and sometimes tried to achieve such a multi-robot implementation with optical path finding. Maybe this is the reason why I liked it a lot.
I really love the idea of visualization of the technology. If you love tech posters, there is a Windows 8 Application that you'll probably love.
Windows 8 Posterpedia application by Martin Mclean includes posters for
SharePoint, Exchange and off course Windows Azure (this is why I'm suggesting it :)).
Microsoft Corp. and StorSimple Inc. has reached a definitive aggreement to acquire StorSimple.
StorSimple offers intelligent cloud-integrated storage solutions to help customers for creatingstorageanddatacenterexpansionscenarios.
Read more at Microsoft News Center, http://www.microsoft.com/en-us/news/Press/2012/Oct12/10-16CloudPR.aspx
You can start developing Office and SharePoint apps with Windows Azure integration easily.
You can navigate to Start building apps for Office and SharePoint and
Sign up for an Office 365 Developer Site .
After reading Windows Azure Development InfoKit one pager,
probably you'll need more resources to develop your Windows Azure skills.
I've created Windows Azure Resources Folder ( http://aka.ms/pd5evp) to help you quickly developing your skills.
MEA Windows Azure Champ Calls are the easiest and quickest way to be a proud member of cloud computing community. During these calls you can learn and/or share information about Windows Azure and cloud computing, networking with MEA Windows Azure Champs, stay in tune with cloud updates and explore new concepts to realize your ideas.
I know everyone prefers different types of resources, some of them like webcasts/podcasts, others like reading and books and articles or demos or hands on labs.
There are lots of Free Windows Azure EBooks that you can download.
You may find some of them in Windows Azure Resources Folder.
Halo 4 will be released on November 6th.
Halo 4 is the first major game backed by Windows Azure which provides the scalability needed to keep a game like Halo 4 running smoothly for fans around the world.