{"id":6521,"date":"2016-05-13T09:56:12","date_gmt":"2016-05-13T16:56:12","guid":{"rendered":"http:\/\/joedantoni.wordpress.com\/?p=1572"},"modified":"2016-06-16T08:30:21","modified_gmt":"2016-06-16T15:30:21","slug":"did-you-know-r-services-is-in-standard-edition-of-sql-server-2016","status":"publish","type":"post","link":"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/","title":{"rendered":"Did You Know?? R Services is in Standard Edition of SQL Server 2016"},"content":{"rendered":"

While my last post extolled the virtues of SQL Server Standard Edition, this week while doing some client testing  with Microsoft, I learned about another key standard edition feature. The new SQL Server R services is supported in standard edition of SQL Server 2016. While you won\u2019t get access to some of the cool functions from Revolution Analytics and in-line parallelism (there is a @parallel=1 in sp_execute_external_script that automatically parallelizes your operations), you can still use all of the Open Source R functions, and build out your own parallelism (just multiple calls of your procedure).  <\/p>\n

 <\/p>\n

<\/p>\n

This is a huge benefit for those of you are who are doing statistical analysis of data and want to integrate with SQL Server. Stay tuned here for more detail for how DBAs can use R to analyze performance. <\/p>\n

\"\"<\/a> \"\"<\/p>\n","protected":false},"excerpt":{"rendered":"

While my last post extolled the virtues of SQL Server Standard Edition, this week while doing some client testing  with Microsoft, I learned about another key standard edition feature. The new SQL Server R services is supported in standard edition of SQL Server 2016. While you won’t get access to some of the cool functions […]\"\"<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[551,271,46],"tags":[],"class_list":["post-6521","post","type-post","status-publish","format-standard","hentry","category-blog","category-sql-server-2016","category-syndication"],"yoast_head":"\nDid You Know?? R Services is in Standard Edition of SQL Server 2016 – Denny Cherry & Associates Consulting<\/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.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Did You Know?? R Services is in Standard Edition of SQL Server 2016 – Denny Cherry & Associates Consulting\" \/>\n<meta property=\"og:description\" content=\"While my last post extolled the virtues of SQL Server Standard Edition, this week while doing some client testing  with Microsoft, I learned about another key standard edition feature. The new SQL Server R services is supported in standard edition of SQL Server 2016. While you won’t get access to some of the cool functions […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/\" \/>\n<meta property=\"og:site_name\" content=\"Denny Cherry & Associates Consulting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-13T16:56:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-06-16T15:30:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i2.wp.com\/www.quantmod.com\/examples\/chartSeries3d\/chartSeries3d-thumb.png\" \/>\n<meta name=\"author\" content=\"Joey D'Antoni\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dcacco\" \/>\n<meta name=\"twitter:site\" content=\"@dcacco\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joey D'Antoni\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/\",\"url\":\"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/\",\"name\":\"Did You Know?? R Services is in Standard Edition of SQL Server 2016 – Denny Cherry & Associates Consulting\",\"isPartOf\":{\"@id\":\"https:\/\/www.dcac.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i2.wp.com\/www.quantmod.com\/examples\/chartSeries3d\/chartSeries3d-thumb.png\",\"datePublished\":\"2016-05-13T16:56:12+00:00\",\"dateModified\":\"2016-06-16T15:30:21+00:00\",\"author\":{\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/ac58f2207d3f180aa3e4ee0ce6af0885\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#primaryimage\",\"url\":\"https:\/\/i2.wp.com\/www.quantmod.com\/examples\/chartSeries3d\/chartSeries3d-thumb.png\",\"contentUrl\":\"https:\/\/i2.wp.com\/www.quantmod.com\/examples\/chartSeries3d\/chartSeries3d-thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.dcac.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Did You Know?? R Services is in Standard Edition of SQL Server 2016\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dcac.com\/#website\",\"url\":\"https:\/\/www.dcac.com\/\",\"name\":\"Denny Cherry & Associates Consulting\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dcac.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/ac58f2207d3f180aa3e4ee0ce6af0885\",\"name\":\"Joey D'Antoni\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dcac.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3fede03569772a55a091b587d76f78d4?s=96&r=x\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3fede03569772a55a091b587d76f78d4?s=96&r=x\",\"caption\":\"Joey D'Antoni\"},\"url\":\"https:\/\/www.dcac.com\/author\/joeydcac-co\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Did You Know?? R Services is in Standard Edition of SQL Server 2016 – Denny Cherry & Associates Consulting","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.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/","og_locale":"en_US","og_type":"article","og_title":"Did You Know?? R Services is in Standard Edition of SQL Server 2016 – Denny Cherry & Associates Consulting","og_description":"While my last post extolled the virtues of SQL Server Standard Edition, this week while doing some client testing  with Microsoft, I learned about another key standard edition feature. The new SQL Server R services is supported in standard edition of SQL Server 2016. While you won’t get access to some of the cool functions […]","og_url":"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/","og_site_name":"Denny Cherry & Associates Consulting","article_publisher":"https:\/\/www.facebook.com\/DennyCherryAssociatesConsulting\/","article_published_time":"2016-05-13T16:56:12+00:00","article_modified_time":"2016-06-16T15:30:21+00:00","og_image":[{"url":"https:\/\/i2.wp.com\/www.quantmod.com\/examples\/chartSeries3d\/chartSeries3d-thumb.png","type":"","width":"","height":""}],"author":"Joey D'Antoni","twitter_card":"summary_large_image","twitter_creator":"@dcacco","twitter_site":"@dcacco","twitter_misc":{"Written by":"Joey D'Antoni","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/","url":"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/","name":"Did You Know?? R Services is in Standard Edition of SQL Server 2016 – Denny Cherry & Associates Consulting","isPartOf":{"@id":"https:\/\/www.dcac.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#primaryimage"},"image":{"@id":"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#primaryimage"},"thumbnailUrl":"https:\/\/i2.wp.com\/www.quantmod.com\/examples\/chartSeries3d\/chartSeries3d-thumb.png","datePublished":"2016-05-13T16:56:12+00:00","dateModified":"2016-06-16T15:30:21+00:00","author":{"@id":"https:\/\/www.dcac.com\/#\/schema\/person\/ac58f2207d3f180aa3e4ee0ce6af0885"},"breadcrumb":{"@id":"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#primaryimage","url":"https:\/\/i2.wp.com\/www.quantmod.com\/examples\/chartSeries3d\/chartSeries3d-thumb.png","contentUrl":"https:\/\/i2.wp.com\/www.quantmod.com\/examples\/chartSeries3d\/chartSeries3d-thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dcac.com\/2016\/05\/13\/did-you-know-r-services-is-in-standard-edition-of-sql-server-2016\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dcac.com\/"},{"@type":"ListItem","position":2,"name":"Did You Know?? R Services is in Standard Edition of SQL Server 2016"}]},{"@type":"WebSite","@id":"https:\/\/www.dcac.com\/#website","url":"https:\/\/www.dcac.com\/","name":"Denny Cherry & Associates Consulting","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dcac.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/ac58f2207d3f180aa3e4ee0ce6af0885","name":"Joey D'Antoni","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dcac.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3fede03569772a55a091b587d76f78d4?s=96&r=x","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3fede03569772a55a091b587d76f78d4?s=96&r=x","caption":"Joey D'Antoni"},"url":"https:\/\/www.dcac.com\/author\/joeydcac-co\/"}]}},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/6521","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/comments?post=6521"}],"version-history":[{"count":2,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/6521\/revisions"}],"predecessor-version":[{"id":8531,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/posts\/6521\/revisions\/8531"}],"wp:attachment":[{"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/media?parent=6521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/categories?post=6521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dcac.com\/wp-json\/wp\/v2\/tags?post=6521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}