{"id":7650,"date":"2016-04-19T13:25:07","date_gmt":"2016-04-19T11:25:07","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/"},"modified":"2016-04-19T13:25:07","modified_gmt":"2016-04-19T11:25:07","slug":"sql-server-2016-r-services","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/","title":{"rendered":"SQL Server 2016: R Services"},"content":{"rendered":"<p>I was during a long time captivated by the R programming language.<br \/>\nI&#8217;m happy to see that SQL Server 2016 provides now a SQL Server R Services.<\/p>\n<p>This service enables SQL Server to execute R scripts.<br \/>\nThe first step is to install the R Services during the installation of SQL Server.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8213 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01.png\" alt=\"Rservice01\" width=\"300\" height=\"184\" \/><\/a><\/p>\n<p>As you can see on the picture, you have 2 selections in the feature Selection Menu:<\/p>\n<ul>\n<li><strong>R Services (In-Database)<\/strong> is the service that enable the usage of the R Script in SQL Server. MSDN link <a title=\"R Services (In-Database)\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt604845.aspx\" target=\"_blank\">here<\/a><\/li>\n<li><strong>R Server (Standalone)<\/strong> is a server environment to run R jobs based on the enhanced R packages developed by Revolution Analytics. MSDN link <a title=\"R Server (Standalone)\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt671127.aspx\" target=\"_blank\">here<\/a><\/li>\n<\/ul>\n<p>Tips: to install by script the R service, you need to use <strong>ADVANCEDANALYTICS<\/strong> keyword and for the R Server <strong>SQL_SHARED_MR<\/strong> keyword.<\/p>\n<p>You can check the configurationfile.ini generated.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice12.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8224 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice12.png\" alt=\"Rservice12\" width=\"300\" height=\"154\" \/><\/a><\/p>\n<p>To start my test, I create a simple database with one table in my environment.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8214 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice02.png\" alt=\"Rservice02\" width=\"300\" height=\"125\" \/><\/a><\/p>\n<p>Now, you have to configure the instance to be able to use R script.<br \/>\nIn the instance configuration, you need to set the \u2018<strong>external script enabled<\/strong>\u2019 to 1.<br \/>\nScript to search the configuration:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SELECT * FROM sys.configurations WHERE name='external scripts enabled'\n<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8215 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice03.png\" alt=\"Rservice03\" width=\"300\" height=\"105\" \/><\/a><br \/>\nAs you can see in the result, this configuration is not dynamic and need a restart of the engine.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8216 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice04.png\" alt=\"Rservice04\" width=\"300\" height=\"70\" \/><\/a><br \/>\nAfter a restart, the configuration is enabled.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8217 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice05.png\" alt=\"Rservice05\" width=\"300\" height=\"51\" \/><\/a><br \/>\nTo start a R script, you will use the stored procedure <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt604368.aspx\" target=\"_blank\"><strong>sp_execute_external_script<\/strong><\/a><\/p>\n<p>The first parameter is the language (@language) and the only valid value is \u2018R\u2019 \ud83d\ude00<br \/>\nThe second parameter is the R script (@script) as a literal or variable input and is a nvarchar(max).<br \/>\nThe next parameter is the input data (@<em>input_data_1_name<\/em>) as a T-SQL query and is also a nvarchar(max)<br \/>\nThe fourth parameter is the output data name (@<em>output_data_1_name<\/em>) and the default value is \u201cOutputDataSet\u201d<br \/>\nI thing these are the main parameters to a first usage.<\/p>\n<p>The other thing to add is the &lt;execution_option&gt;\u00a0 like \u201cWITH RESULT SETS \u2026\u201d<\/p>\n<p>For my first test, I use the easy sample from the<a title=\"Verify R is running - MSDN\" href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt696069.aspx\" target=\"_blank\"> MSDN to verify that R is running<\/a><\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">exec sp_execute_external_script  @language =N'R',\n@script=N'OutputDataSet&lt;-InputDataSet',  \n@input_data_1 =N'select 1 as hello'\nwith result sets (([hello] int not null));<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice06.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8218 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice06.png\" alt=\"Rservice06\" width=\"300\" height=\"123\" \/><\/a><\/p>\n<p>As you can see I have this Error message:<br \/>\n<span style=\"color: red\"><em>Msg 39011, Level 16, State 1, Line 23<br \/>\nSQL Server was unable to communicate with the LaunchPad service. Please verify the configuration of the service.\u00a0<\/em><\/span><\/p>\n<p>I google it and find that I need to start the \u201c<strong>SQL Server LaunchPad<\/strong>\u201d service.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice07.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8219 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice07.png\" alt=\"Rservice07\" width=\"300\" height=\"97\" \/><\/a><br \/>\nEt Voil\u00e0! I have run my first R script into SQL Server.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice08.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8220 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice08.png\" alt=\"Rservice08\" width=\"300\" height=\"190\" \/><\/a><br \/>\nI come back to my table named R_Table that I created before and I will use now the R language with this table.<br \/>\nThe first test is to select my first column C_1:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">exec sp_execute_external_script\n  @language = N'R'\n, @script = N' OutputDataSet &lt;- InputDataSet;'\n, @input_data_1 = N' SELECT [C_1] FROM R_Table;'\nWITH RESULT SETS (([C_1] int NOT NULL));<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice09.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8221 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice09.png\" alt=\"Rservice09\" width=\"300\" height=\"259\" \/><\/a><br \/>\nThe second test is to select my second column C_2 and as you can see, it works!<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice10.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8222 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice10.png\" alt=\"Rservice10\" width=\"300\" height=\"216\" \/><\/a><br \/>\nI also test an easy case without T_SQL script in input:<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">execute sp_execute_external_script\n  @language = N'R'\n, @script = N' n = c(1, 2, 3, 4, 5) \ns = c(\"titi\", \"toto\", \"tata\", \"tete\", \"tutu\") \nOutputDataSet&lt;- data.frame(n, s);'\n, @input_data_1 = N'  '\nWITH RESULT SETS (([C_1] int, [C_2] varchar(10) ));<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice11.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8223 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice11.png\" alt=\"Rservice11\" width=\"300\" height=\"237\" \/><\/a><br \/>\nIt is just the beginning of the R language script into SQL Server.<br \/>\nI let you discovered by yourself this powerful new feature in SQL Server 2016.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I was during a long time captivated by the R programming language. I&#8217;m happy to see that SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts. The first step is to install the R Services during the installation of SQL Server. As you can see [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":7663,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368,48],"tags":[49,51,566],"type_dbi":[],"class_list":["post-7650","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-development-performance","category-technology-survey","tag-microsoft","tag-sql-server","tag-sql-server-2016"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL SERVER 2016 R service<\/title>\n<meta name=\"description\" content=\"SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts.\" \/>\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.dbi-services.com\/blog\/sql-server-2016-r-services\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: R Services\" \/>\n<meta property=\"og:description\" content=\"SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-19T11:25:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"856\" \/>\n\t<meta property=\"og:image:height\" content=\"524\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016: R Services\",\"datePublished\":\"2016-04-19T11:25:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/\"},\"wordCount\":493,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"SQL Server 2016\"],\"articleSection\":[\"Development &amp; Performance\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/\",\"name\":\"SQL SERVER 2016 R service\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png\",\"datePublished\":\"2016-04-19T11:25:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png\",\"width\":856,\"height\":524},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: R Services\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL SERVER 2016 R service","description":"SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts.","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.dbi-services.com\/blog\/sql-server-2016-r-services\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: R Services","og_description":"SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/","og_site_name":"dbi Blog","article_published_time":"2016-04-19T11:25:07+00:00","og_image":[{"width":856,"height":524,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016: R Services","datePublished":"2016-04-19T11:25:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/"},"wordCount":493,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png","keywords":["Microsoft","SQL Server","SQL Server 2016"],"articleSection":["Development &amp; Performance","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/","name":"SQL SERVER 2016 R service","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png","datePublished":"2016-04-19T11:25:07+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"SQL Server 2016 provides now a SQL Server R Services. This service enables SQL Server to execute R scripts.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rservice01-1.png","width":856,"height":524},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-r-services\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: R Services"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=7650"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7650\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/7663"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7650"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}