SESSION CODE COS 305 Rick Negrin Lead Program

SESSION CODE: COS 305 Rick Negrin Lead Program Manager SQL Azure Microsoft Corporation

Developer Experience Use existing skills and tools

Relational Database as a Service for the Windows Azure Platform Focus on combining the best features of SQL Server running at scale with low friction

Highly scaled out relational database as a service SQL Azure Database Browser Relational database service (Windows Azure Compute) SOAP/REST HTTP/S Astoria/REST - EDM HTTP/S Customer Value Props App Code (ASP. NET) Windows Azure Compute T-SQL (TDS) SQL Azure Database SQL Server Reporting Server (on-premises) MS Datacenter - AD Federation (Live. Id /. Net Svcs ACS)

account Account server Server database Database servers

SQL Azure access from within MS Datacenter (Azure compute) Application/ Browser App code/ Tools SQL Azure Access from within and outside MS Datacenter (On-premises & Azure Compute) SQL Server App code/ Tools (ASP. NET) T-SQL (TDS) SQL Azure Code Near Windows Azure Data Sync App Code SQL Azure Astoria/REST - EDM HTTP/S T-SQL (TDS) SOAP/REST HTTP/S SQL Azure Access from outside MS Datacenter (On-premises) Windows Azure App Code (ASP. NET) T-SQL (TDS) SQL Azure Code Far Hybrid

Account Server Database Sub-Database

Transactional Requirements High • • Single Database No Partitioning Partitioned Data Partitioning based on Application Requirements (IOPS, Storage or both) • • Partitioned Data Partitioning Based on Application Requirements (Storage) Low • • Partitioned Data Partitioning based on Application Requirements (IOPS) Low Storage Requirements High

server @server

Increases efficiency by removing re-login // When pooling, use connection and return immediately // Do not hold for a long time – pool ensure fast turnaround // one second use

SELECT * INTO #Destination FROM Source WHERE [Color] LIKE 'Red‘ To work around this you need to create your destination table then call INSERT INTO. Here is an example: CREATE TABLE #Destination (Id int NOT NULL, [Name] nvarchar(max), [Color] nvarchar(10)) INSERT INTO #Destination(Id, [Name], [Color]) SELECT Id, [Name], [Color] FROM Source WHERE [Color] LIKE 'Red';

Guid? session. Id = null; using (Sql. Connection conn = new Sql. Connection(…)) { // Grab session. Id from new connection using (Sql. Command cmd = conn. Create. Command()) { conn. Open(); cmd. Command. Text = "SELECT CONVERT(NVARCHAR(36), CONTEXT_INFO())"; session. Id = new Guid(cmd. Execute. Scalar(). To. String()); } // continue processing. . . }

New unit of deployment for T-SQL apps. Supports Install, Uninstall, and in the future Upgrade and Repair. Contains developer intent as policies. LOGICAL Tables, Views, Constraints, SProcs, UDFs, PHYSICAL Users, Logins, Indexes Future - DAC Deployment Profile Deployment Requirements, Management Policies, Failover Policies Unit of Deployment Schema

http: //bit. ly/dgv. Mv 0

www. sqlpass. org http: //www. sqlpass. org/summit/na 2010 http: //social. technet. microsoft. com/forums/en-us/category/sqlserver

Windows Azure, Microsoft SQL Azure, Windows Azure platform App. Fabric: www. windowsazure. com/techedus

www. microsoft. com/teched www. microsoft. com/learning http: //microsoft. com/technet http: //microsoft. com/msdn

Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31 st http: //northamerica. msteched. com/registration You can also register at the North America 2011 kiosk located at registration Join us in Atlanta next year