{"id":5873,"date":"2009-03-10T12:08:00","date_gmt":"2009-03-10T19:08:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2009\/03\/10\/whats-next-for-sql-data-services\/"},"modified":"2024-01-22T22:51:56","modified_gmt":"2024-01-23T06:51:56","slug":"whats-next-for-sql-data-services","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/","title":{"rendered":"What\u2019s Next for SQL Data Services\u2026"},"content":{"rendered":"<p>At the Professional Developer Conference 2008 Microsoft kicked off a major wave of innovation with the announcement of the Azure Services Platform. A key piece of that technology wave is SQL Data Services (SDS).<\/p>\n<p>Over the last 4 months, SDS early adopters have been working with our REST service interface with its flexible entity based data model. While we\u2019ve received a positive response on that model, we have had significant feedback asking for more direct relational database capabilities such as SQL queries, relational schema and stored procedures. Our plan has always been to provide more relational capabilities over time. What is changing is that rather than trying to expose relational capabilities through continuous invention at our REST interface level, we are going to accelerate delivery of these features by exposing SQL Server\u2019s existing network protocol, <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/aa174503(SQL.80).aspx\">Tabular Data Stream (TDS),<\/a> directly as the service protocol. With this evolution, SDS will become the first relational database service in the market to provide customers with the ability to use existing investments in <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms189826.aspx\">T-SQL<\/a> development and use a full relational data model in the Cloud. In addition to this, SDS will enable developer agility and quick time to market by supporting the use of existing applications, tools and knowledge, while benefitting from the new distributed, cloud based functionality of SDS. This strategy enables customers to use a relational database service for their applications built on the Azure Services Platform<\/p>\n<p>With the acceleration to a T-SQL based standard relational data model, we will migrate from the current SOAP and REST based Authority-Container-Entity (ACE) data model. We will announce plans for decommissioning the existing REST based SDS service when we introduce the new TDS based SDS Service.\u00a0 Customers who wish to expose REST based access to their SDS relational data can do so by building custom services with ADO.NET Data Services.\u00a0 Customers who wish to use a REST based programming model and whose needs are met with non-relational structured data storage have the option of using Windows Azure table storage which directly exposes an ADO.NET Data Services compliant REST service endpoint. We\u2019ll be working with existing early adopter customers to provide guidance on the appropriate migration path.<\/p>\n<p>SDS, with TDS support, will be available as a public CTP in mid calendar year 2009 and commercially available in the second half of calendar year 2009.<\/p>\n<p>We will be announcing technical details of the TDS based SDS service at MIX 2009.<\/p>\n<p>As always, we are eager to get more feedback from the community, post them here or <a href=\"http:\/\/blogs.technet.commailto:ssdstlk@microsoft.com\">email the team<\/a>. Those interested in SDS, should also keep an eye on the <a href=\"http:\/\/msdn.microsoft.com\/en-us\/sqlserver\/dataservices\/default.aspx\">SQL Data Services Developer Center <\/a>for more info.<\/p>\n<div id=\"scid:0767317B-992E-4b12-91E0-4F059A8CECA8:7410d11c-6b70-4f59-917c-75c646fed528\" class=\"wlWriterEditableSmartContent\" style=\"float: none;margin: 0px;padding: 0px\">Technorati Tags: <a href=\"http:\/\/technorati.com\/tags\/SDS\" rel=\"tag\">SDS<\/a>,<a href=\"http:\/\/technorati.com\/tags\/SQL+Data+Services\" rel=\"tag\">SQL Data Services<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Cloud\" rel=\"tag\">Cloud<\/a>,<a href=\"http:\/\/technorati.com\/tags\/Azure\" rel=\"tag\">Azure<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>At the Professional Developer Conference 2008 Microsoft kicked off a major wave of innovation with the announcement of the Azure Services Platform. A key piece of that technology wave is SQL Data Services (SDS).<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[],"class_list":["post-5873","post","type-post","status-publish","format-standard","hentry","content-type-updates","review-flag-4-1593580446-456","review-flag-alway-1593580309-407","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>What\u2019s Next for SQL Data Services\u2026 - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What\u2019s Next for SQL Data Services\u2026 - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"At the Professional Developer Conference 2008 Microsoft kicked off a major wave of innovation with the announcement of the Azure Services Platform. A key piece of that technology wave is SQL Data Services (SDS).\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2009-03-10T19:08:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:51:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"What\u2019s Next for SQL Data Services\u2026\",\"datePublished\":\"2009-03-10T19:08:00+00:00\",\"dateModified\":\"2024-01-23T06:51:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/\"},\"wordCount\":456,\"commentCount\":14,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/\",\"name\":\"What\u2019s Next for SQL Data Services\u2026 - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2009-03-10T19:08:00+00:00\",\"dateModified\":\"2024-01-23T06:51:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What\u2019s Next for SQL Data Services\u2026\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What\u2019s Next for SQL Data Services\u2026 - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/","og_locale":"en_US","og_type":"article","og_title":"What\u2019s Next for SQL Data Services\u2026 - Microsoft SQL Server Blog","og_description":"At the Professional Developer Conference 2008 Microsoft kicked off a major wave of innovation with the announcement of the Azure Services Platform. A key piece of that technology wave is SQL Data Services (SDS).","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2009-03-10T19:08:00+00:00","article_modified_time":"2024-01-23T06:51:56+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"What\u2019s Next for SQL Data Services\u2026","datePublished":"2009-03-10T19:08:00+00:00","dateModified":"2024-01-23T06:51:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/"},"wordCount":456,"commentCount":14,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/","name":"What\u2019s Next for SQL Data Services\u2026 - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2009-03-10T19:08:00+00:00","dateModified":"2024-01-23T06:51:56+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2009\/03\/10\/whats-next-for-sql-data-services\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"What\u2019s Next for SQL Data Services\u2026"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/5873","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=5873"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/5873\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=5873"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=5873"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=5873"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=5873"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=5873"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=5873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}