sql azure intro and what’s new level: introductory to intermediate andy thiru sql/bi developer
TRANSCRIPT
Agenda
• Overview of SQL Azure• Getting Started with SQL Azure• Administration • Advanced Topic in SQL Azure
• Data Sync• Federation
• Q&A
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
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
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.