Azure SQL Database
An Azure relational database service.
5,425 questions
1 answer
How to create user in remote database using elastic query ?
I am trying to use elastic query to connect to remote database and create user there. I have used total three ways to create Database scope credentials: Using SQL users: CREATE DATABASE SCOPED CREDENTIAL ElasticDBQueryCred WITH…
asked 2024-07-23T19:08:45.07+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, 60%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Palash Mathur
0
Reputation points
answered 2024-07-23T19:43:03.6033333+00:00
Erland Sommarskog
106.8K
Reputation points
2 answers
||Execution fail against sql server. Please contact SQL Server team if you need further support. Sql error number: 121. Error Message: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The sem
Hi, We have azure data factory pipeline and got error message below couple of times over week-end. ADF pipeline calls azure sql database stored procedure which failed with the message - stored procedure just removes rows from table. Intermittent and…
asked 2024-07-22T14:30:09.2033333+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(57.599999999999994, 22%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPO%3C/text%3E%3C/svg%3E)
Philip O'Rourke
111
Reputation points
commented 2024-07-23T19:14:18.2933333+00:00
Erland Sommarskog
106.8K
Reputation points
1 answer
One of the answers was accepted by the question author.
How to figure out the total number of doses within a time span given to a client as dose are being added and stopped.?
If the cadence values are different, even if the dates overlap the records must be separate. If an order for the same dose and cadence value (including nulls) starts on the same day or the next day (+or-1 day) the record should continue. outlook of…
asked 2024-07-22T22:24:04.8633333+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, 2%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
andrew omofonma
41
Reputation points
accepted 2024-07-23T17:36:56.54+00:00
andrew omofonma
41
Reputation points
0 answers
Configuring Microsoft Entra Access for Specific User Groups to Azure SQL Database
Hello, I require assistance with configuring Microsoft Entra access for specific user groups to my Azure SQL Database setup. My current environment consists of the following: A primary Azure SQL server with a primary SQL database replica. A secondary…
asked 2024-07-23T16:27:18.4566667+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, 96%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZM%3C/text%3E%3C/svg%3E)
Zakhar Makarevich
0
Reputation points
asked 2024-07-23T16:27:18.4566667+00:00
Zakhar Makarevich
0
Reputation points
1 answer
Cannot create and start Extended Events session in Azure SQL Managed Instance
Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…
asked 2024-06-24T15:08:42.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(297.6, 60%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Aleksey Vitsko
20
Reputation points
commented 2024-07-23T16:18:19.89+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(73.60000000000001, 18%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Joby Mathew
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Connect to an Azure SQL server from Microsoft Fabric
I am trying to connect to an Azure SQL server using Dataflows on Fabric, however whenever I try connect i get the error "Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied since Deny…
asked 2024-07-23T11:07:09.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(115.19999999999999, 21%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mcmahon, Amy [GPSIE NON-J&J]
20
Reputation points
accepted 2024-07-23T12:28:34.2566667+00:00
Mcmahon, Amy [GPSIE NON-J&J]
20
Reputation points
1 answer
Snapshot in Azure data factory copy activity
I'm using copy activity in azdf from Azure SQL DB to CSV file. I saw an option to use snapshot but I don't see this option in Azure SQL DB. I have few question: Does it really using snapshot? Does it delete the snapshot after the copy? Can I see…
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,425 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.
1,079 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,160 questions
asked 2024-07-22T15:02:03.2933333+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(121.6, 81%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOM%3C/text%3E%3C/svg%3E)
OGINTZ Marina
85
Reputation points
commented 2024-07-23T12:07:40.6666667+00:00
Vinodh247
13,536
Reputation points
3 answers
One of the answers was accepted by the question author.
How can I complain on Meesho?
To can I com Open Customers can logon to, crat Website ,(24/7 available) +91-86.538-91.140 -+-for Cancelling their orders or Filling TDR.,Cancellation can ,be done online and the ,refund will be credited back 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(156.8, 28.999999999999996%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
0 answers
Failed to connect to Azure SQL server from android due to TLS version mismatch using jtds connection
Also tried added ssl=require in connection string it returned error as "Network error IOException: SSL handshake aborted..." if I added sslProtocol=TLSv1.1 since in Azure server it set as 1.0, but it return message as "Reason:Login…
![](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(102.4, 92%, 19%)' 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)
0 answers
managed instance link between 2 managed instances
Hello, We have databases running on Azure SQL Managed Instance. We would like to move this database instance to another resource group without any interruption. We are considering using the managed instance link for this purpose. My question is: Does the…
asked 2024-07-22T12:17:17.8533333+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, 53%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFK%3C/text%3E%3C/svg%3E)
Fatih Korhan
0
Reputation points
commented 2024-07-23T06:18:01.15+00:00
Fatih Korhan
0
Reputation points
2 answers
Copy Database - Performance
Hello, We need to create a new copy of a database on a different server using the PowerShell command "New-AzSqlDatabaseCopy". Will running this command impact the performance of the live database, especially if other jobs or queries are…
asked 2024-07-17T06:49:52.86+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(140.8, 39%, 23%)' 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)
Rohit
226
Reputation points
commented 2024-07-23T06:08:40.7966667+00:00
MikeyQiaoMSFT-0444
1,910
Reputation points
1 answer
ADF Copy Activity - Emply col issue
Hi Team, I have a pipeline where I am copying the data from the file to a database. The file had one extra empty column in between, and my copy activity failed with the below error: Message: Invalid Excel header with empty value It failed because the…
0 answers
Customer Best Practices Assessment: exclude checks/false positives
Is there any way to customize the BPA in Azure ARC for SQL to exclude certain checks or to flag issues as false positives? I've got certain issues being flagged by the BPA however these can't be resolved as the application accessing the database requires…
asked 2024-07-19T09:42:13.16+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(243.2, 0%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Berend Broekhoff
0
Reputation points Microsoft Employee
commented 2024-07-23T04:53:15.8633333+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
14,386
Reputation points Microsoft Employee
3 answers
How to access database by External Datasource using Service Principal Name(SPN)
I am seeking a solution for cross-database access via an external data source using Service Principal credentials. Specifically, I want to perform Transact-SQL queries from one database to another using Service Principal credentials. To achieve this, I…
asked 2024-07-21T14:42:53.0533333+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(67.2, 65%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Devendra Parmar
0
Reputation points
answered 2024-07-23T02:56:04.5966667+00:00
Nandan Hegde
31,436
Reputation points MVP
1 answer
Is cross functional queries in azure sql database doesn't support SPN(Service principal) ?
I want to confirm if cross functional queries in azure sql database doesn't support SPN(Service principal) ? If no then how can I resolve An error occurred while establishing connection to remote data source: [Microsoft][ODBC Driver 17 for SQL…
asked 2024-07-22T14:38:39.2233333+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(275.2, 61%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ayush Shrivastava
0
Reputation points
commented 2024-07-23T02:52:16.8733333+00:00
Nandan Hegde
31,436
Reputation points MVP
1 answer
Getting error after recreating cosmos db - System.IO.InvalidDataException: Could not find the start of the json array in the stream: | Old databases are working fine only getting this error while reading data from new cosmos dbs
Getting error after recreating cosmos db - error > System.IO.InvalidDataException: Could not find the start of the json array in the stream: | Old databases are working fine only getting this error while reading data from new cosmos dbs
Azure SQL Database
Azure SQL Database
An Azure relational database service.
5,425 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,637 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,539 questions
asked 2024-07-22T12:57:54.32+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(275.2, 94%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mayur Malekar
0
Reputation points
edited the question 2024-07-23T01:45:26.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(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT
29,436
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
Disaster Recovery setup/High Availbility
Hello again. I need to some help deciding on how to setup a DR solution. We have following things setup in DEV and UAT env: One subscription where DEV and UAT env reside using separate Vnet and subnets. Use Vnet Peering to connect both VPN gateway…
asked 2024-07-20T05:33:12.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(137.6, 88%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
Xhevahir Mehalla
160
Reputation points
answered 2024-07-22T18:07:44.9933333+00:00
Xhevahir Mehalla
160
Reputation points
2 answers
Column truncate issue - Copy file to DB ADF pipeline
Hi All, I have a pipeline where I am copying data from a file to a database. In the file, I have a few columns with extra spaces that I need to trim or truncate. I am not getting any option to use any transformation or function (dynamic content) on the…
asked 2024-07-19T17:52:29.9766667+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(96, 24%, 19%)' 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)
ADF_Coder
0
Reputation points
edited a comment 2024-07-22T17:57:17.9466667+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(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
320
Reputation points Microsoft Vendor
1 answer
discovered SQL Server databases on an Azure VM but have not enabled the backup incur costs ?
If you have discovered all SQL Server databases on an Azure VM using Azure Backup but have not enabled the backup, you generally won't incur costs for the actual backup storage and operations. Costs typically begin once you enable backup and start…
asked 2024-07-22T09:59:14.7066667+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(92.8, 22%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYS%3C/text%3E%3C/svg%3E)
Yasar Shaikh
0
Reputation points
answered 2024-07-22T14:28:19.93+00:00
SadiqhAhmed-MSFT
41,381
Reputation points Microsoft Employee
3 answers
Using Azure OpenAI / Copilot Application Outside of Portal to Answer Natural Language Questions with SQL Queries
I have been experimenting with Copilot on my Azure SQL databases, and I love the functionality of querying a database through plaintext and getting the results. I'm interested in making this available to non-technical users outside of the Azure portal.…
asked 2024-07-19T19:10:49.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(32, 55.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
hampton123
1,160
Reputation points
commented 2024-07-22T14:09:32.4533333+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(214.4, 74%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AshokPeddakotla-MSFT
30,321
Reputation points