In this video Chris Seferlis gives an overview of Azure Synapse Link, a newer feature of the Synapse Analytics Suite of tools.

Find out why this feature is important, the way it moves Operational Data to Analytical Data, and what you can then do with it.

More details about the service and some great tutorials can be found here:

Chris Seferlis introduce us to the newly added Apache Spark Pools in Azure Synapse Analytics for Big Data, Machine Learning, and Data Processing needs.

From the description:

I give an overview of what Spark is, and where it came from; why the Synapse Team added it to the suite of offering, and some sample workloads why you might use it.In this video I introduce the newly added Apache Spark Pools in Azure Synapse Analytics for Big Data, Machine Learning, and Data Processing needs. I give an overview of what Spark is, and where it came from; why the Synapse Team added it to the suite of offering, and some sample workloads why you might use it.

Azure Synapse Analytics is Azure SQL Data Warehouse evolved: a limitless analytics service that brings together enterprise data warehousing and Big Data analytics into a single service. It gives you the freedom to query data on your terms, using either serverless on-demand or provisioned resources, at scale.

Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate business intelligence and machine learning needs.

In this presentation, learn about the new products and features that make up Azure Synapse Analytics and how it fits in a modern data warehouse, as well as provide demonstrations.

James Serra is a big data and data warehousing solution architect at Microsoft. He is a thought leader in the use and application of Big Data and advanced analytics. Previously, James was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker. He is the author of the book “Reporting with Microsoft SQL Server 2012”.

In this video Chris Seferlis gives a quick demonstration of connecting an external data source to my Synapse environment and the differences in performance between connecting as an external table or querying directly off of blob storage.

Then he goes into the difference in external table and how that differs from copying the data right into Synapse or using a CTAS statement.