Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Nick Burns profile

   Items 1 to 6 of 6   

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: | Category: visual analytics
Rating: |  Discuss |   Briefcase | 1,909 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: | Category: r language
Rating: |  Discuss |   Briefcase | 1,961 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: | Category: revolutionr
Rating: |  Discuss |   Briefcase | 3,561 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: | Category: revolutionr
Rating: |  Discuss |   Briefcase | 6,082 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: | Category: performance
Rating: |  Discuss |   Briefcase | 7,930 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: | Category: replication
Rating: |  Discuss |   Briefcase | 3,063 reads
   Items 1 to 6 of 6