Azure SQL Database
An Azure relational database service.
5,122 questions
asked 2024-04-25T11:06:08.61+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(115.19999999999999, 47%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ساره هانى فريد عبده بدوى
0
Reputation points
answered 2024-04-25T14:25:51.65+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, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERR%3C/text%3E%3C/svg%3E)
Rahul Randive
8,186
Reputation points Microsoft Employee
0 answers
Azure deployment error: The subscription <id> is not allowed to create or update the serverfarm.
Why do I receive the below error? I am first time using Azure "App Services" - "web app + database" Operation name: Update hosting plan Time stamp: Thu Apr 25 2024 14:17:51 GMT+0100 (British Summer Time) Error code: Forbidden …
asked 2024-04-25T14:15:17.52+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(22.400000000000002, 40%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Stephen Dooley
0
Reputation points
asked 2024-04-25T14:15:17.52+00:00
Stephen Dooley
0
Reputation points
0 answers
Unable to deploy SQL Server bicep template using AzureAD Authentication: true
Hi, I am deploying Azure SQL Server with administratorLoginPassword using Incremental mode but it is giving me error (AadOnlyAuthenticationIsEnabled). I need to use the password while deploying and I cannot ignore it. Also, while deploying the sql server…
asked 2024-04-25T13:19:32.6266667+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, 91%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Srikanth Vanam (PERSISTENT SYSTEMS LIMITED)
0
Reputation points Microsoft Vendor
asked 2024-04-25T13:19:32.6266667+00:00
Srikanth Vanam (PERSISTENT SYSTEMS LIMITED)
0
Reputation points Microsoft Vendor
0 answers
Create a data factory and pipeline using .NET SDK
Hello, this is my first post here and I hope to find a solution. I am working on a web portal (.NET) hosted in Azure Web Apps and need to create a Service Link for Azure SQL Database in Azure Data Factory when I perform specific actions. The problem is…
asked 2024-04-25T03:13:10.4833333+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, 72%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EET%3C/text%3E%3C/svg%3E)
Eddy Tegera
0
Reputation points
edited a comment 2024-04-25T10:23:54.05+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(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
5,730
Reputation points Microsoft Vendor
3 answers
One of the answers was accepted by the question author.
Migrate Azure SQL server instance to SQL managed instance
Dear forum, We're planning to migrate our DBs on a SQL server instance to a SQL managed instance. We're focussed on migration our dev/test instance first before doing production. The back-ups are done using the Azure Recovery Vault service. We would like…
asked 2024-04-18T13:26:25.6633333+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, 14.000000000000002%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
NIJSTEN Stephen
80
Reputation points
commented 2024-04-25T08:56:45.3833333+00:00
NIJSTEN Stephen
80
Reputation points
4 answers
One of the answers was accepted by the question author.
SSMS UI bug (all versions so far)
Hello there, There is an annoying bug in the SSMS UI that I thought will be found and fixed with the latest version (19.0.1) I just installed. It persists in all the previous versions I used and is available here too. Here is the description: Connect…
asked 2023-03-20T08:34:33.5233333+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(44.800000000000004, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Hristo Serafimov
35
Reputation points
commented 2024-04-25T06:48:34.87+00:00
Erland Sommarskog
100.9K
Reputation points MVP
2 answers
how to fix this issue Msg 64, Level 20, State 0, Line 114 A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
When I am trying to run two queries on same database but in different windows one query is doing deletion of a table from particular date ranges along with roll back mechanism and another query is doing fetching data by joining different tables based on…
asked 2024-04-24T08:07:29.2066667+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(9.6, 38%, 10%)' 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)
sharuk
0
Reputation points
commented 2024-04-25T06:32:54.17+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(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
2 answers
How do I Fix Login failed for user ''. for Mac apple silicon download azure SQL Server
've been trying to install azure sql for the past 3 weeks and eep getettign this error message. I deep dived the web for answers but none have suffice. Can you help, I'm trying to use sql for my class and business. I know it's telling em the username I…
asked 2024-04-23T19:26:01.33+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(192, 96%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
blouis
0
Reputation points
commented 2024-04-25T06:17:37.89+00:00
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
0 answers
Issue with connecting ADF to PostgreSQL
Hey, We are building our data factory on Azure and we are trying to connect a new dataset from PostgreSQL source. We took the CRT files and generated a PFX file from it, we import it into azure key vault. Then we went ahead and created the dataset, we…
asked 2024-04-24T06:20:25.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(131.20000000000002, 24%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Igal Cohen | CMTrading
0
Reputation points
commented 2024-04-25T04:59:38.9866667+00:00
phemanth
5,730
Reputation points Microsoft Vendor
0 answers
Backup State Failed with no log in Azure Managed Instance for Apache Cassandra
Backup State Failed with no logs in for a Cassandra Cluster in Azure Managed Instance for Apache CassandraPolicy is set to do the Backup at 14:00 with a retention of 4 hours. The only backup listed is marke as State "Failed" In Overview…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,122 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
934 questions
asked 2024-04-23T11:30:07.58+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(60.8, 45%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
alimagali
0
Reputation points
commented 2024-04-25T00:07:47.0433333+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
0 answers
Connecting Azure Data Factory to Azure SQL Managed Instance
I am trying to connect Azure Data Factory to Azure SQL Managed Instance, but I cannot get it to work. The MI is on a private endpoint, and the Data Factor is on a private endpoint. I created the Linked Service with a private endpoint: When I create…
asked 2024-04-22T22:31:35.87+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(128, 66%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Scott Klein
141
Reputation points
commented 2024-04-25T00:03:41.27+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
1 answer
ODBC Connection DSN and Linked Table Manager Giving Different Results
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
asked 2024-04-23T20:44:30.33+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(182.40000000000003, 50%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
EFSAdmin
0
Reputation points
commented 2024-04-24T23:38:22.52+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
0 answers
How to choose between Azure SQL Always On Availability Groups vs SQL Server Replication
Background: Our production SQL Server database is hosted on Azure VM. We have a nightly process to create a data warehouse environment that is used by our power users to query a day-old data and run reports. We would like to create a (or more in the…
asked 2024-04-24T15:24:17.36+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(182.40000000000003, 71%, 27%)' 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)
Somasekar Srinivasan
0
Reputation points
commented 2024-04-24T23:29:30.7666667+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
1 answer
How to translate database content with Azure Translator by ADF or Synapse notebook?
There is an Azure Database table. Some of columns need to be translated from one language to another into additional columns. Such as from English to Spanish, or Portuguese to English, etc. I am exploring how I can use ADF or Synapse notebook to…
![](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, 49%, 12%)' 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)
4 answers
Standalone/Serverless Azure DB - DBCC SHRINKDATABASE and DBCC SHRINKFILE throwing "Query execution timed out." after 300 seconds
I have a standalone DB and trying to use "Query Editor (Preview)" to shrink the DB or DB file. It has 500 GB max storage, 410 GB allocated, any only 152 GB used. I want to lower the allocated so that I can also lower the max. Every query…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,122 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
934 questions
![](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(112.00000000000001, 43%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
1 answer
Read Scaleout- Performance
Hi Team, We have enabled read scaleout on out Production work load We see that performance is not improved in the read only intent for select queries .What could be the cause
asked 2024-04-24T14:17:32.82+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(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nitya V
20
Reputation points
answered 2024-04-24T16:20:45.6633333+00:00
Alberto Morillo
32,886
Reputation points MVP
2 answers
How to view SQL Azure Business Critical Tier - Qurom, replics, etc.
We just scaled from General Purpose Tier to Business Critical in our main production Azure SQL Database (not Managed Instance). Everything is running fine, and I can connect to the read only replica successfully. Besides initiated a manual failover, I…
asked 2024-04-23T14:42:05.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(54.400000000000006, 42%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
John Allen
0
Reputation points
answered 2024-04-24T16:20:32.25+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
2 answers
[ADO NET Source [2]] Error: ADO NET Source has failed to acquire the connection {xxx} with the following error message: "Could not create a managed connection manager.".
I am attempting to connect to an Azure database. I am able to connect using SSMS. However when attempting to run at tasks in SSIS i get the above error The test connection returns successfully and I can see the preview of the data in the ADO NET Source…
asked 2024-04-23T14:52:57.1+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(38.4, 84%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Richardson, Matthew R. (SPO)
0
Reputation points
answered 2024-04-24T13:25:26.8533333+00:00
Alberto Morillo
32,886
Reputation points MVP
2 answers
Looking for guidance on integrating third-party data into our domain
Hi, My company's transactional system is MS Dynamics 365. We need to import various third-party data into our domain. I'm a Power BI developer but have been assigned this project. I'm looking for guidance on a suitable database and integration tool. …
![](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, 21%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How to ingest CDC data from SQL DATA SYNC to Event hub?
Hi we have a scenario to implement real-time CDC from SQL DATA SYNC to Azure SQL DB. Which tools are good for near real-time processes and prices as well. By using data bricks we can merge stream data into delta lake. But How to ingest real-time…
asked 2020-11-10T12:28:43.067+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, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETG%3C/text%3E%3C/svg%3E)
THIMMAIAH GARI,PRASHANTH,,
201
Reputation points
edited an answer 2024-04-24T06:51:50.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(195.2, 91%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Shane Blake
0
Reputation points