Amazon RDS vs. SQL Azure

1. Amazon RDS vs. SQL Azure Comparing Cloud Database Offerings Ike Ellis ike@ellisteam.net

2. Agenda • Similarities • Architectural Differences • Pricing • Backup & Restore • Scaling • Database Size • Feature Set • Tooling • Disaster Recovery • Future Roadmap

3. Similarities Web Portal Your App Change Connection String

4. Architecture

5. SQL Azure Architecture SQL Server 2008/Denali*

6. Amazon RDS Architecture • Spins up a dedicated Virtual Machine • Less Cloudy • Built on MySQL/Oracle

7. WINNER: Azure • More cloud for the cloud • Elastic • Service-Oriented

8. Pricing

9. Main SQL Azure Pricing

10. Main Amazon RDS Pricing - MySQL

11. Amazon RDS Pricing - Oracle

14. Both – Additional Charges • SQL Azure • Bandwidth – Ingress/Egress • Amazon • Storage • Bandwidth – Ingress/Egress

15. Amazon Create Database Screen

16. Windows Azure Create Database Screen

17. WINNER: Both

18. Amazon Backup Screen #1

19. Amazon Backup/Restore #2

20. SQL Azure Backup/Restore – Database Copy

21. …but hope for the future

23. WINNER: Amazon RDS • But Azure has a bright future.

24. Two Types of Scaling

27. Amazon RDS Scale Up

28. SQL Azure Scale Up Hope for the future – Dedicated Resources

29. Amazon RDS & SQL Azure Scale Out • Home grow both solutions • Custom Sharding • EnzoSharding • Hope for Future with SQL Azure • Federations

30. WINNER: Draw • SQL Azure wins Scale Out • Amazon RDS wins Scale Up

31. Database Size • SQL Azure • Amazon RDS • Future: SQL Azure promises to bump it up.

32. Winner: Amazon RDS

33. General Feature Set • Amazon RDS = Full MySQL/Oracle instance • SQL Azure = Subset of SQL Server Features • Kinda disappointing • Whole bunch of cloudy features • Data Sync • Marketplace • Odata • Silverlight Management Tool

34. Winner: SQL Azure

35. Tooling

36. Amazon RDS Tooling MySQL WorkBench All the Oracle Tools

37. SQL Azure Tooling • SQL Server Management Studio (No Designers) • SSIS, BCP, SQLCMD, etc • Database Manager (Project Houston – Silverlight)

38. Tooling Winner: SQL Azure (with caveat) • MySQL guys will like the same tooling • SQL Azure has a ton of tools plus opens up their platform to non-SQL developers with the Silverlight tool

39. Disaster Recovery

40. Amazon RDS Disaster Recovery Double the price.

41. SQL Azure Disaster Recovery • Future Roadmap – Different Data Centers

42. Disaster Recovery Winner: SQL Azure • SQL Azure’s DR is all-inclusive

43. SQL Azure Future Roadmap • Very transparent • 30 sessions on SQL Azure at TechEd this year, many of them publicly downloadable • SQL Azure Team Blog is very vocal and open • SQL Azure Reporting Services • SQL Azure Federations • Backup/Restore • Data Sync • CLR/XML Indexes/Designers/New Tooling/New Migration

44. Amazon RDS Future Roadmap

45. Roadmap Winner: SQL Azure • Roadmap is clear and the future looks bright

46. Overall Winner: Draw - Ugh

48. Contact Ike • Email: ike@ellisteam.net • Twitter: @ike_ellis • Blog: blog.ellisteam.net • Website: http://www.ellisteam.net • Phone: 619.922.9801 • User Group: http://www.sdtig.com