Windows and SQL Azure Overview

Windows and SQL Azure Overview

Karthikeyan Anbarasan

www.f5debug.Net

Microsoft Mondays @ Mahindra
Satyam

19
th

December 2011

Karthikeyan Anbarasan

•
Microsoft MVP in ASP.NET/IIS

•
Founder of
www.F5debug.Net

and
www.AzureTutorials.in

•
Author, Blogger, Speaker

•
Author of the SQL Server Integration Services Step by Step Tutorials
free eBook

•
MCP, MCAD, MCSD, MCTS

•
Mindcracker and Dotnetfunda MVP

About Me

What we Cover?



Cloud Fundamentals



Windows Azure



Windows Azure Architecture



Windows Azure Components



Windows Azure Demo



SQL Azure



SQL Azure Portal



SQL Azure Demo



Q & A

What is a “Cloud”?

•
Cloud: on
-
demand, scalable, multi
-
tenant, self
-
service compute and
storage resources

Cloud Fundamentals

•
Infrastructure as a Service (
IaaS
):
basic
compute and storage
resources

–
On
-
demand servers

–
Amazon EC2,
VMWare

vCloud


•
Platform
as a Service (
PaaS
): cloud application infrastructure

–
On
-
demand application
-
hosting environment

–
E.g. Google
AppEngine
, Salesforce.com, Windows Azure


•
Software
as a Service (
SaaS
): cloud applications

–
On
-
demand applications

–
E.g. Office 365,
GMail
, Microsoft Office Web
Companions

Cloud Benefits


Managed for You

Standalone

Servers

IaaS

PaaS

SaaS

Applications

Runtimes

Database

Operating System

Virtualization

Server

Storage

Networking

Windows Azure

Windows Azure

•
The Windows Azure Platform is an Internet
-
scale cloud computing
and services platform hosted in Microsoft data centers.

•
Windows Azure Platform includes the foundation layer of Windows
Azure as well as a set of developer services which can be used
individually or together
.

•
Provides the best and most comprehensive platform as a service
offering for building, deploying and running cloud applications.



Open and Flexible

Leverage Existing
Investments

Ready for Next
Generation Applications

Look inside Azure Architecture

•


Azure Components

•


COMPUTE

•
This service
runs the
application

STORAGE

•
This service
stores the
data

FABRIC

•
This service
monitor and
manage
application

Windows Azure Roles

•
Web Role Instance

–
It accepts incoming HTTP and HTTPS Requests

–
It runs on the VM that includes IIS 7.0

–
It can be implemented using ASP.NET, WCF

Input
Http/Https
Request

Web Roles
Instance

ASP.Net UI

Windows Azure Roles

•
Worker Role Instance

–
It does not have IIS Configured.

–
It is not hosted on IIS.

–
It functions like a background job

–
It cannot gets input from outside world directly

–
It takes batch job and runs
indefinately

Input from
Webrole

/
Queue

Worker Roles
Instance

Output to Blob,
Tables and
Queues

Desktop
<==> Azure Concepts

Desktop

•
EXE


•
Application Configuration

•
Manifest

•
DLL

–
Windows Forms Library

–
Windows Service


•
Local Data Stores









Windows Azure

•
Service Package


•
Service Configuration

•
Service Definition

•
Service Role

–
Web Role

–
Worker Role


•
Internet Data Stores









Windows Azure Demo


Building the Application

SQL Azure

SQL Azure

•
SQL Azure Database is a cloud database service from Microsoft.

•
SQL
Azure provides web
-
facing database functionality as a utility
service.

•
SQL Azure is a key component of the Microsoft data platform offering
flexibility and scalability; reliability and security; and developer agility.

•
Cloud
-
based
database solutions such as SQL Azure can provide
many benefits, including

–
rapid provisioning

–
cost
-
effective scalability

–
high availability

–
reduced
management overhead.


SQL Data Storage Services (SDS)

SDS is built on three key pillars

1.
Storage for all data types from birth to archival

2.
Rich data processing services

3.
Operational excellence


•
Scale free

•
High Availability

•
Geo Replication

•
On
-
Demand Service

•
Easy to use

SQL Azure Management Portal


Demo on how to use the SQL Azure Management Portal

Resources & Contact Details

•
You can contact me for any help @
Karthikeyan@f5debug.net

•
For Azure quick starts look at
www.windowsazure.com