SQL Azure Intro and What’s NewLevel: Introductory to Intermediate

Andy ThiruSQL/BI Developer

Agenda

• Overview of SQL Azure• Getting Started with SQL Azure• Administration • Advanced Topic in SQL Azure

• Data Sync• Federation

• Q&A

Windows Azure Platform

Getting Started with SQL Azure

1. Sign Up or Login to Windows Azure2. Create SQL Azure Server3. Create SQL Azure Database4. Setup Schema5. Connect and Access

Getting Started with SQL Azure

demo

SQL Azure – Behind the Scenes

Replica 1

Replica 2

Replica 3

DB

Single LogicalDatabase

Multiple PhysicalReplicas

Administration/Azure Security• SQL Azure Firewalls

• Managing the Login

• Migrating the Database

• Backup

Administration

demo

Data Sync

• Topology• Agent• Security• Database Consideration• Table Consideration

Data Sync

demo

Global Scalability – Data Centers

Summary• SQL Azure is the Windows Azure solution for

highly available, massively scalable, relational data in the Cloud.

• If you’re familiar with SQL Server, SQL Azure will be a natural extension.

• SQL Azure is great for simple relational data storage to more advanced scenarios like BI, Scale and Sync.

Useful Links

• http://wappowershell.codeplex.com/releases/view/84058

Questions