Microsoft announced the general release of SQL Server 2019 at Microsoft Ignite. This is the answer to the demands exerted by massive data and expectations of real-time query performance across a variety of data sources. A data platform for modern enterprises and modern expectations.
Microsoft has taken its data-warehouse solution to the next level in both performance and capabilities. And has now launched Azure SQL Data Warehouse as Azure Synapse Analytics. With Azure Synapse, you can build, manage, collaborate and analyse your data all within the same service.
This article by Microsoft MVP Arun Sirpal discusses Azure Data Factory. With this tool, you have access to a fully managed serverless cloud data integration tool that scales on-demand. This is done by building pipelines – these data-driven workflows usually perform the following steps shown below.