SQL Azure Database: Present and Future

1. SVC52 SQL Azure Database: Present and Future Dave Campbell Technical Fellow Tony Petrossian Principal Program Manager

2. Agenda • SQL Azure Overview • Service Roadmap • SQL Azure Database Future • SQL Azure Future

3. The Power of the SQL Data Platform in the cloud • Leverages existing skills and rich tooling ecosystem • Enables database applications with new, “cloud” capabilities Reporting Business Analytics Data Sync Database Database SQL Data Platform as a Service – beyond hosting

4. SQL Azure Database Highly scaled out relational database as a service • Relational database service • SQL Server technology foundation • Highly symmetrical • Highly scaled • Highly secure • Database “as a Service” – beyond hosting Browser Database SOAP/REST HTTP/S ADO.NET/REST - EDM HTTP/S MS Datacenter Windows Azure Compute App Code (ASP.NET) • Customer Value Props • Self-provisioning and capacity on demand • Symmetry w/ on-premises database platform • Automatic high-availability and fault-tolerance • Automated DB maintenance (infrastructure) • Simple, flexible pricing – “pay as you grow” SQL Server Report Server (on-premises) T-SQL (TDS) T-SQL (TDS) SQL Azure Database - AD Federation (LiveId /AppFabric AC)

5. Skip This Ad  SQL Azure Service Provisioning • Each account has zero or more servers • Azure wide, provisioned in a common portal • Billing instrument • Each server has one or more databases • Contains metadata about the databases • Unit of authentication and security • Unit of Geo-location • The server is a logical grouping of your DBs • Each database has standard SQL objects • Unit of consistency • Contains users, tables, views, indices, etc… • Go See Jeff Currier’s Session: • Microsoft SQL Azure Database: Under the Hood (SVC12) Account Server • Go See Tony Petrossian’s Session: • Development Best Practices and Patterns for Using Microsoft SQL Azure Databases (SVC08) Database

6. SQL Azure Database demo A view from tools & Portal

7. Timeline • South Central USA • North Central USA (Dec-2009) • Southeast Asia • North Europe Additional sub-regions will be deployed in lock-step with Windows Azure Platform Global Availability First half of the year Service UpdateRhythm Service Update Service Update Service Update Service Update Service Update Service Update Second half of the year

8. SQL Azure Database Future

9. SQL Azure Database: Future Our goal is to provide the best end-to-end experience for enterprise departmental apps and SaaS ISV scenarios • Improve Tools • For Developers & Designers to build apps • For Administrators to manage the database lifecycle

10. Skip This Ad  Tools, Clients, Languages • Go See David Robinson’s Session: • The Future of Database Development with SQL Azure • (SVC27) • Announcements to be made….. • Today With the existing SQL Server ecosystem we have a fantastic start for our V1 offering • VS, SSMS, ADO.NET, ADO.NET Data Services, PHP, Java… • But we are also making huge investments for the future

11. SQL Azure Database: Future Our goal is to provide the best end-to-end experience for enterprise departmental apps and SaaS ISV scenarios • Improve Tools • For Developers & Designers to build apps • For Administrators to manage the database lifecycle • Improve the operational model for enterprise users and SaaS providers • Backups, integration with on-prem…

12. Database Backups X • Customer application or administrator errors leading to data loss • Use BCP, SSIS or other custom tools to backup data • Today • Customer • Database clone to create on-demand, backups of databases in the local or remote SQL Azure region • Cloning is done with transactional consistency • When clone operation is complete the replica is accessible as a normal database • 1H 2010 • Customer

13. Database Clone South Central US North Central US efg.database.windows.net xyz.database.windows.net Master prod1 Prod2 prod2 clone prod2 clone DR1 Master prod2 clone prod2 clone abc.database.windows.net Master Dev1 prod2 clone prod2 clone CREATE DATABASE efg.prod2clone AS CLONE OF xyz.prod2 CREATE DATABASE xyz.prod2clone AS CLONE OF xyz.prod2 CREATE DATABASE abc.prod2clone AS CLONE OF xyz.prod2

14. Database Backups X • Customer application or administrator errors leading to data loss • Use BCP, SSIS or other custom tools to backup data • Today • Customer • Database clone to create on-demand, backups of databases in the local or remote SQL Azure region • Cloning is done with transactional consistency • When clone operation is complete the replica is accessible as a normal database • 1H 2010 • Customer • Continuous Backup option with point-in-time restore capabilities • Configurable retention and lag period • Backups available for read operations • Local or remote region • 2H 2010 • Customer enables and configures it. • Service will maintain it

15. Skip This Ad  Operational Models • Go See Mark Scurrell’sSession: • Using the Microsoft Sync Framework to Connect Apps to the Cloud (SVC23) Skip This Ad  • SaaS: • SQL Azure is a highly available and scalable database service and an excellent option for building and managing multi-tenant services. Go See Ben Riga’S Session: Lessons Learned: Building Multi-Tenant Applications with the Windows Azure Platform (SVC33) • Support for SaaS providers • Provisioning APIs for ISVs • Template database support • Meta-data tracking • Additional billing scenarios • Enterprise: • integration with on-premises environments • Single unit for deployment and upgrades (DAC) • Data Synchronization • Upgrade and downgrade options between SKUs • Read only databases

16. SQL Azure Database: Future Our goal is to provide the best end-to-end experience for enterprise departmental apps and SaaS ISV scenarios • Improve Tools • For Developers & Designers to build apps • For Administrators to manage the database lifecycle • Improve the operational model for enterprise users and SaaS providers • Backups, integration with on-prem… • Improve the application programming model • Simplify the building of highly scalable applications • Further improve symmetry with on-premises SQL Server

17. Scale-out Support - Today • Database and workload partitioning is a classic technique for harnessing the power of many computers to achieve: • Better price/performance • Levels of throughput not possible with a single machine • But: • Managing clusters is much harder than one giant machine • Developing applications for scaleout requires more investment • Classic scale-out challenges addressed by SQL Azure: • Highly available service on top of commodity hardware • Zero administration cost of cluster HW, OS and SW • No downtime • Access to elastic pool of resources • Pay as you grow • No-friction provisioning of databases • Create databases without ever running out of HW

18. TicketDirect Architecture Client Applications Azure Roles .Net Service Bus • Castellan.Azure • Box Office sales • Ticket Printing • System Administration • Venue/Event Management • Partitioning WCF Distributed Cache Worker MemCache http:// TicketDirect .* Dynamic Worker (tasks uploaded as blobs) PartitionerWorker On PremiseSQL Server Azure Storage -- - --- - - Blobs to store web and worker role resources Tables to record server & partition information Queues for communication between clients and roles -- - --- - - Castellan Venue Skip This Ad  • Go See David Robinson’s Session: • Scaling out Web Applications with Microsoft SQL Azure Databases (SVC06) Castellan.old (VB6) Skip This Ad  SQL Azure • Thanks to Chris Auld for the Slide. • If you want to ask Chris how they built TicketDirect stop by at the SQL Azure lounge today. Castellan Venue DB Castellan Venue DB Castellan Venue DB Castellan Venue DB’s Castellan Venue DB’s Castellan Venue DB’s Castellan Venue 1 Partition(s) Venue 2 Partition(s) Venue N Partition(s) ... One application DB, many venue DB’s – each partitioned in to many parts (40+)

19. More Scale-out Support • Dynamic database splits • Ability to merge databases • Improved schema management across group of databases • Additional database size options • Database Features for scale-out application patterns: • Multiple database connection management • Support for fan-out query to multiple databases G1 G2 G3 G5 G6 G4 G10 G7 G8 G9

20. SQL Azure Database Fan-out Demo

21. Recent Customer Feedback/Requests We have been using customer feedback to shape the SQL Azure offering over the last 16 months We will continue to do so in the future • Add support for profiler, DMVs … • Support for Spatial data types • Full-text search support • Change Tracking support • Support for CLR • Cloud based Business Intelligence (BI) solutions • Encryption support • Additional Authentication models for login (WIF) Come give us your feedback at the SQL Azure Lounge

22. Take Away • Database as a service • Lower TCO • Automatic High Availability • Automatic maintenance • Instantly scale up or down databases as needed • Metered by database • Secure database with familiar AuthN/AuthZ model • Mission-critical SQL Server foundation

23. Trustworthy Data Collaboration SQL Azure Codename ‘Vidalia’ Dave Campbell Technical Fellow Microsoft Corporation

24. Sharing to trustworthy collaboration Cloud is great place to connect Empowers multiple parties Businesses need control Enable trustworthy collaboration for highly sensitive business data across disparate trust domains

25. Control of sensitive business data Current Enterprise • Control of infrastructure • Control of policy & enforcement • Control of data Data Enforcement Policy Infrastructure

26. Control of Sensitive Business Data SQL Azure • Limited infrastructure control • Control of policy & enforcement Enforcement Policy • Trustworthy collaboration with sensitive business data Data Enforcement Enforcement Enforcement Policy Policy Policy Infrastructure

27. SQL Azure Codename ‘Vidalia’ Collaboration needs Approach • PrivacyData and query • Data-centric securityPolicy-based data encryption • ControlPolicy and enforcement • Federating accessSeparating data control from store • AccountabilityData integrity and auditability • Audit as a serviceAudit logs with controlled accessTamper detection

28. Trustworthy Collaboration Example Audit logs Sensitive Business Data SystemAdministrators Auditors Sensitive business data Sensitive business data Capability Generation Center • Separates data control from store Privacy Collaboration with sensitive data • Issues capabilities to encrypt/decrypt data Control Subscribers PublishersData Owners • Empowers customers and partners Accountability

29. Pharmaceutical Reagent Data Mart demo Rahul Auradkar Director Microsoft Corporation

30. Trustworthy Collaboration Scenarios eHealth Business and legal compliance Regulated data transfers Trusted audit log Pharma clinical trial SQL Azure Codename ‘Vidalia’

31. Take Away • SQL Azure Codename ‘Vidalia’emerging approach to trustworthy collaboration • Privacy provided through data-centric security • Separating access enforcement from data service puts data owner in controlof data • Audit as a service and tamper detection methods enable accountability vidalia@microsoft.com

32. YOUR FEEDBACK IS IMPORTANT TO US! Please fill out session evaluation forms online at MicrosoftPDC.com

33. Learn More On Channel 9 • Expand your PDC experience through Channel 9 • Explore videos, hands-on labs, sample code and demos through the new Channel 9 training courses channel9.msdn.com/learn Built by Developers for Developers….