1 / 21

Introducing Microsoft SQL Services – Database Services for Cloud Applications

Introducing Microsoft SQL Services – Database Services for Cloud Applications. Janakiram MSV Sr. Technology Strategist | Microsoft India Development Center. Agenda. The Azure Services Platform The SQL Services Platform SQL Data Services Managing Data On Cloud Accessing Data On Cloud.

Download Presentation

Introducing Microsoft SQL Services – Database Services for Cloud Applications

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Introducing Microsoft SQL Services – Database Services for Cloud Applications Janakiram MSV Sr. Technology Strategist | Microsoft India Development Center

  2. Agenda • The Azure Services Platform • The SQL Services Platform • SQL Data Services • Managing Data On Cloud • Accessing Data On Cloud

  3. Azure Services Platform Azure™ Services Platform

  4. SQL Services FuturesExtending the SQL Data Platform to the cloud • Data services tier of the Azure Services Platform • Built on SQL Server foundation • Broad data platform capabilities as a service • Friction-free provisioning, scaling • Significant investments in scale, HA, lights-out operation and TCO Database Reporting Data Sync Data Mining Reference Data ETL

  5. SQL Data ServicesThe Database in the Cloud SQL Data Services • Internet based database service • Relational query processing • Transactional consistency and concurrency support • Flexible data model • Built on proven SQL Server technologies Business Grade Quality of Service • Highly available and fully redundant • Business ready SLA • Operational excellence • Flexible authentication and authorization • Consumption based billing Service Interop: • HTTP Based Web Service • Standards Compliant: • REST, SOAP, APP

  6. SQL Data ServicesEnabling 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 Low friction deployment and scaling • Pay as you go scaling • Don’t need to provision to peak demand

  7. Azure Storage vs SDS Windows Azure Storage SQL Data Services • “Essential storage service in the cloud” • Provides a core set of non-relational storage and retrieval abstractions at massive scale • “Premium database service in the cloud” • Extends the rich capabilities of the SQL data platform to the cloud at scale • Relational data processing over structured and unstructured data • Integrate with key data platform capabilities – e.g. Data Analytics, Reporting, ETL

  8. Getting Started www.Azure.com

  9. Core Concepts • Unit ofgeo-location and billing • Tied toDNS name • Collectionof Containers Authority Container Entity • Unit of Consistency • Scope for Query and Update • Collectionof Entities • Unit of Storage • Property Bagof Name/Value pairs • No Schema Required

  10. Concepts of ACE

  11. ConceptsEntity Entity properties may differ in type and instance DifferentKinds DifferentInstanceTypes Additional Property

  12. Authentication And Authorization • Basic authentication – username and password • Integrate with .NET Access Control Services for richer authentication models • Basic Authentication • Claims based access control • Role based authorization – Future

  13. Accessing Data From The Cloud REST POX / JSON SOAP XML

  14. HTTP Verbs to SDS Operation

  15. Accessing Through SOAP • Add a Service Reference To https://database.windows.net/soap/v1/ • Create an instance of SitkaSoapServiceClient • Accessible from any language and any SOAP Toolkit

  16. Demo Creating Authorities, Containers & Entities

  17. SDSQuery language • Textual query language through web-service head, passed in as literal text string • Language patterned after C# LINQ syntaxfrom e in container wheree.Kind == “Tamil” && e[“Director”] == “Mani Ratnam” && e[“Year”] == “2007”select e • Query supported over metadata and data properties

  18. Demo Accessing & Querying SDS

  19. Resources • Azure Services Platform Home http://www.microsoft.com/azure/default.mspx • SQL Services Homehttp://www.microsoft.com/azure/sql.mspx • SQL Data Services Dev Centerhttp://msdn.microsoft.com/en-us/sqlserver/dataservices/default.aspx • SQL Data Services Documentationhttp://msdn.microsoft.com/en-us/library/cc512417.aspx • SQL Services Team Blog • http://blogs.msdn.com/ssds • SQL Services Labshttp://www.microsoft.com/azure/sqllabs.mspx

  20. Feedback / QnA • Your Feedback is Important! Please take a few moments to fill out our online feedback form • Use the Question Manager on LiveMeeting to ask your questions now!

More Related