extending your data to the cloud

EXTENDING YOUR DATA TO THE CLOUD

AGENDA

• What is Windows Azure?• More about SQL Azure• Migrating to SQL Azure• Approach• Tools

• SQL Azure Data Sync?• Why SQL Azure?• Resources

INTRODUCING WESLEY

• Wesley Backelant• Technology Advisor – Data Platform / Business

Intelligence• wesback@microsoft.com• http://www.twitter.com/WesleyBackelant

LET’S GET STARTED

WINDOWS AZURE PLATFORM

GENERAL PURPOSE PROGRAMMING LANGUAGES

Compute

Storage

Management

Marketplace

App FabricCDN

Windows Azure Platform

Relational

databaseData Sync

SQL AZURE – CORE DIFFERENTIATORS

Scale on Demand

Innovate Faster

• Database as a utility with pay as you grow scaling

• Rely on Business-ready SLAs

• Enable multi-tenant solutions

• Manage multiple servers

• Innovate with new data application patterns

• Build cloud-based data solutions on a familiar relational model

• Build on existing developer skills and familiar Transact-SQL syntax

• Platform capabilities delivered as a service (Database, Data Sync, Reporting…)

• Reduced complexity, greater flexibility

• Easy provisioning and deployment

• Auto High availability and fault tolerant

Managed Service

SQL AZURE DATABASE

Global datacenters

High Availability & Redundancy

• Reads are completed at the primary• Writes are replicated to a quorum of

secondaries

Single LogicalDatabase

Multiple PhysicalReplicas

Single Primar

y

MultipleSecondaries

Replic

a 1

Replic

a 2

Replic

a 3

DB

SECURITY IN SQL AZURE

• Logical tenant isolation• Encrypted communication• Firewall rules to accept connections from specific IP addresses•Uses regular SQL security model• Authenticate logins, map to users and roles• Authorize users and roles to SQL object

• Support for standard SQL Auth logins• Username + password

Security model is compatible with on-premise SQL

APPLICATION TOPOLOGIES

From Windows Azure

From Outside Microsoft Datacenter

From Windows Azure & Outside Microsoft Datacenter

Application / Browser

Windows Azure

SQL Azure

Code Near

App Code / Tools

SQL Azure

MicrosoftDatacenter

Code Far Hybrid

Microsoft Datacente

r

SQL Azure

SQL Server

Microsoft Datacenter Windows

Azure

SQL Azure Data Sync

App Code / Tools

MIGRATING TO SQL AZURE

5 step process1. Get SQL Azure account2. Choose your Migration tool

1. SQL Azure Migration Wizard2. Built-in SQL script generation (Including data)3. Data tier application (DACPAC / BACPAC)

3. Migrate4. Change Connection String5. Test , Test, Test

TRANSFERRING LARGE DATA

• Best Practices for efficient Data movement to SQL Azure• Use the right tools is key

o BCP (or SQL Azure Migration Wizard)

• Network performance considerationso Latency vs Bandwidth

• Best Practices on database level• Optimize Databases for Data Import

o Disable/Delay creation of none Clustered Indexeso Order Data on the Clustered Indexo Disable Triggers and Constraint checking

• -N Native mode so no data type conversion needed. o -c Character mode for interoperability

• -b batchsize will let you control transaction size• -h”TABLOCK, ORDER(…)” optimize writes

SQL AZURE MIGRATION WIZARD

• Great Utility for Moving Databases from SQL Server to SQL Azure• Pros

o Parallel uploadso Built in Retry Logico Full control on export and Importo Supports Multiple Languages

• Conso Unsupported

DACPAC VS BACPAC

• Move Schema through application lifecycle and manage databases at scale

• Move Schema and Data through SQL Server and SQL Azure

DEMO – MIGRATING TO SQL AZURE

SQL AZURE DATA SYNC

• No-Code Sync Configuration• Easily define data to be synchronized with

out coding• Choose how often data is synchronized• Handle issues where same data is

changed in multiple locations• Administration capabilities for tracking

data and monitoring potential issues

• Sync Between SQL Azure Databases• Geo-Replication, Read/Write Scale out

• Sync From On–Premises to Cloud• Extend enterprise data to cloud• Build offline cached experiences• Sync with branch offices and mobile

devices

2

DEMO – DATA SYNCING

WHY SQL AZURE

Best TCO• Designed for Internet Scale

• High Availability Built in

• Transparent maintenance

Familiar and Productive

• Less Complex; Better value

• Developer platform and broad ecosystem

Unique Innovation

• BI as a service• Data Sync

RESOURCES

• SQL Azure Migration Wizard• SQL Azure Labs• Windows Azure

© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after

the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

© 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after

the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.