Azure Synapse Analytics

Documentation

Homepage

Overview

Overview

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. 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 BI and machine learning needs

Getting Started

Getting Started

  1. 11/5/2019, Video, 0:45:00
    Join us to learn about Azure Synapse Analytics, a limitless analytics service, that brings together enterprise data warehousing and Big Data analytics. It gives you the...
  2. 11/5/2019, Video, 0:45:00
    Azure Synapse Analytics is the home for enterprise data warehouses in Azure. Whether you’re migrating from an existing legacy appliance or developing a new solution in the...
  3. 11/5/2019, Video, 1:15:00
    Building an analytics pipeline was a complicated and disjointed process, involving data, technologies, and people working all in silos. But now with Azure Synapse Analytics,...

Learning

Learning Paths

Implement a Data Warehouse with Azure Synapse Analytics
Published: 1/31/2019, Length: 2:53:00
Azure Synapse Analytics provides a relational big data store that can scale to Petabytes of data. In this learning path, you will learn how Azure Synapse Analytics can achieve this scale with its’ Massively Parallel Processing (MPP) architecture. Create a data warehouse in minutes and use familiar querying language to build reports. Load massive amounts of data in minutes, and ensure that...
Azure Fundamentals part 2: Describe core Azure services
Published: 9/14/2020, Length: 3:12:00
This learning path provides you with an introduction to the basics of Azure's core services for compute, network, storage, and database.
Architect a data platform in Azure
Published: 10/22/2019, Length: 8:05:00
Learn how to architect a data platform in Azure and build solutions to store relational and NoSQL data.

Learning Modules

Import data into Azure Synapse Analytics by using PolyBase
Published: 1/31/2019, Length: 1:06:00
Design a data warehouse with Azure Synapse Analytics
Published: 1/31/2019, Length: 0:47:00
Query data in Azure Synapse Analytics
Published: 1/31/2019, Length: 1:00:00
Explore Azure database and analytics services
Published: 9/14/2020, Length: 0:39:00
Design a Modern Data Warehouse using Azure Synapse Analytics
Published: 11/11/2020, Length: 0:56:00

Azure Synapse Analytics News

12/2/2020, James Serra's Blog
I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that you can attend virtually: Azure Synapse Analytics: A Data Lakehouse 12/5/20, 1:10pm EST, PASS SQL Saturday...
11/25/2020, MS Tech Community
We continue to expand the Azure Marketplace ecosystem. For this volume, 81 new offers successfully met the onboarding criteria and went live. See details of the new offers...
11/23/2020, MS Tech Community
We continue to expand the Azure Marketplace ecosystem. For this volume, 83 new offers successfully met the onboarding criteria and went live. See details of the new offers...
11/16/2020, MS Tech Community
What is covered in this blog post? Recently I went through a Cost Optimization exercise of evaluating Azure Synapse Reserved instance pricing with my customer and this blog post documents the...
11/16/2020, MS Tech Community
We continue to expand the Azure Marketplace ecosystem. For this volume, 97 new offers successfully met the onboarding criteria and went live. See details of the new offers...
11/10/2020, MS Tech Community
This is a guest post by Nikhil Gupta, Partner Solutions Architect, Databricks   As customers start to move towards the lakehouse paradigm one of the necessary requirements is to have data stored...
11/3/2020, James Serra's Blog
A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between using an external table versus a T-SQL...
10/30/2020, MS Tech Community
Overview SQL Server Migration Assistant (SSMA) Access, DB2, MySQL, Oracle, and SAP ASE (formerly SAP Sybase ASE) allows users to convert a database schema to a Microsoft SQL Server schema, deploy...
10/30/2020, MS Tech Community
Azure Synapse Analytics SQL Pools have what is called the Dynamic Management Views(DMVs) that provide insights into the internals of Azure Synapse SQL Pools. This helps to better understand the...
10/22/2020, James Serra's Blog
I have listed below the top questions I see from customers about Azure Synapse Analytics and Power BI, and the blogs that I have written that try to answer each question. I have also added these...
10/22/2020, Microsoft Azure Blog
To further accelerate time to insight in Azure Synapse Analytics, we are introducing the Knowledge center to simplify access to pre-loaded sample data and to streamline the getting started...
10/22/2020, MS Tech Community
In Azure Synapse Analytics, data will be distributed across several distributions based on the distribution type (Hash, Round Robin, and Replicated). So, on an operation like Join condition we...
10/15/2020, Microsoft Azure Blog
To enable companies to gain real-time insights on the critical data in their Oracle E-Business Suite, we are announcing a new offer with Incorta that brings Azure Synapse Analytics, Power BI, and...
9/30/2020, Service Updates
Azure Data Factory (ADF) is adding new connector support to enable Optimized Row Columnar (ORC) format to data flows in ADF and Synapse Analytics in ADLS and Blob Store.
9/30/2020, Service Updates
Azure Data Factory (ADF) is adding new connector support to SQL MI as a source and sink to data flows in ADF and Synapse Analytics in ADLS and Blob Store.
9/30/2020, Service Updates
This new Spark CDM connector requires zero configuration and is pre-installed with Azure Synapse Analytics. It can also be installed and used with Azure Databricks.
9/23/2020, Service Updates
The COPY command can now automatically parse your files to calculate file splits and can evenly distribute data chunks across the Synapse SQL compute nodes for parallel ingestion.
9/23/2020, James Serra's Blog
There are some options in Azure Synapse Analytics that are not obvious that I wanted to point out. While in Azure Synapse Studio, going to the Data hub and clicking the “+” at the top to the...
9/22/2020, Service Updates
With a brand new output connector to Synapse SQL Pools, Stream Analytics can now support throughput rates even higher than 200MB/sec while ensuring ultra-low latencies.
9/22/2020, Service Updates
These new preview features extend existing functionality, remove user limitations, and provide customers with greater ease of use when setting up Azure SQL Database or Azure SQL Managed Instance.