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 [...]

23 11, 2017

Mastering R: Deploy R Scripts Using Microsoft Machine Learning Server

By | 2017-11-27T19:37:13+00:00 November 23rd, 2017|Advanced Analytics, Artificial Intelligence, Data Science, R|0 Comments

https://www.youtube.com/watch?v=P-R1grd_X9o&t=107s Microsoft Machine Learning Server (formally Microsoft R Server) is an enterprise class server for hosting and managing R and Python workloads. In this demonstration we focus on R workloads. The server provides an execution engine for solutions built using Microsoft R for statistical analysis and machine learning scenarios. The final step of [...]

15 11, 2017

SQL Server DevOps: Continuous Integration and Deployment with Redgate’s DLM Automation

By | 2017-11-15T19:16:33+00:00 November 15th, 2017|Application Lifecycle Management (ALM)|0 Comments

I recently wrote about how deploying changes to a SQL Server database has become much easier than ever before and highlighted the three primary methods of automating the deployment of databases, which are Redgate’s DLM Automation, Redgate’s ReadyRoll and Microsoft Visual Studio SQL Server Projects. In this installment, I will go in to detail [...]

6 09, 2017

Knowing Your Customers with Data & AI

By | 2017-09-06T08:31:47+00:00 September 6th, 2017|Application Lifecycle Management (ALM)|0 Comments

All businesses have customers. Do all businesses know their customers? How do businesses retain current customers and find new ones? Can businesses afford to chase customers with limited lifetime value to the company? The answers to these questions come easier with modern customer data analysis and predictive AI. Understanding your customers seemed simpler in the [...]

5 09, 2017

Using R Inside of Microsoft’s Power BI

By | 2017-09-05T13:42:14+00:00 September 5th, 2017|Advanced Analytics, Data Science, R, Reporting|0 Comments

Machine learning can enhance your reports so end users can gain deeper and more valuable insights from the data. While the value can be tremendous, implementing automated machine learning for reports can be challenging so many organizations choose to run scripts manually before importing the data into a reporting tool.  Power BI makes it easier [...]

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 [...]

9 08, 2017

Quick Artificial Intelligence, Summarized

By | 2017-08-09T09:04:49+00:00 August 9th, 2017|Artificial Intelligence|0 Comments

Each day I open my news app and I see the words “Artificial Intelligence”, or “AI”, pop up on my phone screen. There is often uncertainty by what people mean when they talk about artificial intelligence because it is a general term to describe the field of machine intelligence and perception. AI enables computers to [...]

26 07, 2017

VSTS Authentication: AAD or MSA?

By | 2017-07-26T10:23:59+00:00 July 26th, 2017|Visual Studio ALM, Visual Studio Team System|0 Comments

Visual Studio Team Service (VSTS) allows you to authenticate via two primary methods: Microsoft Account (MSA) – formerly Live ID Azure Active Directory (AAD) There are other authentication mechanisms such as SSH and Personal Access Tokens (PATs) but you need to first authenticate via AAD or MSA before you can use these other alternative mechanisms. [...]