Azure SQL Database
An Azure relational database service.
5,412 questions
1 answer
How to use Always Encrypted feature with temp table
Hi,We are using Always Encryption in our Azure SQL hosted database(PaaS) and when we are using temp table in an stored procedure which is being used to store and Join with encrypted table's column for UPDATE/INSERT operation, getting error : 'Msg 33293…
asked 2024-07-09T08:03:52.1333333+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(259.20000000000005, 85%, 35%)' 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)
Surapally Sravan Kumar
0
Reputation points
commented 2024-07-18T08:19:34.68+00:00
Surapally Sravan Kumar
0
Reputation points
1 answer
Change the 'remote query timeout' value to zero for one of our Azure SQL Database
We are required to change the 'remote query timeout' value to zero for one of our Azure SQL Database but not able to find any way to implement this change. For example, we can do it in SQL VM instance by using sp_configure system procedure but this…
asked 2024-07-17T21:49:31.9566667+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
9,176
Reputation points Microsoft Employee
answered 2024-07-17T22:03:20.4433333+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
1 answer
Optimize Azure SQL Database Performance
Do we need to run update statistics after running rebuild index in Azure PaaS servers. We are currently running Rebuild index through runbook automation. Also need to know if we can get email notification on failure of Automation Runbook. PS - Based on…
asked 2024-07-17T21:48:32.93+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
answered 2024-07-17T21:58:43.9366667+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
1 answer
Does the read-only replica have its own query optimizer separate from the primary?
How are the execution plans for the queries that run on the read-only replica created? Does the primary create the execution plans for both primary and read-only replicate or does the read-only replica have the ability to create the execution plan…
asked 2024-07-17T21:46:34.9266667+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
edited an answer 2024-07-17T21:56:11.0433333+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
1 answer
Facing an issue with enabling managed identity between a virtual machine (VM) and a Platform as a Service (PAAS) SQL server
I am facing an issue with enabling managed identity between a virtual machine (VM) and a Platform as a Service (PAAS) SQL server to authenticate to a SQL database without using a username and password. The troubleshooting steps taken so far include…
asked 2024-07-17T21:45:19.91+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
answered 2024-07-17T21:52:56.19+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
1 answer
Azure SQL DB Export operations running for long time and timed out
We are experiencing an issue with an export operation getting stuck at 47% for 2 days, and the operation timed out after 48 hours PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the…
asked 2024-07-17T21:41:59.8766667+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
answered 2024-07-17T21:43:03.8766667+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
1 answer
Azure Web Application Connectivity Issue with Disabled Public Endpoint
After creating a private endpoint in US East, the Azure Web Application is working and connecting to the Azure SQL DB server (in other region). However, it is unable to access the data when the public endpoint is disabled PS - Based on common issues that…
asked 2024-07-17T21:40:16.49+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
answered 2024-07-17T21:41:44.52+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
1 answer
SQL DB export to Storage Account with Private link is failing
I am trying to export the database to storage account which has following feature Tool or method used to export - Using Portal Attempting to backup/export db to Storage Account in same RG. Azure SQL DB is using Private Link Storage Account does not…
asked 2024-07-17T21:35:37.4366667+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
answered 2024-07-17T21:37:03.52+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
1 answer
Earlier Point-in-Time Restore (PITR) Not Visible for Azure SQL Database in the Portal
Earlier Point in Time restore (PITR) is not visible for Azure SQL Database in the portal We needed an earlier restore point than the ones shown as available on this database. Unfortunately, we don't see restore points earlier than 20 of June, which is…
asked 2024-07-17T21:33:58.22+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
answered 2024-07-17T21:34:52.7566667+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
1 answer
Scenarios for SQL Admin to Update Admin or User Password and Resolving Server Admin Password. Getting update Error
In what scenarios can a SQL Admin update the admin or user password? Getting below error when updating Server admin password Error- Cannot alter the login '<>>', because it does not exist or you do not have permission.Msg 15151, Level 16, State…
asked 2024-07-17T21:30:03.9533333+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
answered 2024-07-17T21:32:31.5666667+00:00
Rahul Randive
9,176
Reputation points Microsoft Employee
1 answer
Enabling user authentication to connect Access front end to Azure SQL Database
I need to connect/link the tables in Access to an Azure SQL database using ODBC Driver 18 for SQL Server. I am trying to use New Data Source->From Database->From Azure Database to authenticate with either Azure AD Password or Interactive…
asked 2024-07-12T16:24:59.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(198.4, 31%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGD%3C/text%3E%3C/svg%3E)
George Dimitrov
0
Reputation points
commented 2024-07-17T19:08:46.5666667+00:00
George Dimitrov
0
Reputation points
2 answers
How to "restore" AdventureWorks .bak into Azure SQL Database
I'm trying to get the AdventureWorks dataset into a new Azure SQL Server Database, using the instructions here : https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms When I connect to the…
asked 2024-07-15T17:16:06.2433333+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, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAE%3C/text%3E%3C/svg%3E)
Amy Elmer
0
Reputation points
commented 2024-07-17T18:23:16.7566667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
Azure MySql Database to power apps
Dear Azure Expert, I am new in Azure , I want to create table directly to Azure MySQL without using MySQL work bench, is it necessary? btw Im using powerapps I really want to migrate all my data from SP list to Azure, is there other way? Recommended…
asked 2024-07-16T12:30:06.8966667+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, 43%, 17%)' 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)
Mon-Mon
0
Reputation points
commented 2024-07-17T18:20:34.63+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
Unable to purchase support plan
Hello, I am trying to purchase a support plan with Azure. I am unable to because I receive this message when choosing to purchase Developer support. This is preventing me from filing a support ticket for another issues I am having with a Azure…
asked 2020-09-17T10:34:06.737+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(147.20000000000002, 0%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jamie Gross
16
Reputation points
commented 2024-07-17T12:39:11.0266667+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, 63%, 18%)' 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)
AV
30
Reputation points
0 answers
Not able to connect from my Local Visual Studio 2022 to Azure SQL Server
Azure provided this connection string for ADO.NET: Server=tcp:jeanjhskyblue.database.windows.net,1433;Initial Catalog=MEDISEABLUE;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;Authentication="Active Directory Default"; when…
asked 2024-07-16T21:18:06.4166667+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(64, 75%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Jihan Haidar
0
Reputation points
edited the question 2024-07-17T03:15:31.63+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,351
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Need help to restore sql backup
I’m trying to restore my db and i read if it’s before 7 days we can get but! It’s been more than 7 days can anyone help me to get that back’
![](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(51.2, 21%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIS%3C/text%3E%3C/svg%3E)
1 answer
SQL Database export
How to export and download exported database?
asked 2024-06-21T12:47:40.7866667+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(208, 54%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
Tukenov, Almaz [Tengizchevroil]
0
Reputation points
commented 2024-07-16T23:25:50.9666667+00:00
GeethaThatipatri-MSFT
29,012
Reputation points Microsoft Employee
1 answer
Alerts in Managed instance
Hi I am looking at setting up alerts on the managed instance based of https://learn.microsoft.com/en-us/sql/ssms/agent/create-an-alert-using-an-error-number?view=sql-server-ver16 where it states it applies to MI However I encounter error. I need to…
asked 2024-06-04T17:09:30.0833333+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
40
Reputation points
commented 2024-07-16T20:05:38.8066667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
Creating Certifcate Or Symmetric key Over Azure Managed Instance with Entra Service principal
Hi Team, We are connecting a database over Azure SQL Managed Instance from our C# application. We need to create Symmetric-Key/Asymmetric-Key/Certificate with TSQL statement.
asked 2024-06-28T14:13:48.8733333+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(307.2, 13%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
Deepak Rane (drane)
60
Reputation points
commented 2024-07-16T20:02:53.8866667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Trying TDE CMK with Azure key vault
CREATE ASYMMETRIC KEY EKMSampleASYKey FROM PROVIDER [AzureKeyVault_EKM] WITH PROVIDER_KEY_NAME = 'keyname', CREATION_DISPOSITION = OPEN_EXISTING; throwing the below error Key with name 'keyname' does not exist in the provider or access is denied.…
asked 2024-07-16T07:52:10.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(76.8, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIM%3C/text%3E%3C/svg%3E)
Ijaz Muhammad
81
Reputation points
commented 2024-07-16T18:27:02.3933333+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee