{"id":7786,"date":"2016-05-04T07:40:18","date_gmt":"2016-05-04T05:40:18","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/"},"modified":"2016-05-04T07:40:18","modified_gmt":"2016-05-04T05:40:18","slug":"sql-server-2016-microsoft-r-server","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/","title":{"rendered":"SQL Server 2016: Microsoft R Server"},"content":{"rendered":"<p>In my last article, I wrote about the<a title=\"SQL Server 2016 R Services\" href=\"http:\/\/dbi-services.com\/blog\/sql-server-2016-r-services\/\" target=\"_blank\"> R Services into SQL Server<\/a>.<br \/>\nNow, Microsoft provides an <strong>open source R platform<\/strong> to complete this new SQL Server integrated feature in 2016.<br \/>\nOn the Microsoft Website, you can download directly R Server 2016 for different operating systems:<\/p>\n<ul>\n<li>Windows of course<\/li>\n<li>SUSE Linux<\/li>\n<li>Red Hat Linux<\/li>\n<li>Version for Hadoop on Red Hat<\/li>\n<li>Version for Teradata DB<\/li>\n<\/ul>\n<p>Here is the<a title=\"R server download link\" href=\"https:\/\/myprodscussu1.app.vssubscriptions.visualstudio.com\/downloads?pid=1962\" target=\"_blank\"> link<\/a><\/p>\n<h3>Installation<\/h3>\n<p>In the SQL Server Installation Center on the Installation Tab, you will find a new installation menu: <strong>New R Server (Standalone) installation<\/strong><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8457 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01.png\" alt=\"Rserver01\" width=\"300\" height=\"169\" \/><\/a><\/p>\n<p>This will install the R Server and automatically select the R Server (Standalone) in the shared Feature.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8458 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver02.png\" alt=\"Rserver02\" width=\"300\" height=\"224\" \/><\/a><\/p>\n<p>Msdn link <a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/mt674874.aspx\" target=\"_blank\">here<br \/>\n<\/a>After, you have a new step \u201c<strong><em>Consent to install Microsoft R Open<\/em><\/strong>\u201d and click Accept.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver03.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8459 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver03.png\" alt=\"Rserver03\" width=\"300\" height=\"225\" \/><\/a><\/p>\n<p>At the end, you need to restart your server<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8460 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver04.png\" alt=\"Rserver04\" width=\"300\" height=\"223\" \/><\/a><\/p>\n<p>After the restart, you can see that all files for the R Server are installed on <strong><em>&lt;SQL Server root path&gt;\\130\\R_Server<\/em><\/strong><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8461 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver05.png\" alt=\"Rserver05\" width=\"300\" height=\"223\" \/><\/a><\/p>\n<p>If you want to run the R interface, you need to go to &lt;SQL Server root path&gt;\\130\\R_Server\\bin\\x64 and run the <strong>Rgui.exe<\/strong><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver06.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8462 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver06.png\" alt=\"Rserver06\" width=\"300\" height=\"164\" \/><\/a><\/p>\n<p>In order to run R without an interface just like command line, you need to run <strong>R.exe<\/strong> or <strong>Rterm.exe<\/strong> from the same folder.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver07.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8463 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver07.png\" alt=\"Rserver07\" width=\"300\" height=\"158\" \/><\/a><\/p>\n<p>Like all new programming toy, I test to have a \u201cHello World\u201d. \ud83d\ude00<br \/>\nThe command is simple:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">print(\u201cHello World\u201d)<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver08.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8464 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver08.png\" alt=\"Rserver08\" width=\"300\" height=\"135\" \/><\/a><\/p>\n<p>I push my test with a simple addition:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\"> print (32.7+10.24)<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver09.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8465 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver09.png\" alt=\"Rserver09\" width=\"300\" height=\"203\" \/><\/a><\/p>\n<p>After my easy test, I try to connect my R Server with a SQL Server\u2026<\/p>\n<h3><strong>Configure to use SQL Server <\/strong><\/h3>\n<p>To use SQL Server, I search the <a title=\"RSQLServer package\" href=\"https:\/\/cran.r-project.org\/web\/packages\/RSQLServer\/index.html\" target=\"_blank\">RSQLServer package on CRAN website<\/a><br \/>\nI copy all files in the folder libraries.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver17.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8473 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver17.png\" alt=\"Rserver17\" width=\"300\" height=\"203\" \/><\/a><\/p>\n<p>After, I load the library with the command:<\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">library(RSQLServer)<\/pre>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver10.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8466 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver10.png\" alt=\"Rserver10\" width=\"300\" height=\"200\" \/><\/a><\/p>\n<p>I obtain an error and see that the package need the package DBI.<br \/>\nIt is not dbi services package, it is DataBase Interface, but the sameness was cool! \ud83d\ude09<br \/>\nBefore I continue, I give you just a little tips that I discovered during my tests:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver15.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8471 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver15.png\" alt=\"Rserver15\" width=\"300\" height=\"153\" \/><\/a><\/p>\n<p>Yes, as you can see it is <strong>case sensitive.<\/strong><\/p>\n<p>I search now the <a title=\"DBI package\" href=\"https:\/\/cran.r-project.org\/web\/packages\/DBI\/index.html\" target=\"_blank\">DBI package on CRAN website<\/a><br \/>\nI reload the library RSQLServer and I have a new error for a missing package pylyr\u2026<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver11.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8467 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver11.png\" alt=\"Rserver11\" width=\"300\" height=\"249\" \/><\/a><\/p>\n<p>I continue with a lot of missing packages and a give you the list of these packages:<\/p>\n<ul>\n<li>RSQLServer (<a title=\"RSQLServer package\" href=\"https:\/\/github.com\/imanuelcostigan\/RSQLServer\" target=\"_blank\">link<\/a>)<\/li>\n<li>DBI(<a title=\"DBI package\" href=\"https:\/\/cran.rstudio.com\/web\/packages\/DBI\/index.html\" target=\"_blank\">link<\/a>)<\/li>\n<li>dplyr(<a title=\"dplyr package\" href=\"https:\/\/cran.r-project.org\/web\/packages\/dplyr\/index.html\" target=\"_blank\">link<\/a>)<\/li>\n<li>assertthat(<a title=\"assertthat package\" href=\"https:\/\/cran.r-project.org\/web\/packages\/assertthat\/index.html\" target=\"_blank\">link<\/a>)<\/li>\n<li>R6(<a title=\"R6 package\" href=\"https:\/\/cran.r-project.org\/web\/packages\/R6\/index.html\" target=\"_blank\">link<\/a>)<\/li>\n<li>Rcpp(<a title=\"Rcpp package\" href=\"https:\/\/cran.r-project.org\/web\/packages\/Rcpp\/index.html\" target=\"_blank\">link<\/a>)<\/li>\n<li>Magrittr(<a title=\"magrittr package\" href=\"https:\/\/cran.r-project.org\/web\/packages\/magrittr\/index.html\" target=\"_blank\">link<\/a>)<\/li>\n<li>RJDBC(<a title=\"RJDBC\" href=\"https:\/\/cran.r-project.org\/web\/packages\/RJDBC\/index.html\" target=\"_blank\">link<\/a>)<\/li>\n<li>rJava(<a title=\"rjava package\" href=\"https:\/\/cran.r-project.org\/web\/packages\/rJava\/index.html\" target=\"_blank\">link<\/a>)<\/li>\n<\/ul>\n<p>Don\u2019t forget, it is just a copy in the library folder:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver16.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8472 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver16.png\" alt=\"Rserver16\" width=\"300\" height=\"180\" \/><\/a><\/p>\n<p>I finished with a Java problem in the package rJava<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver14.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8470 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver14.png\" alt=\"Rserver14\" width=\"300\" height=\"171\" \/><\/a><\/p>\n<p>I install the JRE like in the picture and now, my RSQLServer library is loaded\u2026 \ud83d\ude0e<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver18.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8474 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver18.png\" alt=\"Rserver18\" width=\"300\" height=\"207\" \/><\/a><\/p>\n<p>At the end, you need <strong>9 packages for RSQLServer and the JRE<\/strong>\u2026<\/p>\n<h3><strong>Use the SQL Server connector<\/strong><\/h3>\n<p>After that, I will connect the SQL Server database and I use the command <strong>dbConnect<\/strong>:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver19.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8475 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver19.png\" alt=\"Rserver19\" width=\"300\" height=\"125\" \/><\/a><\/p>\n<p>I can read a table with 2 functions:<\/p>\n<ul>\n<li>\u00a0<strong>dbReadTable<\/strong> with just the table name to read (read all the table)<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver20.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-8476\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver20.png\" alt=\"Rserver20\" width=\"300\" height=\"123\" \/><\/a><\/li>\n<\/ul>\n<ul>\n<li><strong>dbSendQuery<\/strong> with the select query (is more flexible) and <strong>fetch<\/strong> to see the result<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver21.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-8477\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver21.png\" alt=\"Rserver21\" width=\"300\" height=\"120\" \/><\/a><\/li>\n<\/ul>\n<p>For the fun, I have executed an R script into the SQL command through the R Server used for my precedent blog on R Services:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver22.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8478 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver22.png\" alt=\"Rserver22\" width=\"300\" height=\"126\" \/><\/a><\/p>\n<p>Be careful, you need to go at the line with command (see the \u201c+\u201c symbol in the picture)<\/p>\n<p><strong>Code used:<\/strong><\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">library(RSQLServer)\nconn &lt;- dbConnect(RSQLServer::SQLServer(),server=\"169.254.248.110\", port=1433,database=\"R_TEST\",properties=list(user=\"R_user\",password=\"R_user\"))\ndbReadTable(conn,name='R_Table')\nres = dbSendQuery(conn,'SELECT * FROM R_Table')\nfetch(res,n=-1)\nres = dbSendQuery(conn,'execute sp_execute_external_script @language=N\\'R\\', @script= N\\' n = c(1, 2, 3, 4, 5)\ns = c(\"titi\", \"toto\", \"tata\", \"tete\", \"tutu\")\nOutputDataSet&lt;- data.frame(n,s);\\',@input_data_1 = N\\' \\' WITH RESULT SETS (([C_1] int, [C_2] varchar(10) ));')\nfetch(res,n=-1)\ndbDisconnect(conn)<\/pre>\n<p>Finally, it is a good test to install and configure the R Server to be connected to a SQL Server instance.<br \/>\nYou have seen that the installation is very simple but you have a lot of steps in the configuration of the RSQLServer package before you can use it.<br \/>\nNow, you can play with it and have nice statistics before\u2026.<br \/>\nNow, to develop with R language, you have a plugin in Visual Studio <a title=\"R language plugin for Visual Studio\" href=\"https:\/\/www.visualstudio.com\/en-us\/features\/rtvs-vs.aspx\" target=\"_blank\">here<\/a><br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver23.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-8479 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver23.png\" alt=\"Rserver23\" width=\"300\" height=\"182\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In my last article, I wrote about the R Services into SQL Server. Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016. On the Microsoft Website, you can download directly R Server 2016 for different operating systems: Windows of course SUSE Linux Red Hat Linux Version [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":7808,"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-7786","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: Microsoft R Server - dbi Blog<\/title>\n<meta name=\"description\" content=\"Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.\" \/>\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-microsoft-r-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: Microsoft R Server\" \/>\n<meta property=\"og:description\" content=\"Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-05-04T05:40:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"911\" \/>\n\t<meta property=\"og:image:height\" content=\"513\" \/>\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=\"4 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-microsoft-r-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016: Microsoft R Server\",\"datePublished\":\"2016-05-04T05:40:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/\"},\"wordCount\":623,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-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-microsoft-r-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/\",\"name\":\"SQL Server 2016: Microsoft R Server - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-1.png\",\"datePublished\":\"2016-05-04T05:40:18+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-1.png\",\"width\":911,\"height\":513},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: Microsoft R Server\"}]},{\"@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: Microsoft R Server - dbi Blog","description":"Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.","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-microsoft-r-server\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: Microsoft R Server","og_description":"Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/","og_site_name":"dbi Blog","article_published_time":"2016-05-04T05:40:18+00:00","og_image":[{"width":911,"height":513,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016: Microsoft R Server","datePublished":"2016-05-04T05:40:18+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/"},"wordCount":623,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-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-microsoft-r-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/","name":"SQL Server 2016: Microsoft R Server - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-1.png","datePublished":"2016-05-04T05:40:18+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"Now, Microsoft provides an open source R platform to complete this new SQL Server integrated feature in 2016.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Rserver01-1.png","width":911,"height":513},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-microsoft-r-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: Microsoft R Server"}]},{"@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\/7786","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=7786"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7786\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/7808"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7786"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7786"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7786"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7786"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}