Azure SQL Database
An Azure relational database service.
5,925 questions
1 answer
ElasticPoolSkuCombinationInvalid - How to find a valid database SKU for different elasticpool SKU's
I am getting a below error when trying to create a database with S3 for a elasticpool with StandardPool sku, I have tried different combination as per terraform document and azure document ended up with same error. Database Name: performing…
asked 2025-01-17T05:46:03.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 94%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
Gnanasoundari
45
Reputation points
edited an answer 2025-01-19T09:59:16.9166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
4,100
Reputation points Microsoft Vendor
2 answers
Microsoft Business Central 365 : Backup Database on cloud / azure service
Hello I have some request Detail I requested to backup database on cloud / azure Please may help guidance step exporting database into Please may help guide user permission which role can be export database into BACPAC file I try to do this…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 59%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
3 answers
@@ROWCOUNT issue
Hi there, I had the below code and it worked fine in counting the records inserted and logging insert counts. CREATE PROCEDURE ProcessCustomer AS BEGIN DECLARE @RowsInserted INT; -- Insert into the final table and capture row count …
asked 2025-01-11T05:26:26.6833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 69%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RJ
206
Reputation points
commented 2025-01-18T20:58:35.1066667+00:00
Erland Sommarskog
115.6K
Reputation points MVP
0 answers
Bugs in Azure Portal With PITR Restore of a CDC-Enabled Database Between SQL Managed Instances
When using the Azure Portal to the a Point In Time Restore (PITR) of a database on SQL Managed Instance: The restored database does not have the source database’s CDC Capture's Retention period in its [msdb].[dbo].[cdc_jobs] record (it contains the…
asked 2025-01-17T18:55:34.7333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 33%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sguidos
10
Reputation points
commented 2025-01-18T00:20:13.6166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
1,785
Reputation points Microsoft Vendor
1 answer
How to force Microsoft.EnterpriseLibrary.Data SqlDatabase to use the Microsoft.Data.SqlClient package
I am trying to access an azure database using a connection string provided that uses the Authentication keyword. The SqlDatabase in EnterpriseLibrary.Data uses the System.Data.SqlClient that does not work with my connection string. Is it possible to…
asked 2025-01-15T20:54:33.57+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 64%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEL%3C/text%3E%3C/svg%3E)
Evaristo Laron
0
Reputation points
commented 2025-01-17T23:45:32.9533333+00:00
Mahesh Kurva
1,785
Reputation points Microsoft Vendor
1 answer
Azure SQL database - Access to sys.sql_expression_dependencies for Server Admin user
I created an Azure SQL database with SQL Server admin and password. As per documentation the admin user should have access to 'all' objects in the database. However, Upon login to the database I am not able to access the system view :…
asked 2025-01-16T19:59:35.3633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 71%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
vivek
0
Reputation points
commented 2025-01-17T23:44:41.81+00:00
Mahesh Kurva
1,785
Reputation points Microsoft Vendor
0 answers
Bugs in Azure Portal With PITR Restore of a CDC-Enabled Database Between SQL Managed Instances
When using the Azure Portal to the a Point In Time Restore (PITR) of a database on SQL Managed Instance: The restored database does not have the source database’s CDC Capture Retention period in its [msdb].[dbo].[cdc_jobs] record The CDC Capture and…
asked 2025-01-17T18:58:19.05+00:00
sguidos
10
Reputation points
commented 2025-01-17T22:15:25.8533333+00:00
Erland Sommarskog
115.6K
Reputation points MVP
1 answer
Azure SQL Hyperscale pricing
Hi Team, i have upgraded my SQL DB from General Purpose Tier to Hyperscale but before migration it show pricing details low Bu when i done with migration it now showing very high pricing. Can someone pls help on it.
asked 2025-01-14T14:36:36.6833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 26%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
kuldeep Singh
0
Reputation points
commented 2025-01-17T19:36:35.4466667+00:00
Oury Ba-MSFT
20,006
Reputation points Microsoft Employee
1 answer
Azure SQL Database - on master - long execution of a query program TdService
On Azure SQL Database in Azure there is a really long query running (many days). The details: database_name master program_name TdService It looks like a bug from an Azure SQL Service. On diagnostics while trying to send a support ticket: The…
asked 2025-01-13T14:30:08.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 69%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RaTheMigthy
0
Reputation points
commented 2025-01-17T18:00:54.44+00:00
Mahesh Kurva
1,785
Reputation points Microsoft Vendor
2 answers
Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises SQL Server
Hi, Interestingly, I was able to create a linked server in the reverse direction—from the on-premises SQL Server to my Azure SQL MI—using a remote login and password for authentication. However, when I attempt to establish the link from Azure SQL MI to…
asked 2025-01-10T13:05:06.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
GP
16
Reputation points
edited a comment 2025-01-17T16:54:30.8266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
905
Reputation points Microsoft Vendor
1 answer
How can I locally develop my Spring Boot application against an Azure SQL DB using passwordless connections?
According to the documentation, the passwordless option is only for the hosted environment. This creates a challenge for developing locally because the authentication mechanism is different. How do I set up my local development so that it works the…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 97%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
1 answer
How to query Cosmos DB (analytical store) in Data Factory using SQL (Change Data Capture)
Hi, I am trying to write a query to interrogate Cosmos DB in Data Factory using the Change Data Capture functionality but I am unsure of the type of SQL I need to do this for a query that unrolls an array. It seems that the variant of SQL is different…
asked 2025-01-17T09:02:48.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 61%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Christopher Wilkinson
0
Reputation points
answered 2025-01-17T14:46:14.55+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sina Salam
15,396
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure SQL alternative
Hi, Currently, we are using Azure SQL Single database for a multi-tenant app. We are facing performance issue and keep scaling up to cope with the query volumes (and trying to optimize query with Query Performance Insight). If we don't want to…
asked 2022-09-26T02:58:23.717+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 52%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Testa
551
Reputation points
edited an answer 2025-01-17T13:59:43.27+00:00
Bobur Umurzokov
0
Reputation points MVP
1 answer
Is there a PowerShell statement that can Update a server with User Managed Identies?
Hi Is there a PowerShell statement that can Update a server with User Managed Identies? like this : az sql server update -g myResourceGroup -n myServer -i \ --user-assigned-identity-id…
asked 2025-01-16T12:03:59.64+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 63%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBD%3C/text%3E%3C/svg%3E)
Brian D H ZHANG
40
Reputation points
commented 2025-01-17T12:38:56.9433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 38%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Marcin Policht
31,705
Reputation points MVP
1 answer
My Azure Data factory copy activities are failing that grab the data from REST api and Azure storage from US WEST region, linked service connection failing. how to resolve this issue?
I am using ADF to get REST API data and move it to azure sql db and also moving data from blob storage to sql db. in both the cases pipeline status is Queue/ in Progress. linked service is failed to connect and timeout issue. please let me know how long…
asked 2025-01-15T22:50:44.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 37%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Swapna Nelanti
5
Reputation points
commented 2025-01-17T04:35:10.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Ganesh Gurram
3,110
Reputation points Microsoft Vendor
0 answers
Bug in Azure Portal When Deleting a CDC-Enabled Database From a SQL Managed Instance
If you delete a CDC-Enabled database on a SQL Managed Instance using the Azure Portal: The 'capture' and 'cleanup' jobs remain and can be seen the Job Activity Monitor The CDC Job records remain in the 'msdb.dbo.cdc_jobs ' table, with a [dbName] …
asked 2025-01-16T19:15:58.75+00:00
sguidos
10
Reputation points
edited a comment 2025-01-17T00:58:24.8266667+00:00
Mahesh Kurva
1,785
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How do I Group by [Server Name] using Registered Servers?
I am using Registered Server Groups and would like to do a query across the servers. Something like: Select [Server Name], Count(*) as People From ClientList Group by [Server Name] Order by [Server Name] But I receive an error "Invalid…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 25%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 64%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
1 answer
How can I setup an alert for error on Database Sync Group log?
Is there a way to send an alert when the logs of the database sync group have a type=error? Thanks. This seems to be more complicated that should be. e.g. https://azure.microsoft.com/es-es/blog/monitoring-azure-sql-data-sync-using-oms-log-analytics/
asked 2025-01-13T22:22:11.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 12%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESL%3C/text%3E%3C/svg%3E)
Sang Le
0
Reputation points
commented 2025-01-16T16:53:00.0366667+00:00
Oury Ba-MSFT
20,006
Reputation points Microsoft Employee
3 answers
Strip non numeric characters from string
Hi there, Happy New Year! I'm creating a new table (billions of records). I need to strip non numeric values from a column. Input '.I82807- R%' Output 82807 i created a function based on online however ITS SLOOOOOWWWWWW.... Wanted to check if…
asked 2025-01-03T17:20:48.4066667+00:00
RJ
206
Reputation points
commented 2025-01-16T07:42:29.8566667+00:00
LiHongMSFT-4306
29,906
Reputation points
2 answers
How to connect Azure SQL server database using managed identity in Powershell
Connecting to Azure SQL database in C# is working fine, but i need to connect Azure SQL server database using managed identity in PowerShell. I don't helpful commands to achieve this. Any help would be greatly appreciated.
asked 2025-01-15T23:32:40.1466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 14.000000000000002%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
lakshmipathi
0
Reputation points
answered 2025-01-16T04:53:35.3866667+00:00
Nandan Hegde
33,321
Reputation points MVP