what s new in microsoft sql services l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
What’s New in Microsoft SQL Services PowerPoint Presentation
Download Presentation
What’s New in Microsoft SQL Services

Loading in 2 Seconds...

play fullscreen
1 / 26

What’s New in Microsoft SQL Services - PowerPoint PPT Presentation


  • 129 Views
  • Uploaded on

What’s New in Microsoft SQL Services. Nigel Ellis Architect Microsoft SQL Services. Agenda. Year in review: SDS learning Database Service Value Proposition Relational Database-as-a-Service Architecture and breadth Roadmap. Data Platform: Device to Cloud. RDBMS. Service. Protection.

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 'What’s New in Microsoft SQL Services' - deon


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
what s new in microsoft sql services

What’s New in Microsoft SQL Services

Nigel Ellis

Architect

Microsoft SQL Services

agenda
Agenda
  • Year in review: SDS learning
  • Database Service Value Proposition
  • Relational Database-as-a-Service
  • Architecture and breadth
  • Roadmap
data platform device to cloud
Data Platform: Device to Cloud

RDBMS

Service

Protection

Mining

Sync

Load

Reporting

Caching

Query

Analysis

Integration

Search

Backup

Model & policy based development and management

In

Memory

RelationalBLOB

MultiDim

XML

File

Type

Place

Mega-server

Desktop

Data Services

Server

Mobile/Desktop

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

  • Initial services – core RDBMS capabilities as a service (SDS), Data Sync and Data Hub
  • Future Offerings
    • Additional data platform capabilities as a service: BI/DSS, DW
    • New services: Reference Data, Secure Data Hub

Enable new uses of data to deliver differentiated business value

the new sql data services
The New SQL Data Services

Clear Feedback: “I want a database in the Cloud”

  • Familiar SQL Server relational model
  • Uses existing APIs & tools
  • Built for the Cloud with availability and scale
  • Accessible to all from PHP, Ruby, and Java

Focus on combining the best features of SQL Server running at scale with low friction

the evolution of sds
The Evolution of SDS

Application

BrowserApplication

Evolves

Application

BrowserApplication

Application

ODBC, OLEDB, ADO.Net PHP, Ruby, …

REST Client

REST Client

SQL Client*

Cloud

Cloud

Windows Azure

REST (Astoria)

Web App

ADO.Net + EF

REST Client

HTTP+REST

HTTP+REST

HTTP

TDS

HTTP

Windows Azure

Web App

SQL Client*

Data Center

Data Center

REST/SOAP + ACE Model

TDS + TSQL Model

SDS Next

SDS Current

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

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

Dedicated

On-premise

SQL Server or other s/w on-premise

Resource governance @ machine

Security @ DB Server/OS

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

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

Low-cost and zero friction addresses web/dept workloads

High compatibility with existing SQL Server offering

demo accessing sds from php
Demo: Accessing SDS from PHP

BrowserApplication

  • PHP runs in Azure using FastCGI
  • Access to SDS via existing drivers
  • Ease of provisioning

Internet

HTTP

Windows Azure

Wordpress (PHP)

ODBC

Microsoft Data Center

TDS+SSL

TDS + TSQL Model

SQL Data Services

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

Database

  • Server=server1.data.database.windows.net
  • Database=testDB
  • Login=nigele[@server1] (maps to testuser)
logical databases ldb
Logical Databases (LDB)
  • Shared infrastructure at SQL database and below
    • Request routing, security and isolation
  • Scalable HA technology provides the glue
    • 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 DB

SQL DB

SQL DB

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

compatibility goals
Compatibility Goals
  • Support common application patterns
  • Logical/policy based administration
  • Patterns work from Server to Cloud
  • Multi-tenancy considerations
    • Throttling and load balancing
    • Limits on DB size, transaction duration, …

V1: Address the needs of 95% or more web and departmental application

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

  • Tables, indexes and views
  • Stored Procedures
  • Triggers
  • Constraints
  • Table variables, session temp tables (#t)
connection model
Connection Model
  • Clients connect directly to a database
  • Most SQL supported within database
  • Cannot hop across DBs
    • DB’s can be on different servers so state management is hard

Connection tied to target database; cannot “hop” across

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, WLID, etc as alternate authentication protocols

Security model is 100% compatible with on-premise SQL

platform readiness eha
Platform Readiness (EHA)
  • Exchange Hosted Archive (EHA) is high scale archival service
  • Runs on SDS infrastructure
    • In production prior to SDS v1
  • Rebuilt to address cost and scale issueshttp://go.microsoft.com/fwlink/?LinkId=145374
  • Reduced COGS with increased customerand business benefit:
  • Larger scale (e.g. larger customers ~20TB+ each)
  • More self-managing (e.g. fault-tolerance)
  • Better query performance for fan-out
  • Faster provisioning of new customers
sql services opportunities and futures
SQL ServicesOpportunities and Futures
  • Partitioned databases
  • Geo-location and geo-redundancy
  • Distributed query
  • Security w/AD, WLID, etc
  • Support for multiple levels of hardware and software isolation
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

WWPC

TechEd

Mar 09

Apr 09

May 09

Jun 09

Jul 09

Aug 09

Sep 09

Oct 09

Nov 09

key takeaways
Key Takeaways
  • Foundation of the SDS relational platform
    • Built using core SQL Server product codebase
  • Delivery of rich relational database service – PDC ’09
  • Key capability of the Azure platform
  • Supports broad spectrum of scenarios
slide20

Please Complete an Evaluation FormYour feedback is important!

  • Evaluation forms can be found on each chair
  • Temp Staff at the back of the room have additional evaluation form copies
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
slide22

© 2009 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries.

The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

sql data services
SQL Data Services

Clear Feedback: “I want a database in the Cloud”

SDS delivers…

Zero-friction provisioning

Scale-free & easy to manage

Automatic HA, fault-tolerance and geo-location support

  • Familiar relational model
    • T-SQL, Tables, DML, DDL, Indexes, SPs...
  • Leverage existing tools
  • Extends on-premises apps
  • Highly interoperable
  • Breadth developer support
    • PHP, Ruby, Java
    • OSS libraries and frameworks

SQL Data Services

combines the best features of

simple storage and hosted RDBMS

Replaces current “Flex Entity” Data Model and Protocol Support

ADO.NET Data Services – REST/HTTP support

Windows Azure Storage – “property bag” data model

logical vs physical administration
Logical vs. Physical Administration
  • SDS focus on logical administration
    • Move to policy based management
  • Data management, config and availability
    • Automatically replicated with HA “out of box”
    • Transparent failover in case of failure
    • Load balancing of data to ensure SLA

DBA role places more focus on policy/logical management

high level architecture
High Level Architecture

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