SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag SQL Server R Services Rss

Search for any content tagged sql server r services

   Items 1 to 9 of 9   
 

SQL Server R Services: Working with Multiple Data Sets

Although it is easy to use SQL Server R Services to create R scripts that incorporate SQL Server data by passing in a T-SQL query as an argument when calling the sp_execute_external_script stored procedure, you are limited to that one query, unless you pass additional data directly between R and SQL Server via CSV files. It is simple to do, and opens up many additional opportunities for data analysis. Robert Sheldon explains how.  Read more...
By Additional Articles 2017/12/07 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 3,366 reads

SQL Server R Services: Generating Sparklines and Other Types of Spark Graphs

By being able to run R from SQL Server, you have available to you not just a convenient way of performing analysis on data but also a wide range of more specialized graphical facilities. Rob Sheldon illustrates the point by demonstrating how you can create sparklines that can then be embedded in reports.  Read more...
By 2017/11/23 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,825 reads

Advanced Analytics with R & SQL: Part I - R Distributions

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.   Read more...
By Frank A. Banin 2017/11/10 (first published: 2016/10/31) | Source: SQLServerCentral.com | Category: data science
Rating: |  Discuss |   Briefcase | 2,497 reads

SQL Server R Services: Working with Data Frames

Although you can get started with R in SQL Server without understanding data frames, they are a key structure of the R language that are the equivalent of SQL Server table variables. They give you many ways of manipulating and analyzing data and passing it between R and SQL Server. For a database professional, they provide a clear and familiar concept when getting to grips with integrating R into the database.  Read more...
By Additional Articles 2017/11/08 | Source: SimpleTalk | Category: r services
Rating: (not yet rated)  Rate this |   Briefcase | 3,221 reads

SQL Server R Services: Working with ggplot2 Statistical Graphics

It is when you use R in SQL Server with one of the huge range of packages that comes with it that you can begin to appreciate the power of the system. With a package such as ggplot there are many 'knobs one can twiddle' in order to get spectacular and informative visualisations. Rob Sheldon continues his beginners series for R in SQL Server by showing how to refine the output to get it as you need it.  Read more...
By Additional Articles 2017/10/25 | Source: SimpleTalk | Category: sql server r services
Rating: (not yet rated)  Rate this |   Briefcase | 2,967 reads

SQL Server R Services: Digging into the R Language

It is not just the analytic power of R that you get from using SQL Server R Services, but also the great range of packages that can be run in R that provide a daunting range of graphing and plotting facilities. Robert Sheldon shows how you can take data held in SQL Server and, via SQL Server R Services, use an R package called ggPlot that offers a powerful graphics language for creating elegant and complex plots.  Read more...
By Additional Articles 2017/09/15 | Source: SimpleTalk | Category: sql server r services
Rating:  Rate this |   Briefcase | 6,384 reads

Advanced Analytics with R and SQL Part II - Data Science Scenarios

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.   Read more...
By Frank A. Banin 2017/07/27 | Source: SQLServerCentral.com | Category: data science
Rating: |  Discuss |   Briefcase | 1,016 reads

Using Power BI and SSRS for visualizing SQL Server and R data (Part 4)

Using R with Power BI, SSRS or RTVS for easier data visualization  Read more...
By Tomaž Kaštrun 2017/01/24 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,632 reads

Advanced Analytics with R & SQL: Part I - R Distributions

Build and Operationalize scalable Predictive models and intelligent applications using SQL and R.   Read more...
By Frank A. Banin 2017/11/10 (first published: 2016/10/31) | Source: SQLServerCentral.com | Category: data science
Rating: |  Discuss |   Briefcase | 2,497 reads
   Items 1 to 9 of 9