Blogs

 

Getting Started with R Services for SQL Server 2016

SQL Server 2016 is enterprise ready for transaction processing, data warehousing, and business intelligence.

As part of SQL Server 2016, R Services expands the scope of these existing data technologies to include advanced analytics in enterprise workflows allowing for the building of intelligent, predictive applications by leveraging the R language and in-database analytics. 

 

Azure SQL Data Warehouse is a fully managed, elastic data warehouse-as-a-service for processing enterprise workloads.

The process of loading data into a traditional data warehouse typically follows the pattern of Extracting, Transforming, and Loading (ETL). Most businesses use a dedicated server to perform these operations.

However, with MPP architecture and the ability to load data fast, the new standard is becoming Extract, Load, and Transform or ELT.

PolyBase is a Microsoft technology that can query Hadoop clusters or Azure Blob Storage. This is achieved by using T-SQL statements to import and export data between relational and non-relational data sources. While PolyBase is similar to Hive's HiveQL, Teradata's SQL-H, Apache Drill, Apache Sqoop, or Cloudera Impala it is different. With PolyBase, SQL Server Developers can use existing skills to query Hadoop. The need for SQL Server Developers to learn Hadoop or Linux is not required.