<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="https://www.r-bloggers.com/r-and-sql-server-articles/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="https://tomaztsql.wordpress.com/2017/02/08/r-and-sql-server-articles/"> R – TomazTsql</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<p>In past couple of months, I have prepared several articles on R and SQL Server that have been published on <a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/">SQL Server Central</a>.</p>
<p>The idea was, to have couple of articles covering the introduction to R, to basics on R Server, to some practical cases on R with SQL Server.</p>
<h3><a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Language/140422/">1) Using Microsoft R in Enterprise Environments</a></h3>
<p>Article covers the concepts on Microsoft R Server, where and how to start with Microsoft R in enterprise environment and give answers to most common concerns people might have when introducing R language into corporation.</p>
<p><img sizes="(max-width: 553px) 100vw, 553px" data-image-description="" data-orig-file="https://tomaztsql.files.wordpress.com/2017/02/1.png" data-orig-size="825,539" data-image-title="1" class="wp-image-3579" data-comments-opened="1" data-recalc-dims="1" data-attachment-id="3579" data-permalink="https://tomaztsql.wordpress.com/2017/02/08/r-and-sql-server-articles/1-2/#main" alt="1" data-medium-file="https://tomaztsql.files.wordpress.com/2017/02/1.png?w=300" data-large-file="https://tomaztsql.files.wordpress.com/2017/02/1.png?w=700" data-image-meta="{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}" src="https://i1.wp.com/tomaztsql.files.wordpress.com/2017/02/1.png?resize=456%2C298&ssl=1"></p>
<h6>Link to article: <a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Language/140422/">http://www.sqlservercentral.com/articles/R+Language/140422/</a></h6>
<p> </p>
<h3><a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/Microsoft/145393/">2) Introduction to Microsoft R Services in SQL Server 2016</a></h3>
<p>Integration and architecture on Microsoft R Services is main focus of this article. It outlinesdifferent flavors of R (Open, Client, Server, Services, Hadoop, etc.), how to deal with installation and basic overview and explanation on extended stored procedure SP_EXECUTE_EXTERNAL_SCRIPT.</p>
<p><img sizes="(max-width: 554px) 100vw, 554px" data-image-description="" data-orig-file="https://i1.wp.com/tomaztsql.files.wordpress.com/2017/02/2.png?resize=456%2C391&amp;ssl=1" data-orig-size="781,670" data-image-title="2" data-comments-opened="1" class="wp-image-3594" data-recalc-dims="1" data-attachment-id="3594" data-permalink="https://tomaztsql.wordpress.com/2017/02/08/r-and-sql-server-articles/2-2/#main" alt="2.png" data-medium-file="https://i1.wp.com/tomaztsql.files.wordpress.com/2017/02/2.png?resize=456%2C391&amp;ssl=1?w=300" data-large-file="https://i1.wp.com/tomaztsql.files.wordpress.com/2017/02/2.png?resize=456%2C391&amp;ssl=1?w=700" data-image-meta="{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}" src="https://i1.wp.com/tomaztsql.files.wordpress.com/2017/02/2.png?resize=456%2C391&ssl=1"></p>
<h6>Link to article: <a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/Microsoft/145393/">http://www.sqlservercentral.com/articles/Microsoft/145393/</a></h6>
<p> </p>
<h3><a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Package/145571/">3) Installing R packages in SQL Server R Services</a></h3>
<p>Expand the functionality of R by adding new packages. Covers many ways how to install and add additional packages to your R environment.</p>
<p><img sizes="(max-width: 547px) 100vw, 547px" data-image-description="" data-orig-file="https://tomaztsql.files.wordpress.com/2017/02/3.png" data-orig-size="765,551" data-image-title="3" data-comments-opened="1" class="wp-image-3606" data-recalc-dims="1" data-attachment-id="3606" data-permalink="https://tomaztsql.wordpress.com/2017/02/08/r-and-sql-server-articles/3-2/#main" alt="3" data-medium-file="https://tomaztsql.files.wordpress.com/2017/02/3.png?w=300" data-large-file="https://tomaztsql.files.wordpress.com/2017/02/3.png?w=700" data-image-meta="{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}" src="https://i0.wp.com/tomaztsql.files.wordpress.com/2017/02/3.png?resize=456%2C328&ssl=1"></p>
<h6>Link to article: <a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Package/145571/">http://www.sqlservercentral.com/articles/R+Package/145571/</a></h6>
<p> </p>
<h3><a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Services/145649/">4) Using SQL Server and R Services for analyzing Sales data</a></h3>
<p>Providing use cases on analyzing sales data was focus of this article with goal to show readers and users how to ope rationalize and bring R code into use in any enterprise (small or big) environment.</p>
<p><img sizes="(max-width: 497px) 100vw, 497px" data-image-description="" data-orig-file="https://tomaztsql.files.wordpress.com/2017/02/4.png" data-orig-size="738,630" data-image-title="4" data-comments-opened="1" class="wp-image-3615" data-recalc-dims="1" data-attachment-id="3615" data-permalink="https://tomaztsql.wordpress.com/2017/02/08/r-and-sql-server-articles/4-2/#main" alt="4" data-medium-file="https://tomaztsql.files.wordpress.com/2017/02/4.png?w=300" data-large-file="https://tomaztsql.files.wordpress.com/2017/02/4.png?w=700" data-image-meta="{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}" src="https://i2.wp.com/tomaztsql.files.wordpress.com/2017/02/4.png?resize=456%2C389&ssl=1"></p>
<h6>Link to article: <a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Services/145649/">http://www.sqlservercentral.com/articles/R+Services/145649/</a></h6>
<p> </p>
<h3><a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Language/151358/">5) Using Power BI and SSRS for visualizing SQL Server and R data</a></h3>
<p>Visualizing the data for any use case, is also important aspect of understanding data insights. Article covers<a target="_blank" rel="nofollow" href="https://powerbi.microsoft.com/en-us/"> Power BI</a> and <a target="_blank" rel="nofollow" href="https://msdn.microsoft.com/en-us/library/ms159106.aspx">SSRS</a> visualization and how to embed R code in both tools.</p>
<p><img sizes="(max-width: 577px) 100vw, 577px" data-image-description="" data-orig-file="https://tomaztsql.files.wordpress.com/2017/02/5.png" data-orig-size="859,650" data-image-title="5" data-comments-opened="1" class="wp-image-3623" data-recalc-dims="1" data-attachment-id="3623" data-permalink="https://tomaztsql.wordpress.com/2017/02/08/r-and-sql-server-articles/attachment/5/#main" alt="5" data-medium-file="https://tomaztsql.files.wordpress.com/2017/02/5.png?w=300" data-large-file="https://tomaztsql.files.wordpress.com/2017/02/5.png?w=700" data-image-meta="{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}" src="https://i2.wp.com/tomaztsql.files.wordpress.com/2017/02/5.png?resize=456%2C345&ssl=1"></p>
<h6>Link to article: <a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Language/151358/">http://www.sqlservercentral.com/articles/R+Language/151358/</a></h6>
<h3></h3>
<h3><a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Language/151405/">6) Using SQL Server and R Services for analyzing DBA Tasks</a></h3>
<p>Broadening the use of Microsoft R for the DBA tasks was the main goal of this article. With simulation of  the disk usage, showing R example how to switch from monitoring the usage to predicting the usage of disk space. Clustering executed queries to narrow down performance issues and visualizing <a target="_blank" rel="nofollow" href="https://blogs.msdn.microsoft.com/mvpawardprogram/2016/03/29/sql-server-2016-query-store/">Query store</a> information with <a target="_blank" rel="nofollow" href="https://en.wikipedia.org/wiki/Heat_map">heatmap</a> were also introduced in article.</p>
<p><img sizes="(max-width: 571px) 100vw, 571px" data-image-description="" data-orig-file="https://i1.wp.com/tomaztsql.files.wordpress.com/2017/02/61.png?resize=456%2C303&amp;ssl=1" data-orig-size="781,518" data-image-title="6" data-comments-opened="1" class="wp-image-3669" data-recalc-dims="1" data-attachment-id="3669" data-permalink="https://tomaztsql.wordpress.com/2017/02/08/r-and-sql-server-articles/6-2/#main" alt="6" data-medium-file="https://i1.wp.com/tomaztsql.files.wordpress.com/2017/02/61.png?resize=456%2C303&amp;ssl=1?w=300" data-large-file="https://i1.wp.com/tomaztsql.files.wordpress.com/2017/02/61.png?resize=456%2C303&amp;ssl=1?w=700" data-image-meta="{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}" src="https://i1.wp.com/tomaztsql.files.wordpress.com/2017/02/61.png?resize=456%2C303&ssl=1"></p>
<h6>Link to article: <a target="_blank" rel="nofollow" href="http://www.sqlservercentral.com/articles/R+Language/151405/">http://www.sqlservercentral.com/articles/R+Language/151405/</a></h6>
<p> </p>
<p>More articles will follow, so stick around.</p>
<p>Happy R-SQLing!</p>
<p> </p>
<p> </p>
<p> <a target="_blank" rel="nofollow" href="http://feeds.wordpress.com/1.0/gocomments/tomaztsql.wordpress.com/3435/"><img alt="" src="http://feeds.wordpress.com/1.0/comments/tomaztsql.wordpress.com/3435/" border="0"></a> <img alt="" src="https://i1.wp.com/pixel.wp.com/b.gif?resize=1%2C1&ssl=1" border="0" data-recalc-dims="1"></p>
<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="https://tomaztsql.wordpress.com/2017/02/08/r-and-sql-server-articles/"> R – TomazTsql</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a title="The R Project for Statistical Computing" rel="nofollow" href="https://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/search/data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="https://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/search/map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/search/animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/search/sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/search/SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/search/git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/search/hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/search/PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/search/time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/search/trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/i0aTmovwGyQ"></a></div>