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/
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.
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.
Securing your data is important and you have lots of options in Windows Azure SQL Database according to your needs.
If you read my previous article Windows Azure SQL Database - How to create Windows Azure SQL Database you know basics of creating your Windows Azure SQL Database. In this article, I’ll focus on securing your database and data.
Windows Azure SQL Database is a relational database-as-a-service. So, it’s obvious that you are not managing your database server physically, you can’t touch it but it’s still secure and you can always manage security related features according to your requirements.
First of all, I want to say that there are two security layers in Windows Azure SQL Database service : Network Layer and Database Layer.
1. Network Layer Security: You can configure IP based firewall rules to grant or deny connections to your service. There are two types of rules : Server-Level Firewall Rules and Database-Level Firewall Rules.
I’ve summarized Windows Azure SQL Database security topic in my previous post Secure Your Windows Azure SQL Database.
In this article, I’ll show you interesting scenarios that you can use with your applications or services. I’ll share you how you can apply the following scenarios.
I think best way to learn something is to try it. Cloud computing and Windows Azure doesn’t need to learn lots of things. It’s pretty easy and I think you’ll see this if you start trying it.
When it comes to try it, I think most of the people doesn’t have any clue about Windows Azure Free Offers.
Currently Windows Azure has lots of offering and I’ll give you a quick brief about Windows Azure offers.
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 :
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.
Windows Azure Mobile Services is state of the art cloud backend for all kind of applications.
Today, I’m really excited to announce that Windows Azure Mobile Services now supports any applications.
Windows Azure Mobile Services is running on Node.js and Windows Azure SQL Database.
You can benefit from Windows Azure Mobile Services while developing all kind of applications :
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.
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
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 :)).