{"id":1713,"date":"2013-11-13T09:00:00","date_gmt":"2013-11-13T17:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/"},"modified":"2024-01-22T22:49:05","modified_gmt":"2024-01-23T06:49:05","slug":"microsoft-sql-server-data-tools-update","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/","title":{"rendered":"Microsoft SQL Server Data Tools Update"},"content":{"rendered":"<p>With the release of <a href=\"http:\/\/technet.microsoft.com\/en-US\/evalcenter\/dn205290?WT.mc_id=Blog_SQL_Update_DataTools\">SQL Server 2014 Community Technology Preview 2 (CTP2)<\/a> and the commercial release of Visual Studio 2013, we are excited to announce new preview releases of SQL Server Data Tools to support both database and business intelligence projects.<\/p>\n<p><strong><span style=\"text-decoration: underline\">SQL Server Data Tools &#8211; Business Intelligence for SQL Server 2014 Preview <\/span><\/strong><\/p>\n<p>To support new business intelligence projects, we have recently released a Community Technology Preview (CTP) of the SQL Server Data Tools \u2013 Business Intelligence (SSDT-BI) tools that work with SQL Server 2014 CTP2.<\/p>\n<p>SQL Server Data Tools &#8211; <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/jj856966.aspx?WT.mc_id=Blog_SQL_Update_DataTools\"><strong>Business Intelligence<\/strong><\/a> (SSDT-BI) includes SQL Server Analysis Service Projects, SQL Server Reporting Services Projects, and SQL Server Integration Services Projects hosted in Visual Studio. <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/jj856966.aspx?WT.mc_id=Blog_SQL_Update_DataTools\">SSDT-BI tools<\/a> can be downloaded and installed as free tools from the web.\u00a0 SSDT-BI tools:<\/p>\n<ul>\n<li>Integrate into existing Visual Studio installations for those developers that already have Visual Studio 2012 (Professional Edition or higher) installed.<\/li>\n<li>Install as standalone tools, with the Visual Studio integrated IDE shell also being installed to host the various BI projects they support.<\/li>\n<\/ul>\n<p>As updates are available, the SSDT-BI tools do not automatically notify you of updates within the Visual Studio environment once installed, so users must visit the download site to obtain updates manually.\u00a0 You can also always check <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=36843\">here<\/a> to make sure you have the latest release installed.<\/p>\n<p><strong><span style=\"text-decoration: underline\">SQL Server 2014 Business Intelligence Support and Visual Studio 2013 Support<\/span><\/strong><\/p>\n<p>The existing preview version of SSDT-BI for SQL Server 2014 is based on <strong>Visual Studio 2012<\/strong>.\u00a0 The commercial release of SSDT-BI is expected to be based on the newer Visual Studio 2013 in conjunction with the commercial release of the SQL Server 2014.\u00a0 At that time, the existing SQL Server 2014 CTP 2 SSDT-BI that is based on Visual Studio 2012 will be retired and the new version of SSDT-BI that is based on Visual Studio 2013 will take its place.<\/p>\n<p>SSDT-BI for SQL Server 2014 will support various SQL Server versions as follows:<\/p>\n<ul>\n<li>SSAS projects can target SQL Server 2014 or lower<\/li>\n<li>SSRS projects can target SQL Server 2014 or lower<\/li>\n<li>SSIS projects can target <strong>only<\/strong> SQL Server 2014<\/li>\n<\/ul>\n<p>To target SSIS projects for SQL Server 2012, developers will have to continue to use the existing SSDT-BI version for SQL Server 2012, which is based on Visual Studio 2012. This version of SSDT-BI for SQL Server 2012 that is <a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=36843&amp;WT.mc_id=Blog_SQL__DataTools\">currently available<\/a> will continue to be available after the SQL Server 2014 release.<\/p>\n<p>SSDT-BI for Visual Studio 2012 supports versions of SQL Server as follows:<\/p>\n<ul>\n<li>SSAS project can target SQL 2012 or lower<\/li>\n<li>SSRS project can target SQL 2012 or lower<\/li>\n<li>SSIS project can target only SQL 2012<\/li>\n<\/ul>\n<p><strong><span style=\"text-decoration: underline\">SQL Server Data Tools Database Projects Now Integrated within Visual Studio<\/span><\/strong><\/p>\n<p>What was previously available as an add-in for Visual Studio 2010 and updated for Visual Studio 2012, the database developer toolset, is now an integrated feature of both Visual Studio 2012 and 2013. Along with being integrated in the full Visual Studio SKUs, database developers without Visual Studio can install them for free as standalone tools also.\u00a0 These tools provide end-to-end support for building and managing Windows Azure SQL Databases and SQL Server databases. They provide SQL Server version-specific validation. The tools include live connected tools and designers, and the ability to create database projects that integrate with Visual Studio source control (including Team Foundation Server) for full schema development, debugging, database migrations and overall database lifecycle management. Over the past year, new features have been added including:<\/p>\n<ul>\n<li>Database Unit Testing<\/li>\n<li>Data Compare<\/li>\n<li>Declarative Model Extensibility (Deployment and Build contributors)<\/li>\n<\/ul>\n<p>See below for a summarized map to acquire and update the core (non-BI) database tooling.<\/p>\n<p><strong><span style=\"text-decoration: underline\">SQL Server Database Tooling<\/span><\/strong><\/p>\n<table style=\"width: 641px\" border=\"1\" cellspacing=\"0\" cellpadding=\"3\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"121\">Visual Studio 2010<\/td>\n<td valign=\"top\" width=\"521\"><strong>Standalone, add-in (free)<br \/>\n<\/strong><a href=\"http:\/\/msdn.microsoft.com\/en-us\/data\/tools?WT.mc_id=Blog_SQL_Update_DataTools\">SQL Server Data Tools for Visual Studio 2010<\/a><\/p>\n<p><strong>Updates<br \/>\n<\/strong>In-shell notification for standalone, add-in.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"121\">Visual Studio 2012<\/td>\n<td valign=\"top\" width=\"521\"><strong>Integrated<br \/>\n<\/strong>Visual Studio Ultimate 2012<br \/>\nVisual Studio Premium 2012<br \/>\nVisual Studio Professional 2012<a href=\"http:\/\/www.microsoft.com\/visualstudio\/eng\/downloads\">http:\/\/www.microsoft.com\/visualstudio\/eng\/downloads<\/a><\/p>\n<p><strong>Standalone, add-in (free)<br \/>\n<\/strong><a href=\"http:\/\/msdn.microsoft.com\/en-us\/data\/tools?WT.mc_id=Blog_SQL_Update_DataTools\">SQL Server Data Tools for Visual Studio 2012<\/a><\/p>\n<p><strong>Updates<br \/>\n<\/strong>In-shell notification for standalone, add-in.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"121\">Visual Studio 2013<\/td>\n<td valign=\"top\" width=\"521\"><strong>Integrated<br \/>\n<\/strong>Visual Studio Ultimate 2013<strong><br \/>\n<\/strong>Visual Studio Premium 2013<strong><br \/>\n<\/strong>Visual Studio Professional 2013<strong>Standalone (free)<br \/>\n<\/strong>Visual Studio Express 2013 for Windows<br \/>\nVisual Studio Express 2013 for Web<\/p>\n<p>Windows Azure SDK for Visual Studio 2013<\/p>\n<p><a href=\"http:\/\/www.windowsazure.com\/en-us\/downloads\/?WT.mc_id=Blog_SQL_Update_DataTools\">http:\/\/www.windowsazure.com\/en-us\/downloads\/<\/a><\/p>\n<p>http:\/\/www.microsoft.com\/visualstudio\/eng\/downloads#d-2013-editions<\/p>\n<p><strong>Updates<\/strong><\/p>\n<p>In-shell notification &amp; delivery<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong><span style=\"text-decoration: underline\">SQL Server Data Tools for SQL Server 2014<\/span><\/strong><\/p>\n<p>With the release of SQL Server 2014 CTP2, we have added support for SQL Server 2014 via a release of <a href=\"http:\/\/blogs.msdn.com\/b\/ssdt\/archive\/2013\/10\/25\/sql-server-data-tools-for-sql-server-2014-ctp2-is-available.aspx?utm_source=feedburner&amp;utm_medium=feed&amp;utm_campaign=Feed%3A+ssdtblog+%28SQL+Server+Developer+Tools+Team+Blog%29?WT.mc_id=Blog_SQL_Update_DataTools\">SQL Server Data Tools for SQL Server 2014<\/a> CTP2.<\/p>\n<h2>Summary<\/h2>\n<p>We are hard at work finishing up our complete Visual Studio tooling for SQL Server 2014. Both the tools integrated with Visual Studio 2012 and 2013 and the BI tools have pre-releases available for SQL Server 2014 already.\u00a0 At commercial release of SQL Server 2014, we plan to also commercially release updates to the database developer and BI tools for the commercial release of SQL Server 2014.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With the release of SQL Server 2014 Community Technology Preview 2 (CTP2) and the commercial release of Visual Studio 2013, we are excited to announce new preview releases of SQL Server Data Tools to support both database and business intelligence projects.<\/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":[2487],"class_list":["post-1713","post","type-post","status-publish","format-standard","hentry","content-type-updates","review-flag-1593580427-503","review-flag-1593580414-58","review-flag-2-1593580436-981","review-flag-alway-1593580309-407","review-flag-free-1593619513-128","review-flag-integ-1593580287-179","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>Microsoft SQL Server Data Tools Update - 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\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft SQL Server Data Tools Update - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"With the release of SQL Server 2014 Community Technology Preview 2 (CTP2) and the commercial release of Visual Studio 2013, we are excited to announce new preview releases of SQL Server Data Tools to support both database and business intelligence projects.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/\" \/>\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=\"2013-11-13T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:49:05+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=\"3 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\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"Microsoft SQL Server Data Tools Update\",\"datePublished\":\"2013-11-13T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/\"},\"wordCount\":778,\"commentCount\":25,\"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\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/\",\"name\":\"Microsoft SQL Server Data Tools Update - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2013-11-13T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:49:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft SQL Server Data Tools Update\"}]},{\"@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":"Microsoft SQL Server Data Tools Update - 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\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/","og_locale":"en_US","og_type":"article","og_title":"Microsoft SQL Server Data Tools Update - Microsoft SQL Server Blog","og_description":"With the release of SQL Server 2014 Community Technology Preview 2 (CTP2) and the commercial release of Visual Studio 2013, we are excited to announce new preview releases of SQL Server Data Tools to support both database and business intelligence projects.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2013-11-13T17:00:00+00:00","article_modified_time":"2024-01-23T06:49:05+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":"3 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"Microsoft SQL Server Data Tools Update","datePublished":"2013-11-13T17:00:00+00:00","dateModified":"2024-01-23T06:49:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/"},"wordCount":778,"commentCount":25,"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\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/","name":"Microsoft SQL Server Data Tools Update - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2013-11-13T17:00:00+00:00","dateModified":"2024-01-23T06:49:05+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2013\/11\/13\/microsoft-sql-server-data-tools-update\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"Microsoft SQL Server Data Tools Update"}]},{"@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\/1713","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=1713"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/1713\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=1713"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=1713"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=1713"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=1713"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=1713"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=1713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}