Data Science in SQL Server

A new feature in SQL Server 2016 that Microsoft added to further help us with predictive analytics is R Services (In-database). This new feature supports enterprise-scale data science. R Services (In-database) helps you embrace the highly popular open-source R language in your business. R is the most popular programming language for advanced analytics and offers an incredibly rich set of packages and a large developer community.

When analyzing large datasets with R, data scientists often run into performance and scale issues, because the common runtime implementation is single-threaded and can accommodate only those data sets that fit into the available memory on the local computer. To get better performance and work with more data, the data scientist can use the ScaleR APIs that are provided as part of R Services (In-Database). The ScaleR packages support in-database execution, for multi-threaded, multi-core, multi-process computation.