<img alt="" src="https://secure.hims1nice.com/151009.png" style="display:none;">
" style="background-color: #2c3e50;">
 

Blogs

API Data Integration with Azure Data Factory

Posted by KiZAN on Jan 31, 2023 12:52:10 PM
Read More

Topics: SQL Server, Azure, Data

Benefits of Enterprise Data Warehouse and Azure SQL Database

Posted by O'Meed Entezari on Nov 25, 2022 8:30:00 AM
Read More

Topics: SQL Server, Azure, Data

3 things you need to know about R Services for SQL Server 2016

Posted by Lucas Feiock on Jun 14, 2017 10:18:06 AM

 

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. 

 

Read More

Topics: SQL Server

Azure SQL Data Warehouse Introduction

Posted by Lucas Feiock on May 17, 2017 9:54:38 PM

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

Read More

Topics: SQL Server, Azure

Azure SQL Data Warehouse [Data Import Strategies]

Posted by Lucas Feiock on May 17, 2017 9:54:21 PM

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.

Read More

Topics: SQL Server, Azure

Analyzing Unstructured Data with PolyBase in SQL 2016

Posted by Lucas Feiock on Nov 2, 2016 10:10:42 AM
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.
Read More

Topics: SQL Server