<p><div><div><div><div data-show-faces="false" data-height="21" data-width="100" data-layout="button_count" data-send="true" data-href="https://www.r-bloggers.com/book-review-sql-server-2017-machine-learning-services-with-r/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2018/09/sql-server-2017-book-review.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p><a rel="nofollow" href="https://tomaztsql.wordpress.com/2018/08/06/sql-server-2017-machine-learning-services-with-r-book/" target="_blank"><img alt="SQLbook_cover" title="SQLbook_cover" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b022ad3ae564c200b-200wi"></a>If you want to do statistical analysis or machine learning with data in SQL Server, you can of course extract the data from SQL Server and then analyze it in R or Python. But a better way is to run R or Python <em>within</em> the database, using <a rel="nofollow" href="https://docs.microsoft.com/sql/advanced-analytics/what-is-sql-server-machine-learning?view=sql-server-2017&WT.mc_id=Revolutions-blog-davidsmi" target="_blank">Microsoft ML Services</a> in SQL Server 2017. Why? </p>
<ul>
<li><strong>It's faster</strong>. Not only to you get to use the SQL Server instance (which is likely to be faster than your local machine), but it also means you no longer have to transport the data over a network, which is likely to be the biggest factor, particularly when working with large data sets.</li>
<li><strong>It operationalizes your analysis</strong>. Rather than running an ad-hoc analysis on your desktop, you can instead <a rel="nofollow" href="https://docs.microsoft.com/sql/advanced-analytics/r/how-to-create-a-stored-procedure-using-sqlrutils?view=sql-server-2017&WT.mc_id=Revolutions-blog-davidsmi" target="_blank">publish it as a stored procedure</a>, and make your analysis available on demand as a SQL query,</li>
<li><strong>It's more powerful</strong>. Not only can you use all of open-source R and Python within SQL Server, but you also get access to dedicated Microsoft libraries in R/Python including <a rel="nofollow" href="https://docs.microsoft.com/sql/advanced-analytics/r/revoscaler-overview?view=sql-server-2017&WT.mc_id=Revolutions-blog-davidsmi" target="_blank">RevoScaleR</a>/<a rel="nofollow" href="https://docs.microsoft.com/sql/advanced-analytics/python/what-is-revoscalepy?view=sql-server-2017&WT.mc_id=Revolutions-blog-davidsmi" target="_blank">revoscalepy</a> and <a rel="nofollow" href="https://docs.microsoft.com/machine-learning-server/r-reference/microsoftml/microsoftml-package?WT.mc_id=Revolutions-blog-davidsmi" target="_blank">MicrosoftML</a>/<a rel="nofollow" href="https://docs.microsoft.com/machine-learning-server/python-reference/microsoftml/microsoftml-package?WT.mc_id=Revolutions-blog-davidsmi" target="_blank">microsoftml</a>, which provide algorithms optimized for large data sets in SQL Server.</li>
</ul>
<p>If you'd like to learn how to run R within SQL Server, a great resource is the book <a rel="nofollow" href="https://www.packtpub.com/big-data-and-business-intelligence/sql-server-2017-machine-learning-services-r" target="_blank">SQL Server 2017 Machine Learning Services with R</a>, by Tomaž Kaštrun and Julie Koesmarno. At over 300 pages, the book covers every detail, including installation and configuration, an overview of data analysis in R, operationalizing R code in SQL Server and via Power BI, and using the aforementioned extension libraries for R. It's mostly aimed at R-using data scientists, but does includes a chapter for database administrations to provide an introduction to R for DBAs as well. In short, it contains everything you need to know to build production applications with R and SQL Server 2017 (or 2016), backed up with a wealth of examples from industry.</p>
<p>You can purchase a paperback copy from your favorite bookseller, and you can also get a discounted digital edition from the publisher at the link below.</p>
<p>Packt Publishing: <a rel="nofollow" href="https://www.packtpub.com/big-data-and-business-intelligence/sql-server-2017-machine-learning-services-r" target="_blank">SQL Server 2017 Machine Learning Services with R</a></p>
<p> </p>
</div>
	<p>
<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/2018/09/sql-server-2017-book-review.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 rel="nofollow" href="https://www.r-project.org/" title="The R Project for Statistical Computing">R</a> news and <a rel="nofollow" href="https://www.r-bloggers.com/search/tutorial" title="R tutorials">tutorials</a> on topics such as: <a rel="nofollow" href="https://www.r-bloggers.com/search/data%20science" title="Data science">Data science</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data" title="Big Data">Big Data, <a rel="nofollow" href="https://www.r-users.com/" title="R jobs">R jobs</a>, visualization (<a rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2" title="ggplot and ggplot2 tutorials">ggplot2</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/boxplot" title="Boxplots using lattice and ggplot2 tutorials">Boxplots</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/map" title="Maps and gis">maps</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/animation" title="Animation in R">animation</a>), programming (<a rel="nofollow" href="https://www.r-bloggers.com/search/RStudio" title="RStudio IDE for R">RStudio</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/sweave" title="Sweave and literate programming">Sweave</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX" title="LaTeX in R">LaTeX</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/SQL" title="SQL and databases">SQL</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/eclipse" title="Eclipse IDE for R">Eclipse</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/git" title="git and github, Version Control System">git</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/hadoop" title="Large data in R using Hadoop">hadoop</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping" title="Web Scraping of google, facebook, yahoo, twitter and more using R">Web Scraping</a>) statistics (<a rel="nofollow" href="https://www.r-bloggers.com/search/regression" title="Regressions and ANOVA analysis tutorials">regression</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/PCA" title="principal component analysis tutorial">PCA</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/time+series" title="Time series">time series</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/trading" title="finance trading">trading</a>) and more...
<img width="1" alt="" src="http://feeds.feedburner.com/~r/RBloggers/~4/6xteA-yJTYE" height="1"></a></div>