User Profile

JovanPop

Microsoft

Joined 6 years ago

51 Posts158 Likes

View All Badges

User Widgets

Recent Discussions

No content to show

Groups

Recent Blog Articles

Reaching Azure disk storage limit on General Purpose Azure SQL Database Managed Instance
First published on MSDN on Aug 20, 2018 Azure SQL Database Managed Instance General Purpose is SQL Server implementation on Azure cloud that keeps all database files on Azure storage.
Oct 07, 2024 Place Azure SQL Blog
0likes
1Comment
Re: Generate create/drop external table scripts on Synapse SQL using PowerShell DbaTools
make sure that you put -ondemand inmysynapsesqlserverlessendpoint-ondemand.database.windows.net. If this doesn't work, try to connect to synapse using the SSMS from the same computer where you are...
Sep 01, 2023 Place Azure Synapse Analytics Blog
0likes
0Comments
Troubleshooting BULK INSERT and OPENROWSET issues on Azure SQL Database
This article provides guidance that can help you to troubleshoot potential BULK INSERT and OPENROWSET issues in Azure SQL while loading the files from Azure Blob Storage
Aug 03, 2022 Place Azure SQL Blog
0likes
4Comments
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
5likes
0Comments
Re: Generate create/drop external table scripts on Synapse SQL using PowerShell DbaTools
Hikboos421this looks like a generic error where you cannot even login. Please double-check credentials or try with some other sql credential. DbaTools uses the same auth technique as any .Net app/t...
Mar 31, 2022 Place Azure Synapse Analytics Blog
0likes
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 21, 2022 Place Azure Synapse Analytics Blog
5likes
0Comments
Re: Advanced analytics of COVID data using Synapse SQL endpoint in Azure Synapse Analytics service
Are you sure that you are executing the query on serverless and not on dedicated pool? OPENROWSET is available only in serverless pool. There is nothing special with this syntax. try also other exa...
Mar 15, 2022 Place Azure Synapse Analytics Blog
0likes
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
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
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
2likes
4Comments