Windows and SQL Azure Overview

adhocjackpotSecurity

Nov 5, 2013 (4 years and 3 days ago)

93 views

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