<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-tools-for-visual-studio-0-5-now-available/"></div></div><div><a data-url="https://www.r-bloggers.com/r-tools-for-visual-studio-0-5-now-available/" data-counturl="https://www.r-bloggers.com/r-tools-for-visual-studio-0-5-now-available/" data-count="horizontal" data-text="R Tools for Visual Studio 0.5 now available" class="twitter-share-button" data-via="rbloggers" href="https://twitter.com/share"></a></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2016/10/rtvs-05-now-available.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p><a target="_blank" rel="nofollow" href="https://microsoft.github.io/RTVS-docs/">R Tools for Visual Studio</a>, the open-source Visual Studio add-in for R programmers, has a new update available for download. RTVS 0.5 makes it easier to <a target="_blank" rel="nofollow" href="https://microsoft.github.io/RTVS-docs/sqlserver.html">run R within SQL Server 2016 as a stored procedure</a>, and supports <a target="_blank" rel="nofollow" href="https://microsoft.github.io/RTVS-docs/plotting.html">multiple windows for R graphics</a>.</p>
<p>RTVS 0.5 makes use of Visual Studio's polyglot nature so you can manage and edit SQL queries within R projects. You can now add a SQL query to an R project, add a database connection, and easily check the output from the query. (You can even inspect the execution plan to optimize the query.) Once you've got a query that works, you can click to generate a connection string to use with the <a target="_blank" rel="nofollow" href="https://mran.microsoft.com/package/RODBC/">RODBC package</a>. This short video explains the process. </p>
<p><iframe height="281" allowfullscreen="" width="500" src="https://www.youtube.com/embed/n4AYr0QIwdQ?rel=0"></iframe></p>
<p>RTVS also makes it easy to run R code as a SQL Server 2016 stored procedure. (This is a great way to make share the results of R code with other database users while making use of the power of the database for R computations.) The new SQL R Stored Procedure file works with <a target="_blank" rel="nofollow" href="https://msdn.microsoft.com/en-us/library/mt604845.aspx">SQL Server R Services</a> to create a stored procedure that embeds R code you create, edit and test within RTVS. This greatly simplifies the process of running R code within SQL Server 2016 as you can see below:</p>
<p><iframe height="281" allowfullscreen="" width="500" src="https://www.youtube.com/embed/dFKIT2OitWQ?rel=0"></iframe></p>
<p> </p>
<p>The other major new feature from this release is the ability to create multiple plot windows, each of which can be docked within Visual Studio or float free as a separate window. Each window also maintains a history of previous plots, which can be retrieved either by using the back arrow or by browsing thumbnails in the plot history window. Here's how it works:</p>
<p><iframe height="281" allowfullscreen="" width="500" src="https://www.youtube.com/embed/ZTbKmz5RSgY?rel=0"></iframe></p>
<p>To use RTVS 0.5 you'll need to install/upgrade to Visual Studio 2015 Update 3 (either the <a target="_blank" rel="nofollow" href="https://www.visualstudio.com/en-us/products/visual-studio-community-vs.aspx">free Community</a> or Professional/Enterprise versions) first. And of course you'll also need an R installation: <a target="_blank" rel="nofollow" href="https://cloud.r-project.org/bin/windows/base/">CRAN R</a>, <a target="_blank" rel="nofollow" href="https://mran.revolutionanalytics.com/download/">Microsoft R Open</a>, and <a target="_blank" rel="nofollow" href="https://msdn.microsoft.com/microsoft-r/r-client-install/">Microsoft R Client</a> are all supported. </p>
<p>For more information on RTVS, check out the<a target="_blank" rel="nofollow" href="https://microsoft.github.io/RTVS-docs/"> RTVS home page</a>, or visit the <a target="_blank" rel="nofollow" href="https://github.com/Microsoft/RTVS">RTVS repository on Github</a>.</p>
</div>
<p><div><div><div><div data-width="55" data-show-faces="false" data-send="true" data-layout="box_count" data-height="62" data-href="https://www.r-bloggers.com/r-tools-for-visual-studio-0-5-now-available/"></div></div><div><a data-url="https://www.r-bloggers.com/r-tools-for-visual-studio-0-5-now-available/" data-counturl="https://www.r-bloggers.com/r-tools-for-visual-studio-0-5-now-available/" data-count="vertical" data-text="R Tools for Visual Studio 0.5 now available" class="twitter-share-button" data-via="rbloggers" href="https://twitter.com/share"></a></div><div></div></div><div></div></div>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://blog.revolutionanalytics.com/2016/10/rtvs-05-now-available.html"> Revolutions</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/?s=tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/?s=data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/?s=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/?s=ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/?s=map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/?s=animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/?s=RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/?s=sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/?s=LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/?s=SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/?s=eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/?s=git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/?s=hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/?s=Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/?s=regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/?s=PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/?s=time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/?s=trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/tK2q7WirLH8"></a></div>