Global software house Microsoft is making big data the focus of SQL Server 2019, set for release later this year. A key part is data virtualisation, eliminating complex ETL processes.

Microsoft first truly disrupted the ETL marketplace with the introduction of SQL Server Integration Services (SSIS) back with the release of SQL Server 2005. Microsoft has upped the ante yet again by ...

Azure Synapse Link for SQL: Previously, moving data from on-premises databases, like SQL Server, to Synapse required using extract, transform, and load (ETL). Configuring and running an ETL pipeline ...

sql-data-warehouse-project Building a modern datawarehouse with SQL Server, including ETL processes, data modeling and analysis.

Latency and batch processing: ETL processes typically use batch processing. This introduces latency and is not ideal for scenarios that require near-instant data updates.

What are the main differences between ETL and ELT? Use our guide to compare ETL and ELT, including their processes, benefits and drawbacks.