Power BI Hybrid Tables with Synapse Analytics Serverless SQL Pools
Andy In this video we're talking a look at the new Power BI Hybrid Tables feature which combines Import, Incremental Refresh, and DirectQuery (real-time) modes in a single table. We look…
View Generation in Serverless SQL Pools
One of the objects that can be created within a Serverless SQL Pools database is a View. A View, along with an External Table, allows us to cast structure over…
Testing Error Handling in Serverless SQL Pools
A recent feature to be released for Serverless SQL Pools is error handling when processing external data (please see the November 2021 Synapse Analytics update). When querying external data, Serverless…
Data Toboggan Azure Synapse Analytics Event – Call For Speakers
Data Toboggan is a community-driven conference focused on Azure Synapse Analytics, Microsoft's flagship data warehousing, big data, and analytics service. The next event is running on Saturday 29th January, 2022…
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 Engine) Please click here to download the Polaris whitepaper to…
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 database. These objects can be shared between Spark and Serverless…
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 workloads. The centre contains a series of reference architectures which…
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) to control who can access this data in containers and…
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 and link these assets to a business glossary. An organisation…
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 are supported within Azure Synapse Analytics in both Dedicated SQL…