BB14: SQL Services Futures

voltaireblingData Management

Nov 20, 2013 (3 years and 10 months ago)

96 views



Patric McElroy


Group Program Manager


SQL Data Services

BB14

SQL Data Platform








Mobile/

Desktop

OLAP

FILE

XML

RDBMS

Query

Analysis

Reporting

Integration

Sync

Search

Server

Data

Services






Storage and Database Services












Reference Data

Reporting

ETL

Data Mining












SQL
Data Services &
ADO.Net Data Services

Data Model












uthority

ontainer

ntity

Data
Service
Support

Client
Support

ADO.Net

Data
Services (Astoria)

SQL Data Service

Evolves to

include

flex entities

Evolves to

include

schematized data

Schematized

Data

Flex

Entities

public class
string
get
set
string
get
set
long
get
set
string
get
set
string
get
set
string
objec
CSDL

Astoria processes metadata
and generates CSDL

Kind=
ImageContent

Id

Version

SubmittedBy

SubmittedOn

Title


LocationId

Payload

Description

Latitude

Longitude

Img

Author



Metadata

SSDS



Content

Strongly Typed and Flex Properties

var

results =
from

ic

in

context.ImageContext


where

ic.SubmittedBy

== “David Robinson”

select

ic
;


foreach

(
var

c
in

results)

Console
.WriteLine
(
c.Title
);

var

results =

from

ic

in

context.ImageContext


where

ic.Field
<
string
>(“Description”) ==
“bar”

select

ic
;


Future

Interoperability

ADO.Net


Data Services

Open Source
Client Libraries


Entity Data Model


Rich tooling support


Symmetry across
on/off premise data


Broad reach across open
-
source client libraries


Aligned with native tooling support


Available on:
http://github.com/sdsteam

require 'net/http'

require '
rexml
/document'

require '
yaml
'


module SSDS



ssds_config

= "#{RAILS_ROOT}/
config
/ssds.yml



request_xml

= REXML::
Document.new
()


request_xml.add_element
('s:Container')


request_xml.root
().
add_attribute
('
xmlns:s
',
'http://schemas.microsoft.com/sitka/2008/03/')


request_xml.root
().
add_element
("s:Id")


request_xml.root
().elements["s:Id"].text = container


req

=
create_post
(
request_xml
)


execute_request

req

Create Container


Sharing data through Data Sync





Sync

Service

iPhone

Occasionally
Connected

Data
Sharing


SQL Server Analysis Server (SSAS)







Excel add
-
in

Analyze your

spreadsheet data

Thin Client


Pull data
directly from
SQL
Server Data
Services


Upload your CSV files



Data Provider

SQL Server

Report Server (SSRS)

SQL Server

Integration Server (SSIS)

SSIS source
component
for SSDS

SQL Server

Analysis Server (SSAS)

On
-
premise
Cust01

Cust02

Cust03

Cust04

Schematized data…

+ flex entities

flex











http://www.microsoft.com/azure/sqllabs.mspx














Code

Title

Room

Time

TL42

Microsoft SQL Server 2008: Powering MSDN

411

10/29/2008 12:00PM
-
12:45PM

BB37

SQL Server 2008: Developing Secure Applications

515A

10/29/2008 12:00PM
-
12:45PM

BB25

SQL Server 2008: New and Future T
-
SQL Programmability

515A

10/29/2008 1:15PM
-
2:30PM

PC40

SQL Server Compact: Embedding in Desktop and Device
Applications

402A

10/29/2008 3:00PM
-
4:15PM

BB24

SQL Server 2008: Deep Dive into Spatial Data

404A

10/29/2008 3:00PM
-
4:15PM

BB03

SQL Data Services : Under the Hood

404A

10/30/2008 8:30AM
-
9:45AM

www.microsoftpdc.com

©
2008 Microsoft
Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademar
ks
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
dat
e 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 accu
rac
y 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.