Archive for the ‘Performance tip’ Category

APS Polybase for Hadoop and Windows Azure Blob Storage (WASB) Integration (2015-6-24)

Introduction The Microsoft Analytics Platform System (APS) comes with a very powerful feature that’s called Polybase. Polybase has been introduced over 2.5 years ago and extended ever since to integrate the world of structured and unstructured data, either on-premise as well in the Microsoft Azure cloud. The concept is simple: within an APS database you […]

Data Merge made easy with the APS Upsert (2015-6-17)

Comparing and merging datasets are typically time consuming operations when data volumes increase: the traditional approaches to either load data into a staging table and compare the content against its destination table or using an ETL tool to run the compare both have a downside: there is a lot of data movement going on. You […]

Better Tag Cloud