Introduction to SQL Azure via PHP

1. Introduction to SQL Azure via PHP Brian Swan PHP Developer Outreach, Microsoft @brian_swan brian.swan@microsoft.com http://blogs.msdn.com/brian_swan http://www.linkedin.com/in/brianeswan

2. The Windows Azure Platform • Developer Experience • Use existing skills and tools Relational data Management platform Compute Storage Management AppFabric Flexible APIs Connectivity Access control Information Marketplace Reporting & BI Billing & Payments

3. SQL Azure DatabaseThe first true relational database as a service Subtitle color Self-managed Elastic Scale Developer Agility • Build cloud-based database solutions on consistent relational model • Leverage existing skills through existing ecosystem of developer and management tools • Explore new data application patterns • Database utility; pay as you grow • Flexible load balancing • Business-ready SLAs • Enable multi-tenant solutions • World-wide presence • Easy provisioning and deployment • Auto high-availability and fault tolerance • Self-maintaining infrastructure; self-healing • No need for server or VM administration

4. SQL Azure Architecture

5. SQL AzureDeployment Web Portal (API) DB Script SQL Azure TDS

6. SQL AzureAccessing databases Web Portal (API) Your App SQL Azure TDS Change Connection String

7. Database Replicas Single Database Multiple Replicas Replica 1 Single Primary Replica 2 DB Replica 3

8. SQL AzureDatabase Monitoring & Recovery Web Portal (API) ! Your App SQL Azure TDS

9. SQL Azure Features • Supported • Tables, Indexes, Views • Stored Procedures • Triggers • Constraints • Table Variables • Temp Tables (#Name) • Not Supported • Physical Server Access • Catalog DDL • Common Language Runtime • Service Broker • Reporting Services • Analysis Services • Distributed Transactions and Queries Whitepaper: SQL Azure vs. SQL Server

10. SQL Azure Pricing • Web Edition • Up to 1 GB relational database = $9.99 / month • Up to 5 GB relational database = $49.95 / month** • Business Edition • Up to 10 GB relational database = $99.99 / month • Up to 20 GB relational database = $199.98 / month** • Up to 30 GB relational database = $299.97 / month** • Up to 40 GB relational database = $399.96 / month** • Up to 50 GB relational database = $499.95 / month** • Data transfers • $0.10 in / $0.15 out / GB - ($0.30 in / $0.45 out / GB in Asia) • * No charge for inbound data transfers during off-peak times through October 31, 2010 • ** SQL Azure 50 GB Business Edition Database and 5 GB Web Edition Database will be available starting on June 28, 2010. • http://www.microsoft.com/windowsazure/offers/

11. PHP with SQL Azure • SQL Server Driver for PHP • Binaries: http://bit.ly/sqlsrvdriver • Source code: http://sqlsrvphp.codeplex.com/ • Supports PHP access to SQL Azure • Features • Choose between SQL Server and SQL Azure by changing connection string • Use from on-premises or in Windows Azure

12. SQL Server Driver for PHP - Architecture

13. SQL Server Driver for PHP - Features • Windows Authentication • Connection pooling • Streaming • Server-side “scrollable” cursors • UTF-8 support • SQL Azure support • PDO support (Beta)

14. Demo

15. Resources • http://www.joshholmes.com/blog/ • http://english.zachskylesowens.net/ • http://blogs.msdn.com/b/sqlphp/ • http://sqlazuremw.codeplex.com/ • http://azurephptools.codeplex.com/ • http://msdn.microsoft.com/en-us/windowsazure/sqlazure/default.aspx • http://www.microsoft.com/windowsazure/whitepapers/