- PASS Data Community Summit Companion Resources
PASS Data Community Summit 2021 Slides Please click here for a PDF copy of the slides. Polaris (Serverless SQL Pools… - Creating a Lake Database using the Database Designer
Synapse Analytics allows the creation of External Tables and Views within a Serverless SQL Pools database and also a Spark… - Azure Synapse Analytics in the Azure Architecture Centre
Microsoft provide an Azure Architecture Centre which contains resources to understand which Azure services are appropriate in certain scenarios and… - Using Access Control Lists To Manage Fine-Grain Data Lake Permissions
When data is stored in Azure Data Lake Gen2, we can use Azure Active Directory and Access Control Lists (ACLs)… - Integrating Azure Purview with Synapse Analytics Serverless SQL Pools
Azure Purview is a Microsoft Data Governance service which enables an organisation to map their data infrastructure including data lineage… - Using Temporary Tables within Serverless SQL Pools
Temporary (temp) tables have been a feature of Microsoft SQL Server (and other database systems) for many years. Temp tables… - External Tables vs Views…Which to Use and Why?
Serverless SQL Pools do not contain data (unlike Dedicated SQL Pools) but rather allow you to cast structure over data… - Azure Storage Folder Filtering using the Filepath Function
Serverless SQL Pools includes 2 SQL functions, filepath and filename, that can be used to return the folder path/name and… - 10 Billion Rows: Parquet File Size and Distribution When using CETAS
When using Serverless SQL Pools to write data to Azure Storage/Data Lake Gen2 using the CREATE EXTERNAL TABLE AS SELECT… - Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 4 of 4 – Connecting Power BI to the Dimensional Model
Welcome to Part 4 in the Creating a Logical Data Warehouse with Synapse Serverless SQL Pools series. We are now… - Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 3 of 4 – Incremental Fact Loading and Slowly Changing Dimensions
Welcome to part 3 of the Logical Data Warehouse with Serverless SQL Pools series. In this part we’ll be covering… - Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 2 of 4 – Creating a Dimensional Model
Welcome to part 2 of this 4 part blog series on creating a Logical Data Warehouse with Azure Synapse Analytics… - Creating a Logical Data Warehouse with Synapse Serverless SQL: Part 1 of 4 – Setting Up and Querying Source Data
Welcome to part one of a four part blog series where we’ll be looking at one of the main scenarios… - Azure Synapse Analytics Serverless SQL Pools Learning Resources
Welcome to this collection of links to resources focussed on Azure Synapse Analytics Serverless SQL Pools. It includes official Microsoft… - Azure Synapse Analytics Serverless SQL Best Practices
Microsoft have a best practices document available here which highlights certain actions that can be taken to optimise use of… - Getting Started with Azure Synapse Analytics SQL Serverless
The new Azure Synapse Analytics SQL Serverless service enables querying file-based data stored in an Azure Data Lake Gen2 storage… - Harnessing Azure Synapse Analytics SQL Serverless in Power BI Dataflows
Power BI Dataflows are a Power BI Service component that allow the creation of centralised, cleansed, transformed and certified tabular…
Azure Synapse Analytics