How to correct Columnstore index in dedicated SQL pool?
Two major factors affect the quality of a CCI: Step 1: Analyze a summary of your CCI health From the result, you can get an overview of the CCI health…
Memory Usage in Azure synapse dedicated SQL pool
Query to check which User consuming more memory Usage Azure synapse dedicated SQL pool using SSMS If want to exclude from users from list , Please use below Query: Mohammad…
How to do Performance tuning with ordered clustered columnstore index
When you ask a question to a column-based table in a dedicated SQL pool, the system looks at the smallest and largest values stored in each chunk of data. If…
How to start with Apache Spark pool in Azure Synapse Analytics?
Below Prerequisites required to start with Apache Spark pool: Steps: Sign in to the Azure portal Create a notebook create a simple Spark DataFrame object to manipulate. In this case,…
What is Apache Spark in Azure Synapse Analytics?
Describing Apache Spark in Simple words Imagine a team of super-efficient chefs working together in a huge kitchen to prepare a feast for thousands of guests. That’s Apache Spark in…
What is Azure Synapse Data Explorer?
Imagine you have a huge treasure chest overflowing with notes scribbled about past adventures. Each note tells a story, but the chest is messy, and finding specific stories takes forever.…