User Profile

JovanPop

Microsoft

Joined 7 years ago

51 Posts158 Likes

View All Badges

User Widgets

Recent Discussions

No content to show

Recent Blog Articles

How to provide statement id in the serverless SQL pool support ticket?
Statement Id is the most essential information that you should provide when Synapse support team is handling the query issues that you are reporting. Here you will learn how to find the statement id ...
Jul 05, 2022 Place Azure Synapse Analytics Blog
6.5KViews
5likes
0Comments
Best practices for integrating serverless SQL pool with Cosmos DB Analytical store via Synapse Link
In this post you will find the tips and tricks that would help you to optimize performance of your serverless SQL pool that is reading data from the Cosmos DB analytical storage using the Synapse Lin...
Mar 16, 2022 Place Azure Synapse Analytics Blog
9.4KViews
5likes
0Comments
Optimize database schema in serverless SQL pools using QPI library
Query Performance Insight (QPI) is an open-source library that helps you to discover the potential issues in your database scheme and improvements that can help you improve performance or your querie...
Mar 09, 2022 Place Azure Synapse Analytics Blog
7.7KViews
11likes
0Comments
Implementing Spark posexplode() equivalent in the serverless SQL pool
The OPENJSON function in Synapse serverless SQL pools transforms a JSON array into the set of rows and can return a column that represents the index of every array element. This column can enable us ...
Mar 04, 2022 Place Azure Synapse Analytics Blog
5.1KViews
1like
1Comment
Loading CosmosDB and Dataverse data into dedicated SQL pool(DW) using the Synapse link
Synapse Link in the serverless SQL pools enables you to easily export data from CosmosDB or Dataverse and then you can load this dataset into the Synapse dedicated SQL pool (DW)
Feb 02, 2022 Place Azure Synapse Analytics Blog
7.3KViews
2likes
4Comments
The best practices for organizing Synapse workspaces and lakehouses
While designing the Lakehouse solution, you should carefully organize your databases and tables based on the underlying folder structure. In this article, you will find some best practices and recomm...
Nov 24, 2021 Place Azure Synapse Analytics Blog
38KViews
16likes
3Comments
Optimize the types of the columns to improve performance in serverless SQL pool databases
Minimization for column sizes is one of the most important schema optimizations in serverless SQL pools. In this article, you will learn why is type minimization important and what would be impacted....
Nov 19, 2021 Place Azure Synapse Analytics Blog
6.2KViews
2likes
1Comment
Improve performance of Parquet external tables using new native technology in dedicated SQL pools
The native external tables in the dedicated SQL pools in Azure Synapse analytics are the new technology that will boost performance of your queries that use the external tables on top of Parquet file...
Jun 03, 2021 Place Azure Synapse Analytics Blog
12KViews
7likes
3Comments
Query Delta Lake files using T-SQL language in Azure Synapse Analytics
Azure Synapse Analytics enables you to query Delta Lake files using T-SQL language in serverless SQL pools. You can use any tool that sends T-SQL queries to read Delta Lake content, load Delta Lake f...
May 27, 2021 Place Azure Synapse Analytics Blog
31KViews
6likes
7Comments
How to implement row-level security in serverless SQL pools
Row-level security enables you to configure your views to return different subsets of rows to the users with difference permissions. This way, the readers will get limited results based on their acce...
May 18, 2021 Place Azure Synapse Analytics Blog
32KViews
5likes
9Comments