Close this search box.

What is R in SQL Server aka Machine Learning in SQL Server 2017

I was very excited when I read R in SQL Server, unlike others I was also very much interested to know What is R in SQL Server aka Machine Learning in SQL Server 2o17.

What is Machine Learning?

Machine Learning is basically a technology where computers study and analyze the statistical data to find and recognize any pattern or trend from the data and the  to help predict. Because of this it can provide a great insight about existing data and help decision making. Here is where you can read more about Machine Learning.

Let us quickly understand what is R and what it is used for?

R is an open source language that is used to analyze the statistical data provided to it. This is the simple one line to know what R does actually. R language is packed with lots of programmability features like loop, functions and other things we normally do while we code.

What is R in SQL Server aka Machine Learning in SQL Server 2017

R in SQL Server is integrated closely so that we can minimize the costs and security risk while performing data analysis. R can be installed with SQL Server setup (both Server and client for R), it can be installed In-Database or Standalone.

Here are some links to get started with R in SQL Server aka Machine Learning in SQL Server 2017.

Getting Started with SQL Server Machine Learning

SQL Server R Tutorials

Some common use case for Machine Learning (ML)

  • Financial Services – Uses ML to prevent fraud and getting insight of data to create more opportunity
  • Health Care Industry – Uses ML to find patterns and identify possibility of treatment needed
  • Government – Uses ML to study existing data and then work with more efficiently
  • Marketing and Sales – Uses ML to find trends and recommends next item to purchase i.e. Google Ads or Amazon or Flipkart


Happy machine learning my friends.

Leave a Reply

Your email address will not be published. Required fields are marked *

Picture of Hemantgiri Goswami

Hemantgiri Goswami

Throughout my extensive 24-year tenure in the IT industry, I have honed my expertise in SQL Server and cloud technologies. My qualifications include certifications in ITIL, Azure, and Google Cloud, and my professional journey boasts a consistent record of delivering top-notch, dependable, and efficient solutions across diverse clients and domains. In recognition of my dedication and impact, I am honored to have received the Microsoft MVP award for SQL Server on six occasions. Additionally, I actively contribute to various online forums and blogs, acting as a moderator and facilitator of meaningful discussions. My ultimate mission revolves around empowering organizations to enhance the reliability and efficiency of their SQL Server implementations while fostering a culture of continuous learning and growth within the SQL Server community.