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

Guest Columnist: Nick Burns

SQLServerCentral.com profile

   Items 1 to 10 of 10   
 

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 | 578 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 | 533 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 | 677 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 | 897 reads

Using R to Identify Key Features Quickly

Typical BI dashboards display data summaries like counts and averages. We use R to extend on these to identify key associations in a dataset.  Read more...
By Nick Burns 2017/01/09 | Source: SQLServerCentral.com | Category: visual analytics
Rating: |  Discuss |   Briefcase | 2,210 reads

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,996 reads

Configuring R Services in SQL Server 2016

R Services provides in-database analytics in SQL Server 2016. In this article we step through configuring R Services and get you started with in-database analytics.  Read more...
By Nick Burns 2016/01/27 | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 3,618 reads

Analysing Sales Patterns: R + SQL Server

We show how to use RevolutionR to analyse & visualise purchasing behaviours in AdventureWorksDW2012.  Read more...
By Nick Burns 2015/12/15 | Source: SQLServerCentral.com | Category: revolutionr
Rating: |  Discuss |   Briefcase | 6,168 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,021 reads

Adding an Article Without a Full Snapshot

Have you got transactional replication in your SQL environment? Do you need to add a new table to your publication, but can't afford the time necessary to create a full new snapshot? Here is a step-by-step guide. Thankfully, adding a single table is easier than I thought.  Read more...
By Nick Burns 2015/01/05 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 3,111 reads
   Items 1 to 10 of 10