Windows Azure for Developers

1. Windows Azure for Developers

2. A Continuous Offering From Private To Public Cloud Virtual Physical SaaS IaaS PaaS

3. The Basics SQL Database SQL Server database technology as a service Fully Managed Enterprise-ready with automatic support for HA Designed to scale out elastically with demand Ideal for simple and complex applications

4. Server Provisioning Server Defined Service head that contains databases Connect via automatically generated FQDN (xxx.database.windows.net) Initially contains only a master database Provision Servers Interactively Log on to Windows Azure Management Portal Create a SQL Database server Specify admin login credentials Add firewall rules and enable service access Automate Server Provisioning Use Windows Azure Platform PowerShell cmdlets (or use REST API directly) wappowershell.codeplex.com

5. A Server Is Not AMachine SQL Server A Machine SQL Database Server A TDS Endpoint

6. Create Database… Use Familiar Technologies Transact-SQL Languages .NET Framework (C#, Visual Basic, F#) via ADO.NET C / C++ via ODBC Java via Microsoft JDBC provider PHP via Microsoft PHP provider Frameworks OData, Entity Framework, WCF Data Services, NHibernate Tools SQL Server Management Studio (2008 R2 and later) SQL Server command-line utilities (SQLCMD, BCP) CA Erwin® Data Modeler Embarcadero Technologies DBArtisan® SQL Server Comparison Focus on logical vs. physical administration Database and log files automatically placed Three high-availability replicas maintained for every database Tables require a clustered index Maximum database size is 150 GB Unsupported SQL Server Features Use command, distributed transactions, distributed views Service Broker Common Language Runtime (CLR) SQL Agent Native Encryption

7. Enhanced Tooling SQL Database Management Portal Web designers for tables, views, stored procs Interactive query editing and execution SQL Server Data Tools (SSDT) Visual Studio IDE for database development Includes modern designers and projects with declarative, model-driven development Develop and test in both connected and disconnected states Platform targeting for both SQL Server (2005 and above) and SQL Database Get it free with Web PI, with SQL Server 2012 and with Visual Studio 11

8. Database Deployment Data-Tier Application Framework (DAC Fx) Alternative to traditional script based approach Dramatically simplifies deployment, migration and versioning of databases Provides a single unit of deployment for schema (dacpac) or for schema + data (bacpac) Supports automatic versioning of database schemas Supports platform targeting for both SQL Server (2005 and above) and SQL Database Build from scratch or extract from existing db How To Get The Latest DAC Fx With SQL Server Data Tools With SQL Server 2012 Management Studio With SQL Database Import/Export Service Via sqldacexamples.codeplex.com

9. There Are Two Ways To Secure A Database: On The Server Within The Database

10. Server Benefits Server identity and access control SQL authentication supported (No Integrated authentication) The Admin login is similar to sa Connect to master to administer logins loginmanager: Server-Level security role for creating logins dbmanager: Server-Level security role for creating databases

11. Database Benefits Database identity and access control Logins require an associated user account The Admin login is automatically associated with dbo The dbo has full rights in the database Manage users with CREATE / ALTER / DROP USER commands Add users to roles via sp_add_rolemember to grant privileges Utilize schemas where appropriate

12. SQL Database Firewall Securing your data IP Address-based access control for SQL Database Rules can be defined at the server and database No IP authorized by default Configurable using the SQL Database Portal and REST API Option to disable/enable access from applications hosted in Windows Azure

13. Application Connectivity Connecting To SQL Database • TDS (Tabular Data Stream) protocol over TCP/IP supported • SSL required • Use firewall rules to connect from outside Microsoft data center ASP.NET EXAMPLE: Considerations And Best Practices • login: [login]@[server] • Idle connections • Long running transactions • DoS guard • Failover events • Throttling • Connection pooling and Retry logic • Latency introduced for updates • No cross-database dependencies <connectionStrings> <addname="AdventureWorks"connectionString= "Data Source=[server].database.windows.net; Integrated Security=False; Initial Catalog=ProductsDb; User Id=[login]; Password=[password]; Trusted_Connection=False; Encrypt=true;" providerName="System.Data.SqlClient"/> </connectionStrings>

14. Creating A SQL Database Server Demo

15. Websites

16. Windows Azure • Your Datacenter • Virtual Machines • Cloud Services • Web Sites Applications Applications Applications Applications Data Data Data Data Firewall Firewall Rules Firewall Rules Network Virtual Network Virtual Network O/S O/S Virtualization Hardware Focus on the Application

17. Supported Publishing Methods FTP:// TFS WebDeploy DropBox

18. Supported Web Frameworks Or any custom FastCGI Handler

19. scale Free Multi-tenant. Daily quotas Shared Multi-tenant. Daily quotas Standard Dedicated VMs. No quotas

20. web sites standard shared shared Shared instances :-) 1

21. web sites standard shared shared Shared instances :-) :-) 2

22. web sites standard shared standard Shared instances Standard instance :-) :-) :-) 1 0

23. web sites standard shared standard Standard instance Standard instance :-) :-) 2

24. web sites standard shared standard Standard instance Standard instance :-) :-) :-) :-) :-) :-) :-) :-) 2

25. Diagnostics & Monitoring HTTP Logs Error Logs Portal Monitoring Log Streaming New Relic

26. Windows Azure Web App Gallery Ready-to-Go Open Source Web Applications, Frameworks, and Templates

27. Demos Demo

28. Windows Azure Web Sites start simple code smart go live

29. What is Windows Azure Mobile Services? Notifications Auth Data Logging & Diag Server Logic Scheduler Scale

30. Key Scenarios Windows Azure Mobile Services are ideal for: Modern mobile apps Windows Store Apps, Windows Phone, iOS, Android Common Scenarios Reduces the friction associated with repeating common tasks such as user authentication, push notifications and structured storage Rapid Development Time is money. Get your app up and running sooner when you use Mobile Services to configure a straightforward and secure backend in less than five minutes.

31. Structured Storage Structured Storage with SQL Database If using single database apps are partitioned by schema AppX.Todoitem AppY.Todoitem Manage data in Portal SQL Portal SQL Management Studio REST API…

32. Server Logic Automatic service REST API generated for storage Dynamic Schema on/off Ability to author server logic that intercepts CRUD operation pipeline Rich querying capability

33. Server Logic Supported Modules + Globals mssql request console push.* tables statusCodes mssql.query('select top 1 * from statusupdates', { success: function(results) { console.log(results); } } );

34. REST API to SQL type mappings

35. Push Notification Lifecycle Overview Mobile Services Windows 8 Request Channel URI Register with your Cloud Service Authenticate & Push Notification App (2) Windows Push Notification Service Notification Client Platform (3) (1) (3)

36. Push Notifications Integrates with WNS to provide Toast, Tile, Badge and Raw notifications Portal captures your WNS client secret and package SID push.wns.* provides: clean easy object model to compose notifications Performs auth against WNS for you

37. Auth* Authenticate against Microsoft Account, Twitter, Facebook, Google Table level permissions for each CRUD operation Everyone Anyone with the Application Key Only Authenticated Users Only Scripts and Admins More granular control with server side scripts user.level: {admin, authenticated, anonymous} user.userId: id or undefined if not authenticated

38. Scheduler Execute scripts on a Schedule by Minutes by Hours by Days By Months Execute scripts on Demand Examples Periodic purge of old data Poll and aggregate from 3rd party (Twitter, RSS, others) Process/resize images Schedule sending push notifications for a given time of day

39. Diagnostics, Logging and Scale Diagnostics API calls CPU Time Data Out Logging console.error(…) console.log(…) Scale - Compute Scale out instance count Scale up VM size Scale - Storage Scale out mobile service tenant to dedicated SQL DB Scale up SQL DB capacity