4 12, 2017

SQL Server 2016 Machine Learning Services: A Work Around for Single Value Outputs of the Raw data type in R

By | 2017-12-04T17:46:18+00:00 December 4th, 2017|Advanced Analytics, Data Science, SQL Server|0 Comments

SQL server 2016 (and 2017) enables SQL developers to write in database analytics in the form of stored procedures. The ideal flow of events is described in the below visual. Please note that the stored procedures in the visual insert results directly into the tables.   The key step that I would like to [...]

16 08, 2017

Parallel Computing in R

By | 2017-08-16T14:51:12+00:00 August 16th, 2017|Advanced Analytics, Data Science, Microsoft R Server|0 Comments

Historically R has been a single threaded programming language, however, with Microsoft R many basic operations have been optimized to run in parallel for larger datasets. Additionally, Microsoft R enables developers to easily write parallel solutions using the RevoScaleR package. Please note that the code below is written and executed on my desktop, therefore, execution time [...]

25 07, 2017

Azure Storage R Package

By | 2017-07-25T09:13:34+00:00 July 25th, 2017|Advanced Analytics, Data Science, Microsoft R Server, R, SQL Server|0 Comments

A week ago, I came across a blog suggesting that R developers write their own personal R package to eliminate the need to copy and paste common functions into different scripts and workspaces. A personal R package would allow the developer to simply load the library and start developing using the functions they already use every [...]

15 05, 2017

Deploying Your First Web Service with Microsoft R Server

By | 2017-05-15T17:25:10+00:00 May 15th, 2017|Advanced Analytics, Data Science, Microsoft R Server|0 Comments

Incorporating advanced analytics in software allows developers to build intelligent applications tailored to the individual user. The easiest way to include machine learning in an application is by calling an API that returns a prediction. Using a standalone Microsoft R Server, organizations can write custom machine learning solutions that are hosted as web service APIs, [...]

3 05, 2017

Advanced Analytics with Microsoft R Server and SQL Server Machine Learning Services

By | 2017-05-03T08:45:27+00:00 May 3rd, 2017|Advanced Analytics, Data Science, Microsoft R Server, SQL Server|0 Comments

At Northwest Cadence, we believe that every organization should leverage machine learning in their software, reporting, and business workflows. We help companies learn about the various technologies available, and assist in implementing custom advanced analytics solutions. Incorporating predictive analytics within software or real-time dashboards can enable a company to revolutionize their business by providing a [...]

9 11, 2016

Machine Learning for the Rest of Us

By | 2016-11-09T15:10:16+00:00 November 9th, 2016|Azure, Azure Machine Learning (AML), Data Science, Reporting, SQL Server|1 Comment

Machine learning. Everyone is talking about it, but most have no idea what it is or why it is needed. Machine learning may seem like magic, but if one does not know where to start they can quickly get lost. All organizations have a need for predictive analytics because it allows for quicker and better decision [...]

9 11, 2016

Machine Learning in SQL Server 2016

By | 2016-11-09T11:32:27+00:00 November 9th, 2016|Advanced Analytics, Data Science, Microsoft R Server, SQL Server|0 Comments

As a competitive business, turning existing data into actionable insights is a top priority. Microsoft SQL Server 2016 makes deploying machine learning solutions easier than ever before by enabling consumers to manipulate, transform, and make predictions on their data using custom R scripts. In this video, we show a simple restaurant recommendation engine illuminating the basics [...]

25 10, 2016

SQL Server 2016 Top 10 Reasons to Upgrade

By | 2016-10-25T11:24:41+00:00 October 25th, 2016|Application Lifecycle Management (ALM), Data Science, Database Lifecycle Management, SQL Server|0 Comments

SQL Server 2016 is the most advanced and feature-packed release of SQL Server ever. From SQL Server 2005 through SQL Server 2014, there have been some very nice improvements and the product keeps getting better every release. However, SQL Server 2016 doesn’t just bring a new game, it brings a whole new playing field. Here are [...]

4 03, 2016

Advanced Analytics Q&A from the Microsoft Transformation IT Roadshow

By | 2016-03-04T11:59:16+00:00 March 4th, 2016|Database Lifecycle Management, SQL Server, Tools|0 Comments

I recently was on the partner panel for some of the Microsoft Transformation IT Roadshows where I was honored to speak on Advanced Analytics. For those of you who attended I had mentioned I would capture some of the Q&A and post it on our blog for your convenience. For those unable to attend, I wanted [...]