Welcome to everything Azure Synapse Analytics

Welcome to this data community-driven blog created by Andy Cutler covering all things Azure Synapse Analytics including Dedicated SQL Pools, Serverless SQL Pools, Pipelines, and Power BI . Click here to find out more…

LATEST BLOGS

KEEP UP TO DATE

LATEST UPDATES

Ignite 2021 Announcements: Accelerate time-to-insight with Azure Synapse Analytics https://techcommunity.microsoft.com/t5/azure-synapse-analytics/ignite-2021-announcements-accelerate-time-to-insight-with-azure/ba-p/2912147 #Azure #SynapseAnalytics

Costs and Estimated Savings using Azure Synapse Analytics Pre-Purchase Plans https://www.datahai.co.uk/administration/understanding-azure-synapse-analytics-pre-purchase-plans/

Check out the official Microsoft October 2021 update for Azure Synapse Analytics https://techcommunity.microsoft.com/t5/azure-synapse-analytics/azure-synapse-analytics-october-update/ba-p/2875372

Synapse Analytics Serverless SQL Pools Quick-start https://docs.microsoft.com/en-us/azure/synapse-analytics/quickstart-sql-on-demand

Stored Procedures are supported in Synapse Analytics Serverless SQL Pools https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-stored-procedures



FEATURED VIDEO


EVENTS

Microsoft Ignite (@MS_Ignite) | Twitter

WHAT ARE SERVERLESS SQL POOLS?

Serverless SQL Pools are part of the Azure Synapse Analytics cloud data warehousing and big data analytics service. The service enables querying file-based data (CSV, Parquet and JSON) stored in an Azure Storage & Data Lake Gen2 storage account and document-based data stored in Azure Cosmos DB by using familiar T-SQL. The service enables data roles such as Data Engineers and Data Analysts to query from storage and also to write data back to storage. The following are 3 common use-cases for Serverless SQL Pools.

Data Exploration

Analyse CSV, Parquet, & JSON data stored in Azure Storage using common T-SQL commands. Query Cosmos DB in real-time. Extract schema information to understand the structure of data.

Logical Data Warehouse

Create a relational structure over disparate raw data stored in Azure Storage, Cosmos DB, & the Dataverse without transforming and moving data. Data is available for immediate querying without further data loading.

Data Transformation

Data stored in Azure Storage and Cosmos DB can be transformed at scale using T-SQL and the resultant dataset returned to BI tools or loaded into a data store (SQL Database, Dedicated SQL Pools, Data Lake).


NEW TO SERVERLESS SQL POOLS?

Head over to the Getting Started blog post to work through how to set-up Azure Synapse Analytics and query data in an Azure Data Lake Gen2 account. The Learning section has links to self-paced training.

Microsoft provide official documentation here.


LOGICAL DATA WAREHOUSE SERIES


BLOG ARCHIVE