Click here to monitor SSC
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 10 of 10   
 

Beyond prediction with R & SQL Server

Predictive / prescriptive analytics is regarded the highest level of advanced analytics. In this post, we emphasise the importance of exploratory analytics to derive meaningful insight.  Read more...
By Nick Burns 2016/08/18 | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 1,381 reads

Why Use R Services?

R Services were added to SQL Server 2016, and there are customers using this feature to improve their business processes.  Read more...
By Steve Jones 2016/06/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 114 reads

Using R Machine Learning Script as a Power BI Desktop Data Source

You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom visuals. Here is a simple example that shows how to connect to data sources over the Internet, cleanse, transform and enrich the data through the use analytical datasets returned by the R script, design the dashboard and finally share it.  Read more...
By Additional Articles 2016/02/15 | Source: SimpleTalk | Category: r language
Rating: (not yet rated)  Rate this |   Briefcase | 3,945 reads

Using the Statistical Program R for Running Statistics

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.  Read more...
By Tomaž Kaštrun 2016/01/29 (first published: 2014/03/10) | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 12,208 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 2015/12/07 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 7,872 reads

PowerShell Day-to-Day Admin Tasks: Monitoring Performance

By reading performance counters from services such as SQL Server or Exchange, you can get a wealth of performance information. By automating the process of gathering and storing appropriate counters, you can routinely check a range of devices quickly using visual tools such as PerfMon. By then creating your own counters, you can add counter-based metrics to anything that can be measured programmatically, such as services, applications, processes such as ETL, or deployments. Nicolas Prigent shows you how.  Read more...
By Additional Articles 2015/07/16 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 3,451 reads

Getting to know your customers better – cohort analysis and RFM segmentation in R

It often pays to use a tool like R, in conjunction with a relational database, to quickly perform a range of analyses, and graphs, in order to ensure that you're answering the right question, to explore alternative hypotheses, or to provide insight into a problem. Feodor demonstrates how to quickly, and interactively, explore the ways that customers purchase goods and services using cohort analysis.  Read more...
By Additional Articles 2015/07/06 | Source: SimpleTalk | Category: r language
Rating: (not yet rated)  Rate this |   Briefcase | 2,135 reads

Using R to Explore Data by Analysis - for SQL Professionals

What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with an interesting set of data, and some helpful suggestions that point out the parallels with SQL. Feodor provides the data and the helpful suggestions. The rest is up to you.  Read more...
By Additional Articles 2015/06/18 | Source: SimpleTalk | Category: r language
Rating: (not yet rated)  Rate this |   Briefcase | 4,836 reads

Making Data Analytics Simpler: SQL Server and R

R an SQL Server are a match made in heaven. You don't need anything special to get started beyond the basic instructions. Once you have jumped the hurdle of reliably and quickly transferring data between R and SQL Server you are ready to discover the power of a relational database when when combined with statistical computing and graphics.  Read more...
By Additional Articles 2015/05/11 | Source: SimpleTalk | Category: data analtyics
Rating: (not yet rated)  Rate this |   Briefcase | 8,980 reads

Using the Statistical Program R for Running Statistics

This article talks about using the statistical program, R, for applying simple statistics against data in Microsoft SQL Server.  Read more...
By Tomaž Kaštrun 2016/01/29 (first published: 2014/03/10) | Source: SQLServerCentral.com | Category: r language
Rating: |  Discuss |   Briefcase | 12,208 reads
   Items 1 to 10 of 10