Azure SQL Database
An Azure relational database service.
5,120 questions
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-25T00:14:52.4366667+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
3 answers
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
60
Reputation points
commented 2024-04-25T00:09:27.43+00:00
Oury Ba-MSFT
16,081
Reputation points Microsoft Employee
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,120 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.
938 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,120 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.
938 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
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:26:26.33+00:00
Somasekar Srinivasan
0
Reputation points
asked 2024-04-24T15:26:26.33+00:00
Somasekar Srinivasan
0
Reputation points
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
1 answer
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
answered 2024-04-24T13:17:47.2733333+00:00
Amira Bedhiafi
15,216
Reputation points
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)
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
edited a comment 2024-04-24T06:57:58.5133333+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
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
0 answers
I cannot see any tables when Connecting the Azure via MS Access Linked Table Manager, what am I missing?
I have installed AdventureWorksLT as well as my own tables in a new Azure database that I am trying to connect to via "Linked Table Manager" in MS Access but all I see are the sys tables. If I use DoCmd.TransferDatabase acLink it works fine…
asked 2024-04-22T17:41:46.8033333+00:00
EFSAdmin
0
Reputation points
edited the question 2024-04-24T03:55:58.3566667+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
1 answer
Azure SQL Server Always on AG with multi-sibnets
We are planning to set-up always on AG in azure which SQL server 2016 on WS2016. As perdocumentation, we want to avoid load balancer and go with multi-subnet. The question here is, does the 2 azure VM's/nodes must be in different zones in a region ? We…
asked 2024-04-22T04:09:32.97+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(268.8, 77%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVY%3C/text%3E%3C/svg%3E)
Venkata Yeleswarapu
0
Reputation points
commented 2024-04-24T03:53:46.3866667+00:00
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
2 answers
Deployment of a simple bicep takes too long
I have a bunch of biceps that deploy various parts of Azure infrastructure. All of them complete within reasonable timeframes except this guy. It runs forever, though, in fact, approves the private managed connection as supposed. Any thoughts? param…
asked 2024-02-08T01:54:19.4+00:00
Dronec
166
Reputation points
commented 2024-04-24T03:52:39.0466667+00:00
ShaktiSingh-MSFT
13,271
Reputation points Microsoft Employee
2 answers
How to connect to existing SQL Server in Azure Data Studio 3?
When I attempt to connect to my institution's SQL Server I get this message "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 35 - An internal…
asked 2024-03-26T15:51:01.0133333+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(83.2, 2%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENA%3C/text%3E%3C/svg%3E)
Nuako, A
0
Reputation points
answered 2024-04-24T00:51:49.43+00:00
Erin Stellato
476
Reputation points Microsoft Employee