cloud computing sql data services l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Cloud Computing: SQL Data Services PowerPoint Presentation
Download Presentation
Cloud Computing: SQL Data Services

Loading in 2 Seconds...

play fullscreen
1 / 38

Cloud Computing: SQL Data Services - PowerPoint PPT Presentation


  • 136 Views
  • Uploaded on

Cloud Computing: SQL Data Services. Meinrad Weiss Principal Consultant Trivadis AG. Christoph Pletz Senior Consultant Trivadis AG. Business Intelligence. Managed Services. Business Communication. Application Development. Training. Integration –

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Cloud Computing: SQL Data Services' - Samuel


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
cloud computing sql data services

Cloud Computing: SQL Data Services

Meinrad Weiss

Principal ConsultantTrivadis AG

Christoph Pletz

Senior ConsultantTrivadis AG

slide2

Business

Intelligence

Managed

Services

Business

Communication

Application

Development

Training

Integration –

Application Performance Mngt. – Security

Integration – Application Performance

Management – Security

Unternehmensdaten

Bestehende IT Kunden

Infrastruktur

Technologiekompetenz: Microsoft, Oracle, IBM, Open Source

trivadis facts figures
Trivadis Facts & Figures
  • Currently 13 locations with over 500 employees
    • Baden, Basel, Bern, Brugg, Lausanne, Zurich
    • Düsseldorf, Frankfurt, Freiburg, Hamburg, Munich, Stuttgart
    • Vienna
  • Since January 2008, the Trivadis Group has a qualified majority of shares in MIK AG, based in Brugg
  • Financially independent and sustainably profitable
  • Key figures in 2007
    • Consolidated incomeCHF 98 million / EUR 60 million
    • Services for more than 600 clients in over 1‘500 projects
    • Over 125 Service Level Agreements
    • More than 5'000 training participants per year
    • Research budget: CHF 6.0 million / EUR 3.6 million
agenda
Agenda
  • Azure Overview
  • SQL Data Services (SDS)
  • SQL Server ↔ SDS Compatibility
  • SDS Client Applications
  • Wrap Up
slide5

On-Premises

Cloud Services

Visual Studio & .NET

microsoft cloud services
Microsoft Cloud Services

Azure™ Services Platform

Management

Compute

Storage

  • Designed to be: “File System in the cloud”
    • lowest cost efficient solution for simple data storage and retrieval in the cloud
    • can store
      • Queues
      • Blobs
      • ISAM style, simple Tables (non-relational)
microsoft cloud services7
Microsoft Cloud Services

Azure™ Services Platform

Management

Compute

Storage

  • Designed to be: “File System in the cloud”
    • lowest cost efficient solution for simple data storage and retrieval in the cloud
    • can store
      • Queues
      • Blobs
      • ISAM style, simple Tables (non-relational)
microsoft cloud services8
Microsoft Cloud Services

Azure™ Services Platform

Database

Data Sync

Reference Data

Management

Compute

ETL

Data Mining

Reporting

Storage

database choices
Database Choices
  • Value Props:
    • Full h/w control – size/scale
    • 100% compatibility
    • Roll-your-own HA/DR/scale
  • Value Props:
    • XSPs, Server Ops
    • SQL CLR
    • 100% compatibility
    • Roll-your-own HA/DR/scale
  • Low-cost and zero friction addresses web/dept workloads
    • Target is 3 to 10 GB Databases
  • High compatibility with existing SQL Server offering

Dedicated

On-premise

  • Value Props:
    • Auto HA, Fault-Tolerance
    • Friction-free scale
    • Self-provisioning
    • High compatibility

SQL Server or other s/w on-premise

Resource governance @ machine

Security @ DB Server/OS

Resources

Hosted

Hosted SQL Server or other

Resource governance @ VM

Security @ DB Server/OS

SDS (RDBMS)

Virtual DB server

Logical user database (LDB)

Resource governance @ LDB

Security @ LDB

Shared

Low

“Friction”/Control

High

from ctp 1 to now
From CTP 1 to now
  • ExistingKnowHow and Applications
  • New Web 2.0 and SilverlightApplications
  • OtherVendorslikeAmazon

T/SQL via TDS

SOAP/REST

SOAP/REST

MassiveArchitecuralChange

Key-Value DB

SQL, Tablesand Rows

Authority, Container,Entity

Simple Tables, Blobs, Queues

Storage

from ctp 1 to now11
From CTP 1 to now
  • Existing KnowHow and Applications
  • New Web 2.0 and Silverlight Applications
  • Other Vendors like Amazon

SOAP/REST

Data Services

T/SQL via TDS

SOAP/REST

SOAP/REST

T/SQL via TDS

SQL, Tablesand Rows

Authority, Container,Entity

SQL, Tablesand Rows

Simple Tables, Blobs, Queues

Storage

service provisioning model
Service Provisioning Model
  • Each account has
    • a billing relationship with Microsoft
    • owns one or more virtual servers
  • Each server has
    • one or more databases including virtual master
    • each database limited in size
    • one or more logins
  • Each database has
    • one or more SQL users

Account

Server

Server

Database

Database

  • Server=server1.data.database.windows.net
  • Database=testDB
  • Login=HansM[@server1] (maps to testuser)
sql server vs sql data services
SQL Server vs. SQL Data Services
  • Master
  • AdventureWorks
  • Northwind
  • Pubs

SQL Server

  • Master

SQL Data Services

  • Adventureworks
  • Master
  • AdventureWorks
  • Northwind
  • Pubs
  • Pubs
  • Northwind
instances and databases
Instances and Databases
  • One SQL Server instance per physical machine
  • Multiple logical databases per instance
    • Randomly distributed by infrastructure
    • Ressource sharing
  • Scalable HA technology
    • Automatic replication and failover
  • Provisioning, metering and billing infrastructure

Machine 4

Machine 5

Machine 6

Machine 7

SQL Instance

SQL Instance

SQL Instance

SQL Instance

SQL DBs

SQL DBs

SQL DBs

SQL DB

Provisioning (databases, accounts, roles…), Metering, and Billing

DB1

DB2

DB3

DB4

DB5

DB1

DB3

DB2

DB1

DB6

DB2

DB3

DB4

DB5

DB1

DB7

Scalability and Availability: Fabric, Failover, Replication, and Load Balancing

ha reading data
HA – Reading Data

Select * from Customer

Primary

New Primary

Secondary

Secondary

ha writing data
HA – Writing Data

Update Customer

Set Priority = 1

Secondary

Primary

Secondary

architecture
Architecture

ConnectDB2

TDS Gateway

Utility Layer

1

7

Front-end Node

Billing/Usage Database

Account Database

Protocol Parser

Front-end Node

6

2

Protocol Parser

Roles

TDS

Session 1

Gateway Logic

TDS

Session 2

3

Gateway Logic

4

Master Cluster

Master Node

Master Node

8

Partition Manager

Partition Manager

NodeProvisioning

5

Data Node Components

Data Node Components

ServicePlatform

Load Balancing

Monitoring

Machine 4

Machine 5

Machine 6

Machine 7

SQL Instance

SQL Instance

SQL Instance

SQL Instance

SQL DB

SQL DB

SQL DB

SQL DB

DB1

DB2

DB3

DB4

DB5

DB1

DB3

DB2

DB1

DB6

DB2

DB3

DB4

DB5

DB1

DB7

Scalability and Availability: Fabric, Failover, Replication, and Load balancing

Scalability and Availability: Fabric, Failover, Replication, and Load balancing

from ctp 1 to now18
From CTP 1 to now
  • Existing KnowHow and Applications
  • New Web 2.0 and Silverlight Applications
  • Other Vendors like Amazon

Ditto?

T/SQL via TDS

SOAP/REST

SOAP/REST

T/SQL via TDS

SQL, Tablesand Rows

Authority, Container,Entity

SQL, Tablesand Rows

Simple Tables, Blobs, Queues

Storage

example of sql compatibility
Example of SQL Compatibility

In Scope for v1 (likely)

Out of Scope for v1 (likely)

Distributed Transactions

Distributed Query

CLR

Service Broker

Spatial

Physical server or catalog DDL and views

Traditional “Backup/Restore”

##t ?

  • Tables, indexes and views
  • Stored Procedures
  • Triggers
  • Constraints
  • Table variables, session temp tables (#t)
management tools
Management Tools
  • API for provisioning
    • Web
  • SQL Server Management Studio (SSMS)
    • Basically available, but will have obviously some restrictions
      • e.g. no sp_configure
  • Standard Query Tools
security model
Security Model
  • Uses regular SQL security model
    • Authenticate logins, map to users and roles
    • Authorize users and roles to SQL objects
  • Limited to standard SQL Auth logins
    • Username + password
    • Future
      • AD Federation (Geneva)
      • Windows Live ID
  • Encryption
    • TDS supports SSL
    • No database encryption at all in V1
      • Transparent Database Encrytion
      • Encryption Functions
how scalable is sds
How Scalable is SDS?
  • Scalability and/or consistency?
    • ACID (Atomicity, Consistency, Isolation, Durability)
      • Write nnodes on Commit
      • Read from the max n nodes
    • BASE
      • Basically available, soft state, eventually consistent
      • Write nnodes on Commit synchronize more nodes later
      • Read on more than the n nodes
  • SDS = (a very) ACID model
    • Writes on 3 nodes on Commit
    • Reads form 1 node
scalability
Scalability
  • Scale Performance
    • SDS fabric can switch the primary node for a database to a less busy node
    • SDS may throttle your session if it takes too much resources
    • BYOP (bring your own partitioning)
    • PYON (Pay for your own physical node(s))
  • Scale Size of Database
    • Current offering is targeted at departmental databases
    • BYOP (bring your own partitioning)
sds client applications
SDS Client Applications
  • Clients connect directly to a database
    • Cannot hop across DBs
  • Any database client library for SQL Server can be also used for SDS
    • ODBC, OLE DB, ADO.NET Provider for SQL Server
      • ADO.NET Entity Framework
        • ADO.NET Data Services (Astoria)
      • LINQ to SQL
    • PHP native SQL Client
sds client apps
SDS Client Apps

Application

Application

Application

Browser

SQL Client*

SOAP Client*

REST Client*

HTTP+SOAP

HTTP+REST

HTTP

TDS

Cloud

Windows Azure Compute

REST (Astoria)

Web Srv

Web App

SQL Client*

ADO.Net* + EF

SQL Client*

Data Center

TDS + TSQL Model

SDS Database

* Client access enabled using TDS for ODBC, ADO.Net, OLEDB, PHP-SQL, Ruby, …

tabular data stream tds
Tabular Data Stream (TDS)
  • “Code far” scenario
    • TDS is not designed for high latency networks
  • Recommendation
    • Batch SQL statements
    • Use Functions/Stored Procedures
      • Table valuein parametersare very handy
extending sql data platform to cloud
Extending SQL Data Platform to Cloud

Reference Data

Business Intelligence

Data Sync

Reporting

SQL Data Services (SDS)

Database-as-a-Service

Symmetric Programming Model

Data Hub Aggregation

data hub sync services
Data Hub / Sync Services

Mobile Users

On Premises Assets and Data

sql services opportunities and futures
SQL Services (Opportunities and Futures)
  • Scalability
    • Partitioned databases
    • Geo-location and geo-redundancy
  • Flexibility
    • Distributed query
    • Support for multiple levels of hardware and software isolation
  • Security
    • Future AD Federation
    • WLID, etc as alternate authentication protocols
    • Encryption
release plan
Release Plan

Invitation CTP – On-board invitation-only customers + some current

Public CTP – On-board all early adopters

Commercial Availability with Windows Azure in 2009

Migration

InternalAdoption

Invitation

CTP

Public

CTP

Commercial Availability

PDC

MIX ‘09

TechEd

Mar 09

Apr 09

May 09

Jun 09

Jul 09

Aug 09

Sep 09

Oct 09

Nov 09

quick wins with sds
Quick Wins with SDS
  • High Availability
    • Including Data Hub Scenario
  • Fast and easy Deployment
    • Ideally “Code near” scenario with Web apps
  • Well known programming model
    • Low learning curve (you can learn it today)
  • Reliability
    • Confidence that data will not be lost
    • Replication, back-up
  • Defined SLA, at which Cost (?)
want to know more
Want to Know More?
  • Team Blog
    • http://blogs.msdn.com/ssds
  • MSDN Development Center
    • http://msdn.microsoft.com/en-us/sqlserver/dataservices
  • Register @ the Azure start portal
    • http://www.azure.com
your benefits today

Your Benefits today

30%

30%

3days

  • on SQL Server Trainings
  • on Application Builder
  • TAB Pilot Project for free

Limited Offer Only

y our msdn resources check out these websites blogs more
Your MSDN resourcescheck out these websites, blogs & more!

PresentationsTechDays: www.techdays.chMSDN Events: http://www.microsoft.com/switzerland/msdn/de/presentationfinder.mspxMSDN Webcasts: http://www.microsoft.com/switzerland/msdn/de/finder/default.mspx

MSDN EventsMSDN Events: http://www.microsoft.com/switzerland/msdn/de/events/default.mspxSave the date: Tech•Ed 2009 Europe, 9-13 November 2009, Berlin

MSDN Flash (our by weekly newsletter)Subscribe: http://www.microsoft.com/switzerland/msdn/de/flash.mspx

MSDN Team BlogRSS: http://blogs.msdn.com/swiss_dpe_team/Default.aspx

Developer User Groups & CommunitiesMobile Devices: http://www.pocketpc.ch/Microsoft Solutions User Group Switzerland: www.msugs.ch.NET Managed User Group of Switzerland: www.dotmugs.chFoxPro User Group Switzerland: www.fugs.ch

y our technet resources check out these websites blogs more
Your TechNet resourcescheck out these websites, blogs & more!

PresentationsTechDays: www.techdays.ch

TechNet EventsTechNet Events: http://technet.microsoft.com/de-ch/bb291010.aspx Save the date: Tech•Ed 2009 Europe, 9-13 November 2009, Berlin

TechNet Flash (our by weekly newsletter)Subscribe: http://technet.microsoft.com/de-ch/bb898852.aspx

Schweizer IT Professional und TechNet BlogRSS: http://blogs.technet.com/chitpro-de/

IT Professional User Groups & CommunitiesSwissITPro User Group: www.swissitpro.chNT Anwendergruppe Schweiz: www.nt-ag.chPASS (Professional Association for SQL Server): www.sqlpass.ch

save the date for tech days next year

Save the date for tech·days nextyear!

7. – 8. April 2010Congress Center Basel

slide37

Premium Sponsoring Partners

Classic Sponsoring Partners

Media Partner