Parquet

Chopping Off Data

An ETL issue with Excel causes issues, because the users didn't realize a limitation.

Incremental Data loading through ADF using Change Tracking

Learn how you can use Change Tracking to incrementally load data with Azure Data Factory

Access external data from Azure Synapse Analytics using Polybase

Learn how you can use Polybase technology in Azure Synapse to load data into your warehouse.

Provisioning ADF - Level 2 of the Stairway to Azure Data Factory

In this next level of the Stairway to Azure Data Factory, learn how to build your first ADF environment.

Data Transfer Strategies between MongoDB and SQL Server

There are a variety of days to move data between MongoDB and SQL Server. This article covers some of your options and gives you ideas on which method might work best for you.

Preventing Invalid Data Early In An ETL Flow

In this post, Tim Smith will look at some of the considerations for both data rules and logic to prevent invalid data early in the ETRL process.

3 Solutions For Auditing Long SQL Server Extracts or Loads

In this post, Tim Smith looks at the different options you can use to audit your SQL Server extracts and loads during the ETL process.

Bash for ETL pre-processing

People were doing ETL long before ETL packages were invented. Some of those facilities still have worth today

Simplify SQL Server ETL Processes with T-SQL Stored Procedures

Jeremy Kadlec introduces the Enhanced Data Integration Suite (EDIS), a SQL Server T-SQL stored procedure based solution to automate, manage, and audit ETL processes so you no longer have to manually build SSIS Packages.