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

Articles with tag R Language Rss

Search for any content tagged r language

   Items 1 to 20 of 37    Older >>
 

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,677 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,087 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,827 reads

Loading Data using R and PowerBI

I'm not a fan of R visuals in PowerBI. I recently learned I can use R to load data and native PowerBI visuals to display the data. Here's how.  Read more...
By Nick Burns 2017/10/16 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 798 reads

Real-time moving averages for IoT with R

Computing an average over all your data is easy, but what if your data arrives incrementally and you need to be able to compute real-time averages on the fly? That's what we are going to look at.  Read more...
By Nick Burns 2017/10/02 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 464 reads

Moving beyond principal components analysis

Principal components analysis is a standard, but usually terrible, technique for visualising complex data. We're using network diagrams to solve this problem.  Read more...
By Nick Burns 2017/09/19 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 470 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 | 5,460 reads

Pattern Recognition via Principal Components Analysis

We'll look at using principal components analysis to help visualise your data and detect underlying structure or patterns.  Read more...
By Nick Burns 2017/09/12 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 837 reads

The Shortcomings of Predictive Accuracy

In prediction, accuracy is key. But it's not all it's cracked up to be as we will explore.  Read more...
By Nick Burns 2017/09/07 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 760 reads

SQL Server R Services: The Basics

It is possible to do a great deal with R within SQL Server, but it is best to start by doing analysis in R on numeric data from SQL Server and returning the results to SQL Server. There is great value to be gained even with this basic foundation. Robert Sheldon is on hand to give you a kick start with the first in his series on beginning with R in SQL Server.  Read more...
By Additional Articles 2017/08/10 | Source: SimpleTalk | Category: r services
Rating:  Rate this |   Briefcase | 6,279 reads

Ingest data from a web page into SQL Server 2017 using R

Siddharth Mehta shows that R libraries can be used from T-SQL to ingest data from the web into SQL Server.  Read more...
By Additional Articles 2017/08/03 | Source: MSSQLTips.com | Category: sql server 2017
Rating: (not yet rated)  Rate this |   Briefcase | 4,882 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 | 986 reads

Machine Learning for Outlier Detection in R

A look into clustering to detect outliers in R. An extension on univariate statistical tests to include multivariate data.  Read more...
By Nick Burns 2017/07/05 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 680 reads

Scoring Outliers in Non-Normal Data with R

Using R to detect outliers is relatively easy, but most methods assume your data is normally distributed. How do you handle skewed datasets?  Read more...
By Nick Burns 2017/06/29 | Source: SQLServerCentral.com | Category: outlier detection
Rating: |  Discuss |   Briefcase | 610 reads

Scoring Outliers with R

What is normal? More to the point, what is abnormal? We will look at using R to score outliers in a typical monitoring dataset.  Read more...
By Nick Burns 2017/06/19 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 851 reads

What is normal? Finding outliers with R

How do you currently set alerting thresholds? What is normal? And more importantly, what is truly abnormal? We will explore these questions.  Read more...
By Nick Burns 2017/06/13 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 999 reads

Combining R and SQL Server to diagnose performance bottlenecks

Using clustering algorithms to analyse index usage data from SQL Server’s DMVs & simplify complex performance investigations.  Read more...
By Nick Burns 2017/05/29 (first published: 2015/12/07) | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 9,119 reads

Do I Need to Learn Linux and R and Python?

The SQL Server platform is growing, but Steve Jones notes that this might not really affect our jobs.  Read more...
By Steve Jones 2017/05/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 572 reads

Using SQL Server and R Services for analyzing DBA Tasks

Article shows how R Services can help database administrators with their daily work   Read more...
By Tomaž Kaštrun 2017/02/07 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,359 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,610 reads
   Items 1 to 20 of 37    Older >>