Near-real-time analytics for transactional workloads
Part of the SQL Server 2022 blog series.
Traditionally, data to serve analytical systems have been extracted from operational data stores using custom-built extract, transform, and load (ETL) processes. These processes are often long-running, exert pressure on the source systems, and only run periodically in batch mode. While this kind of latency and overhead may be acceptable for some workloads, more and more companies are finding themselves in a place where they need to do analytics over operational data closer to real-timesomething that traditional ETL systems cannot support.
Enter Azure Synapse Link for SQL.
Azure Synapse Link for SQL provides an automated