1 / 15

Introduction to SQL Azure via PHP

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. The Windows Azure Platform. Developer Experience. Use existing skills and tools. Relational data.

genero
Download Presentation

Introduction to SQL Azure via PHP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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/

More Related