sql azure at sql pass summit

October 11-14, Seattle, WA

SQL AzureWhere We Are Today, and Microsoft's Cloud Data Strategy

Lynn Langit: Senior Developer Evangelist, MicrosoftGregory Leake: Director SQL Azure Technical Marketing, Microsoft

Session Objectives and TakeawaysSession Objective(s):

See and understand the breadth of DBA tools for SQL AzureThese tools include the following:

• Windows Azure Portal• SQL Server Management Studio• Visual Studio (Juneau –or SSDT)/ LightSwitch• OData, WCF Data Services

Session Takeaway:SQL Azure has a variety of tools for DBAs and DevelopersUse the right tool for the task(s)

Note: we are covering RELATIONAL cloud database options here only. For information about non-relational (i.e. NoSQL, etc…) see this link http://code.msdn.microsoft.com/windowsazure/CSAzureTableStorageWCFDS-2355159b

Extending SQL Server to the Cloud

Symmetry with Traditional RDBMS

Enterprise-class “scale-up” data platform

Multiple hardware platforms and deployment options

Deploy as dedicated server in customer datacenter, VM or 3rd party

Typically licensed per-server or per processor

Distributed “scale-out” database service

Abstracts OS and hardware management

Low-friction provisioning, multi-tenant

Automatic high-availability and data replication

Pay-as-you-go and commitment offers

Familiar T-SQL relational modelSupport existing code libraries and protocolsEcosystem of familiar development and management tools

SQL Azure Database

Cloud relational database based on SQL Server engine

Use same tools, data access frameworks, T-SQL based language

Global datacenters

High Availability & Redundancy

• Reads are completed at the primary• Writes are replicated to a quorum of

secondaries

Single LogicalDatabase

Multiple PhysicalReplicas

Single Primar

y

MultipleSecondaries

Replic

a 1

Replic

a 2

Replic

a 3

DB

• New announcements tomorrow at 8:15 AM• Stay tuned to tomorrow’s keynote for new SQL Azure Announcements, demonstrations• http://blogs.msdn.com/b/windowsazure/

• SQL Azure Reporting Final CTP• Open to all via Windows Azure Management Portal• Commercial Release Q1 2012

• SQL Azure Data Sync Final CTP• Open to all via Windows Azure Management Portal• Commercial Release Q1 2012

• Refresh of SQL Server Data Tools (formerly “Juneau”): Q4 2011• Commercial Release with SQL Server 2012, also on Web for download

• Refresh of SQL Server Management Studio: Q1 2012• Commercial Release with SQL Server 2012, also on Web for download Q1 2012 with SSMS

Express

SQL Azure Futures

SQL Azure Portal

Portal for Database Management

SQL Azure Portal

Silverlight-based tools

demo

SQL Azure Data Sync

SQL Server

Application

SQL Azure

Application

SQL Server

Application

On-Premises

SQL Azure

Application

SQL Azure

Application

SQL Azure

ApplicationCloud

• Scale-out via multiple copies of data

• E.g. Separate reporting & OLTP workloads; multiple Web sites

• Geo-located web applications

• Use with Windows Azure Traffic Manager

• Hybrid applications; one-way publish or two-way sharing

• Multiple locations (e.g. branch office, retail offices); share data between locations and/or aggregate data in cloud

SQL Azure Reporting and Data Sync Previews

SQL Azure Data Sync (CTP)No-Code Sync Configuration• Configure and manage using

Windows Azure Portal• Define data to be synchronized

and locations• Choose how often data is

synchronized• Specify optional filters

Full Data Synchronization Capabilities• Two-way sync of same data, as

well as one-way sync

Conflict Handling• Detect and resolve conflicts

caused by the same data being changed in multiple locations

SQL Azure Data Sync

demo

SQL Azure Reporting and Cloud BIExtending reporting services to the cloud

Reporting Tools

Publish Reports to SQL Azure Reporting

Report Developer

sEnd Users

End users

URL access to reports or LOB

application

Windows Azure LOB Application

Cloud BI Value Scenarios

Departments, groups or small businesses need reporting but don’t have the resources for procuring hardware and software licenses, installing, configuring and managing the system

QuickStart, Departmental, Sandbox BI

Businesses with seasonality or fluctuating capacity over time cannot easily plan for maximum capacity – which will be idle a large % of the time.

Average Usage

Com

pu

te

Time

Seasonal processing

Businesses need the flexibility to pick the right deployment option to address specific requirements including maintaining sensitive data on premises while extending access.

Hybrid deploymentsExtended Enterprise

Businesses need to share insights from data generated by internal systems with external partners including supply chain partners

About SQL Azure & SSMS 2008 R2 SP1

Be sure to update to SP1 - here

SQL Server Management Studio

demo SQL Server 2012 CTP 3--Connection Info--UAC --DACPAC

About SQL Azure, SQL Server 2012 & SSMS

3rd Party Tools

Download Migration Tools – hereDownload Migration Wizard - here

SQL Server Data Tools Preview Release

demo Visual Studio Shell

SQL Server Data ToolsFormerly codename “Juneau”

New! SQL Server Data Tools in Visual Studio

Can target SQL Azure (version targeting)Server Explorer• Can Snapshot project (database)• Can Schema compare• Supports entity framework

Improved Intellisense• Error syntax highlighting• Easier refactoring• Easier debugging (including stored procs)

SSDTServer Explorer• Data Connections• New Node – SQL Server

• Connect to SQL Azure• Connect to SQL Server• LocalDB

•Can work online or offline

SSDT Architecture

New – Table Designer in Visual Studio

Offline Projects – Visual Studio

New Project Type --Set Source connection--Set Target project--Set Import settings--Creates Off-line Project

SSDT Schema Compare

Refactoring

• Find All Dependencies• Rename with Preview• Intellisense

Version Targeting & Publishing

Visual Studio 2010 SP1

demo With SQL Server Data Tools --Server Explorer--Entity Framework--DACPAC--Refactoring--Intellisense

SQL Server Data Tools…

• Table Designer• Schema Compare• Snapshots• Refactoring (find all references & go to definition)• SSDT project (to create local objects)• Debug/test w/local DB• Publish (sync and/or apply incremental updates)

LightSwitch

demo

Visual Studio Light Switch

Beth Massi blog • Azure and Light Switch

– here

Other tools

• SDKs for Mobile Development on Windows Azure• http://www.microsoft.com/windowsazure/scenarios/mobile-

applications/

• PowerShell• Command-line• SQLCMD• bcp

• CodePlex tools• SQL Azure Migration Wizard

• 3rd party tools• Cerebrata, RedGate, Quest

About OData

Portal Location for CTP of ODATAService:http://www.sqlazurelabs.com

About SQL Azure & OData

SQL Azure, OData and WCF Data Services

demo

36Session Code | Session Title

Microsoft SQL Server Clinic

Work through your technical issues with

SQL Server CSS & get architectural guidance

from SQLCAT

Microsoft Product Pavilion

Talk with Microsoft SQL Server & BI experts to learn about the next version of SQL Server and check out the new Database Consolidation

Appliance

Expert Pods

Meet Microsoft SQL Server Engineering team members &

SQL MVPs

Hands-on Labs

Get experienced through self-paced & instructor-led labs on our cloud based lab platform - bring your

laptop or use HP provided hardware

Room 611 Expo Hall 6th Floor Lobby Room 618-620

SQL Azure Related SQL Pass Content

• Core SQL Azure• Thursday 10:15 Room 602 (Hybrid)• Thursday 3:00 Room 401 (SSDT)• Friday 1:00 Room 609

• Reporting in SQL Azure• Thursday 10:15 Room 612

• Scaling SQL Azure• Thursday 5:00 Room 609 (Sharding)• Friday 4:15 Room 401 (SQLCat)

• Migrate to SQL Azure • Friday 10:15 Room 606• Friday 1:00 Room 401 (Federations)

SQL Azure Team Content

• Windows Azure Platform Blog - here• MSDN SSDT section• MSDN Forum – here• SSDT Team Blog - here

Lynn’s Content

Resources• http://www.lynnlangit.com• Twitter - @lynnlangit• http://www.slideshare.net/lynnlangit

40

Complete the Evaluation Form to Win!Win a Dell Mini Netbook – every day – just for submitting your completed form. Each session evaluation form represents a chance to win.

Pick up your evaluation form:• In each presentation room• Online on the PASS Summit website

Drop off your completed form:• Near the exit of each presentation room• At the Registration desk• Online on the PASS Summit website

Sponsored by Dell

Session Code | Session Title

October 11-14, Seattle, WA

Thank youfor attending this session and the 2011 PASS Summit in Seattle