In this post, you’ll learn the queries you need to monitor table size. This information will help you understand if the table type and distribution are still suitable for your table (example: Replicated, Round-robin, Hash-distributed).
Azure Synapse Analytics Queries #6 Monitor Data Skew
In this post, you’ll learn how to monitor data skew in your Azure Synapse Analytics SQL Pool. Data skew is the uneven distribution of data.
Azure Synapse Analytics Queries #5 Product Version
Azure Synapse Analytics queries: How you can find the product version of your Azure Synapse Analytics Dedicated SQL Pool.
Azure Data Factory or Synapse Analytics SharePoint Lists
How to connect to your SharePoint lists from Azure Data Factory or Synapse Analytics. This post is intended for SharePoint online lists.
Azure Synapse Analytics Queries #4 Roles and Users
A quick guide to Azure Synapse Analytics roles and users. This query will help you list all the database roles and users in your ASA SQL Pool.
Azure Synapse Analytics Queries #3 Last Operations in Server
A quick guide to Azure Synapse Analytics queries about last operations in server. Learn how to get the latest transactions and progress.
Azure Synapse Analytics Queries #2 Replicated Tables
A quick start guide to Azure Synapse Analytics queries about replicated tables. They play a role in Azure Synapse Analytics SQL Pools
