windows azure sql database and storage name title organization

Windows Azure SQL Database and StorageNameTitleOrganization

Applicationbuilding blocks

StorageBig data

Caching

CDN

Database

Identity

Media

Messaging

Networking

Traffic

Big Data

SQL Server in a Virtual Machine

Azure SQL Database

Azure Table Storage

Azure Blob Storage

Azure Data Management

SQL Server in a Virtual Machine

Azure SQL Database

Azure Table Storage

Azure Blob Storage

Azure Data Management

A Continuous Offering From Private to

Public Cloud

PaaS SaaSPhysical Virtual IaaS

Windows Azure SQL Database

SQL Server in a Virtual Machine

Full SQL Server capability

Low TCO for existing apps

Flexibility & control

Managed infrastructure

Backup database to the cloud

Extend on-prem applications

Common Scenarios

Develop & test

Public Cloud

Move existing tier 2 & 3 apps

SQL Server 2012 in Windows Azure Demo

SQL Server in a Virtual Machine

Azure SQL Database

Azure Table Storage

Azure Blob Storage

Azure Data Management

Windows Azure SQL Database

Relational Data StorageRelational database as a serviceFully managedHigh availability, scalability, & global reachFamiliar language and framework support

Familiar and Consistent ToolsUse familiar technologiesSupports Transact-SQL

Supports popular languages.NET Framework (C#, Visual Basic, F#) via ADO.NET

C / C++ via ODBC

Java via Microsoft JDBC provider

PHP via Microsoft PHP provider

Supports popular frameworksOData, Entity Framework, WCF Data Services, NHibernate

Supports popular toolsSQL Server Management Studio (2008 R2 and later)

SQL Server command-line utilities (SQLCMD, BCP)

CA Erwin® Data Modeler

Embarcadero Technologies DBArtisan®

Windows Azure SQL Database Demo

Backend Node Replica 1

SQL DB

Backend Node Replica 2

SQL DB

Backend Primary Node

SQL DB

Inside Windows Azure SQL Database

Scalability and Availability: Fabric, Failover, Replication, and Load balancing

1 New Database Request

2Primary & Replica Databases Created

TDS Gateway

Front-end Node

TDS Session

SQL Federation

Scale Out Your DataIntegrated database partitioningMulti-tenancy via flexible repartitioningAdd and remove database nodes seamlesslyEnables greater scalability and performanceDynamic partitioning with no downtime

SQL FederationDemo

SQL Reporting

Visualize Your DataReporting delivered as cloud serviceElastically scales with demandFamiliar tools & programming modelSecurely view & manage reports

SQL Data Sync

Synchronize Your DataDatabase synchronization as a serviceOn-premises & Azure SQL DatabaseConfiguration drivenElastically scales with demand

Azure SQL Databases

SQL Server (On-Premises)

SQL Server in a Virtual Machine

Azure SQL Database

Azure Table Storage

Azure Blob Storage

Azure Data Management

Storage in the CloudScalable, durable, and availableAnywhere at anytime accessOnly pay for what the service uses

RESTful Web ServicesUse from Windows Azure ComputeUse from anywhere on the internet

Windows Azure Storage

Storage Libraries in Many Languages

Service FeaturesShared Access Signatures for Tables and QueuesExpanded Blob CopyImproved Blob Leasing

Improved ManageabilityLocally Redundant StorageGeo or Locally Redundant StorageStorage Analytics ConfigurationStorage Metrics Monitoring

New Features

SQL Server in a Virtual Machine

Azure SQL Database

Azure Table Storage

Azure Blob Storage

Azure Data Management

Azure Table Storage

NoSQL Data StorageFully managed PaaSKey-valueHierarchicalREST APIGeo replication

Storage Account: MovieData

Star WarsMatrixFan Boys

Table Name: Movies

Entity

Table

Account

Table Storage ConceptsEntityTableAccount

contoso

Name =…Email = …

Name =…EMailAdd=

customers

Photo ID =…Date =…

photos

Photo ID =…Date =…

No Fixed Schema

FIRST LAST BIRTHDATE

Wade Wegner 2/2/1981

Nathan Totten 3/15/1965

Nick Harris May 1, 1976

FAV SPORT

Canoeing

SQL Server in a Virtual Machine

Azure SQL Database

Azure Table Storage

Azure Blob Storage

Azure Data Management

Azure Blob Storage

Unstructured Data StorageManaged serviceHundreds of gigabytes per blob in size 100TB per storage accountREST APIGeo-replication for disaster recovery

Blob Storage Concepts

BlobContainerAccount

http://<account>.blob.core.windows.net/<container>/<blobname>

Pages/ Blocks

contoso

PIC01.JPG

Block/Page

Block/Page

PIC02.JPG

images

VID1.AVIvideos

Windows Azure Storage Demo

Azure Storage Architecture

VIP

FE FE

FEFEFEPartition Master(s

)

Distributed File System Layer

FE

Partition Server

Partition Server

Partition Server

Partition Server

Legend

Partition

ServerLoad

3 Storage Layered Architecture

Scalability

Partition: Range of entities with same partition key value.Partitions are fanned out based on loadThey can be condensed when load decreasesReads are load balanced against three replicas

Server 1 Server 2 Server 3

P1

P2

Pn

PartitionKeyUnique identifier for the partition within a give table.

RowKeyUnique Identifier for an entity within a given partition.

Both Keys matter!Define Primary KeyForms a single clustered index

Scalability

SlowestNo Partition KeyNo Row Key

SlowerOnly Partition KeyNo Row Key

Very FastPartition Key + Row Key

Hadoop On Windows Azure

Azure Blob Storage

Hadoop Cluster

Unstructured Data StorageManaged serviceJavascript console simplifies developmentIntegrate data with Hive ODBC driver Excel integrationPreview: M/R, HDFS, Hive, Pig, Streaming & more

SummaryCloud services for the new world of data

Managed Services

Breadth of data types and programming models

Cloud on your terms

Highly available and scalable

SQL Database Billing Rates (As of February 2012)

Database Size Price Per Database Per Month

0 to 100 MB Flat $4.995

> 100 to 1 GB Flat $9.99

> 1GB to 10 GB $9.99 for first GB, $3.99 per additional GB

> 10 GB to 50 GB $45.954 for first 10 GB, $1.998 for each additional GB

> 50 GB to 150 GB $145.874 for first 50 GB, $0.999 for each additional GB

Data TransfersNorth America and Europe regions $0.05 - $0.12 per GB outbound

Asia Pacific region $0.12 - $0.19 per GB outbound

All inbound data transfers are at no charge.

Based on graduated rate based on database sizeCharged at monthly rate per database

Amortized over month -> calculated on daily basis

No Transaction Charges