Azure Synapse Analytics Serverless SQL Pools

The official documentation for Serverless SQL Pools is available from the following links:

Overview

• Azure Synapse Analytics

Quick Start

• Overview: What is Azure Synapse Analytics?
• Quickstarts: Creating a Synapse workspace (Azure Portal)
• Workspace: Quickstart: Create an Azure synapse workspace with Azure PowerShell
• Quickstarts: Analyze data with serverless SQL pool in Azure Synapse Analytics
• Synapse SQL: Quickstart: Use serverless SQL pool

Architecture & Development Practices

• Workspace: Azure Synapse Analytics shared database
• Synapse SQL: Serverless SQL pool in Azure Synapse Analytics
• Synapse SQL: Azure Synapse SQL architecture
• Synapse SQL: Transact-SQL features supported in Azure Synapse SQL
• Synapse SQL: Design decisions and coding techniques for Synapse SQL features in Azure Synapse Analytics
• Synapse SQL: Use T-SQL loops with Synapse SQL in Azure Synapse Analytics
• Synapse SQL: Stored procedures using Synapse SQL in Azure Synapse Analytics
• Synapse SQL: User-defined schemas within Synapse SQL

Tutorials

• Synapse SQL: Tutorial: Explore and Analyze data lakes with serverless SQL pool
• Synapse SQL: Tutorial: Use serverless SQL pool with Power BI Desktop & create a report

Reading Data From Storage

• Synapse SQL: Query storage files with serverless SQL pool in Azure Synapse Analytics
• Synapse SQL: Query CSV files
• Synapse SQL: Query Parquet files using serverless SQL pool in Azure Synapse Analytics
• Synapse SQL: Query JSON files using serverless SQL pool in Azure Synapse Analytics
• Synapse SQL: Query nested types in Parquet and JSON files by using serverless SQL pool in Azure Synapse Analytics
• Synapse SQL: Query folders and multiple files
• Synapse SQL: Use file metadata in serverless SQL pool queries
• Synapse SQL: Create and use views using serverless SQL pool in Azure Synapse Analytics
• Synapse SQL: Create and use external tables using serverless SQL pool in Azure Synapse Analytics
• Synapse SQL: How to use OPENROWSET using serverless SQL pool in Azure Synapse Analytics

Writing Data To Storage

• Synapse SQL: Store query results to storage using serverless SQL pool in Azure Synapse Analytics

Connectivity

• Synapse SQL: Connect to Synapse SQL
• Synapse SQL: Connect to Synapse SQL with Azure Data Studio
• Synapse SQL: Connect to Synapse SQL with SQL Server Management Studio (SSMS)
• Synapse SQL: Connect to serverless SQL pool with Power BI Professional
• Synapse SQL: Quickstart: Use Python to query a database

Best Practices

• Synapse SQL: Best practices for serverless SQL pool in Azure Synapse Analytics

Administration

• Workspace: Quickstart: Create an Azure Synapse workspace with the Azure Portal
• Workspace: Quickstart: Create an Azure synapse workspace with Azure PowerShell
• Synapse SQL: Cost management for serverless SQL pool in Azure Synapse Analytics
• Synapse SQL: Use Synapse Studio to monitor your SQL requests
• Synapse SQL: Statistics in serverless SQL pool
• Tech Community: Always use UTF-8 collations to read UTF-8 text in serverless SQL pool
• Reference: System views supported in Synapse SQL
• Workspace: Synapse Studio SQL scripts in Azure Synapse Analytics
• Workspace: Use Azure Monitor with your Azure Synapse Analytics workspace
• Workspace: How to set up access control for your Synapse workspace
• Workspace: Troubleshoot reading UTF-8 text from CSV or Parquet files using serverless SQL pool in Azure Synapse Analytics

Troubleshooting

• Workspace: Troubleshoot connectivity between Azure Synapse Analytics Synapse Studio and storage
• Resources: Self-help for Serverless SQL pool
• Overview: Microsoft Q&A Question Page
• Overview: Stack Overflow