Transcript BB15 * SQL Server:Database to Data Platform * Road From Server

BB15
 Dave Campbell
Technical Fellow
Microsoft Corporation




• Support unpredictable usage and scale at low cost
• Secure data access on any device from anywhere
• Reliability, availability and supportability
• Offline enabled applications
• Provide best user experience based on client
device capabilities
• Reduce latency of application and business processes
• Store and process complex data types natively
• Provide a full spectrum of data services
• Agile application development and deployment
Operations
User
Experience
Application
Development
From device to cloud
RDBMS
Service
Model & policy based development and management
Type
Place
Reference
Data
Reporting
Data Mining
Data Warehouse



ETL
The Database in the Cloud













Enabling Applications
Extend to Cloud
• Integrate with existing solutions
• Data Platform solutions scale to cloud
Create secure data hubs
• Secure access and movement of structured data
• Across devices, locations, partners
Planned vs. Required Capacity
• Pay as you go scaling
• Don’t need to provision to peak demand
500
% of Initial Capacity
Low friction deployment and scaling
600
400
300
200
100
0
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Months
Developer Experience
Interop and Choice
• Access SQL Services with standard protocols and formats
• REST, SOAP, HTTP, etc.
Community Based Libraries and Examples
• Ruby, PHP, Java, …
• Ruby Active Resource
See: http://github.com/sdsteam
Rich Tooling
• Familiar tooling experience with Visual Studio
• Leverage skills to extend to Cloud
Choice
Leverage the
Community






















Zach Owens
Technical Evangelist
Microsoft Sync Framework
Sync in the Data Platform
Sync Framework is the easiest and most
efficient way to synchronize your data with:
• Live Mesh, File systems, Databases, Astoria
Services, SQL Services, and more
Sync Framework is:
• Store-independent
• Data-independent
• Protocol-independent
Sync in action
Local data can be accessed faster
and more reliably
Microsoft Sync Framework
provides the technology
to enable:
• Offline and cached-mode
capabilities for
your application
• Roaming and collaboration of
your data across
disparate endpoints











Zach Owens
Technical Evangelist
Your data any place, any time
Enterprise Data Platform
• Secure, trusted platform for your data
• Optimized and predictable system performance
• Productive policy-based management of your infrastructure
Dynamic Development
• Accelerate your development with entities
• Synchronize your data from anywhere
Beyond Relational
• Store and consume any type of data
• Deliver Location Intelligence within your applications
Pervasive Insight
• Integrate all your data in the Enterprise Data Warehouse
• Reach all your users with scalable BI platform
• Empower every user with actionable insights
Beyond Relational
• Reduce the cost of
managing all types
of data
• Simplify the
development of
applications which use
relational and nonrelational data
• Extend functionality
currently available for
relational data to nonrelational data
Rich Structure
Semi-Structured
Unstructured
Blob & File
Storage
XML & Light
Schema
Rich Schema &
Relational
Support
Spatial types



Spatial libraries to provide symmetric functionality outside of
SQL Server for better developer support
•
•
•
CLR type + unmanaged DLL
Available for separate download/install
Can code against it through C#, VB, etc.
















Corporate Management
SharePoint App







Zach Owens
Technical Evangelist










Code
Title
Room
Time
BB23
SQL Data Services : A Lap Around
502A
10/28/2008 3:30PM-4:45PM
BB03
SQL Data Services : Under the Hood
404A
10/30/2008 8:30AM-9:45AM
BB14
SQL Data Services: Futures
408B
10/29/2008 10:30AM-11:45AM
BB52
SQL Data Services: Tips and Tricks for High-Throughput Data-Driven Applications
411
10/28/2008 12:45PM-1:30PM
BB40
Sync Framework: Enterprise Data in the Cloud and on Devices
408A
10/28/2008 5:15PM-6:30PM
TL30
Microsoft Sync Framework Advances
515B
10/27/2008 1:45PM-3:00PM
BB16
SQL Server 2008: Beyond Relational
406A
10/28/2008 1:45PM-3:00PM
BB26
SQL Server 2008: Business Intelligence and Data Visualization
515A
10/28/2008 1:45PM-3:00PM
BB24
SQL Server 2008: Deep Dive into Spatial Data
404A
10/29/2008 3:00PM-4:15PM
BB07
SQL Server 2008: Developing Large Scale Web Applications and Services
411
10/28/2008 1:45PM-3:00PM
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
TL42
Microsoft SQL Server 2008: Powering MSDN
411
10/29/2008 12:00PM-12:45PM
TL14
Project "Velocity": A First Look
403AB
10/28/2008 1:45PM-3:00PM
TL56
Project "Velocity": Under the Hood
403AB
10/28/2008 3:30PM-4:45PM
PC44
Windows 7: Programming Sync Providers That Work Great with Windows
408B
10/28/2008 12:45PM-1:30PM
www.microsoftpdc.com
© 2008 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.