Author: Jami K

How to correct Columnstore index in dedicated SQL pool?

Two major factors affect the quality of a CCI: Compact rowgroups and metadata - The actual…

Memory Usage in Azure synapse dedicated SQL pool

Query to check which User consuming more memory Usage Azure synapse dedicated SQL pool using…

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…

How to start with Apache Spark pool in Azure Synapse Analytics?

Below Prerequisites required to start with Apache Spark pool: You'll need an Azure subscription. If…

What is Apache Spark in Azure Synapse Analytics?

Describing Apache Spark in Simple words Imagine a team of super-efficient chefs working together in…

What is Azure Synapse Data Explorer?

Imagine you have a huge treasure chest overflowing with notes scribbled about past adventures. Each…

How to loads data into a dedicated SQL pool in Azure Synapse Analytics

Prepare data in Azure Storage PolyBase can't load rows that have more than 1,000,000 bytes…

What all Design decisions and coding techniques for Synapse SQL features in Azure Synapse Analytics

You'll find a list of resources for dedicated SQL pool and serverless SQL pool functions…

How to Backup and restore in Azure Synapse Dedicated SQL pool?

How to use backup and restore in Azure Synapse Dedicated SQL pool. Use dedicated SQL…

External Tables with Azure Synapse serverless SQL pool

As a first step, you need to configure data source and specify file format of…

Data lakes with Synapse Serverless SQL pool

The OPENROWSET(BULK...) function allows you to access files in Azure Storage. For Example: SELECT TOP 100 *…

Columnstore indexes – In Details

What is a columnstore index? A columnstore index is a technology for storing, retrieving, and…

How to Create a dedicated SQL pool workload classifier using the Azure portal

We can create a workload classifier for assigning queries to a workload group. The classifier…

How to Start Azure Synapse SQL

Start with Serverless SQL pool Serverless query service that enables you to run SQL queries…

Difference between NONCLUSTERED COLUMNSTORE INDEX and CLUSTERED COLUMNSTORE INDEX in azure synapse sql

1. Columnstore Indexes: Purpose: Designed for high-performance analytics and data warehousing workloads. Storage: Store data in column-wise…

How to control Cost for serverless SQL pool in Azure Synapse Analytics

 You can set the budget in TB of data processed for a day, week, and…

Synapse SQL resource consumption in Dedicated/ Serverless SQL pool

For Serverless SQL pool Serverless SQL pool is a pay per query service that doesn't…

Azure Synapse SQL architecture

Synapse dedicate SQL pool and Serverless SQL pool architecture components Synapse SQL uses a scale-out…

Best Practice of Stored procedures using Synapse SQL in Azure Synapse Analytics?

Here are best practices for using stored procedures with Synapse SQL in Azure Synapse Analytics,…

External tables supported in Azure Synapse Analytics

An overview of the external table types supported in Azure Synapse Analytics Hadoop-Based External Tables:…