Azure SQL Database
An Azure relational database service.
5,290 questions
0 answers
How to convert string to datetime in copy activity
I have delimited text files and I am trying to copy that into my sql db. I have some date columns and it is empty in certain cases, so my copy activity is throwing the following error, how to fix this ErrorCode=TypeConversionFailure,Exception occurred…
asked 2024-06-19T02:17:44.7233333+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, 57.00000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHR%3C/text%3E%3C/svg%3E)
Hermoine Ron
0
Reputation points
asked 2024-06-19T02:17:44.7233333+00:00
Hermoine Ron
0
Reputation points
0 answers
How to give an AAD group view only access to a single database within SQL Server with multiple databases
I have a SQL Server in my subscription with multiple databases. Each database corresponds to a client organization. I wanted to give each client read only access to their individual database without them being able to see the other databases. For a…
asked 2024-06-19T01:44:05.8133333+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(0, 57.99999999999999%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Abdul Asim
0
Reputation points
asked 2024-06-19T01:44:05.8133333+00:00
Abdul Asim
0
Reputation points
1 answer
authenticating to azure sql db using entra credentials Login failed for token-identified-principal
The goal is a WPF app that allows external users in an Entra external tenant to authenticate to an Azure SQL DB. I am following https://learn.microsoft.com/en-us/entra/external-id/customers/sample-desktop-wpf-dotnet-sign-in carefully, and can use it…
asked 2024-06-17T21:55:50.7133333+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(300.8, 14.000000000000002%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
greg schlitt
0
Reputation points
edited a comment 2024-06-18T23:33:01.38+00:00
greg schlitt
0
Reputation points
0 answers
Does Encryption columns (Deterministic/Randomized) support Merge SQL statement inside stored Procedure? If not, how to replace merge SQL statement with other code?
There are 2- encrypted (Deterministic & Randomized) tables And I am loading data into Table1 via SSIS package. And after that, I am using Stored Procedure to merge data from table1 to table2 based on matches - INSERT, UPDTAE OR DELETE.
asked 2024-06-18T08:31:32.7833333+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(163.2, 22%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Khwaza Bandenawaz Sikkalagar
0
Reputation points
asked 2024-06-18T08:31:32.7833333+00:00
Khwaza Bandenawaz Sikkalagar
0
Reputation points
0 answers
Deadlock queries resolve, how do identify the query causing deadlock if deadlocks are resolved?
Trying to identify deadlocks in a db, we receive alerts during the day are not able to pin down which query is causing the issue. We've run a deadlock analysis but no records get returned. How can we see the history of deadlocks that have occurred along…
asked 2024-06-17T17:14:30.29+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, 69%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Kirby, Cameron R
0
Reputation points
commented 2024-06-18T06:19:37.7633333+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,186
Reputation points Microsoft Employee
1 answer
WIll increasing Azure SQL Database from 2 TB to 3 TB cause any downtime or risk of the related services?
Hello, I have a 2 TB Azure SQL Database - General Purpose, Provisioned, Standard-Series (Gen5), 8 vcores. I will need to resize it to 12 vCores and 3 TB. Is this process anyhow risky for my other related services? I have found the similar…
asked 2024-06-13T08:02:12.83+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, 20%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E14%3C/text%3E%3C/svg%3E)
11-4688
81
Reputation points
commented 2024-06-18T04:13:41.2366667+00:00
ShaktiSingh-MSFT
14,186
Reputation points Microsoft Employee
2 answers
Estimating Total Cost for Power BI Service with Azure Storage and SQL Database
Hi, I'm planning to use Power BI Service, and I understand that it is built on Azure, utilizing Azure Blob Storage for data uploads and Azure SQL Database for metadata storage. Could you help me estimate the total cost for these Azure services in…
asked 2024-06-14T06:21:40.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(169.60000000000002, 90%, 26%)' 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)
Sham
0
Reputation points
edited the question 2024-06-18T03:58:36.9766667+00:00
PRADEEPCHEEKATLA-MSFT
82,356
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
App service randomly fails to cannot to sql azure database
Hi all, I am using Azure App Service to host .NET 6 web application and Azure SQL Database, both located in the same region. However, I am randomly encountering an error as below in the application users from accessing certain…
asked 2024-06-17T14:40:34.34+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(144, 28.000000000000004%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVV%3C/text%3E%3C/svg%3E)
Van Vo Hai
60
Reputation points
accepted 2024-06-18T01:33:38.6433333+00:00
Van Vo Hai
60
Reputation points
2 answers
Pricing of Azure Web Service with Azure SQL
Hi Team I am New to using Azure App Service and Azure SQL Database, I have created a Web App which will use SQL database would I like to host in Azure App service using Azure SQL database as database. It is like E-commerce website where 100 of people…
asked 2024-06-16T14:18:37.7233333+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(48, 56.00000000000001%, 14%)' 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)
Manimegalai Periysamay
0
Reputation points
answered 2024-06-17T19:44:30.4933333+00:00
GeethaThatipatri-MSFT
28,537
Reputation points Microsoft Employee
0 answers
Avoiding metric inflation during data processing in Dedicated SQL Pool (formerly SQL DW)
Hi all , Here is the scenario for which I am seeking suggestions: Whenever our data jobs run to refresh dimensions and facts, and a Tableau extract refresh occurs simultaneously, the extracts report inflated metrics. When we validate, the metrics on 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(156.8, 74%, 25%)' 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)
1 answer
One of the answers was accepted by the question author.
Subir una base de datos SQL Server a la nube y que sea accesible a través de ODBC
Hola a todos, Mi duda es la siguiente: ¿Existe la posibilidad de subir una base de datos de SQL Server a la nube y que ésta sea accesible a un programa que tengo en diferentes empresas? Actualmente este programa utiliza esa base de datos localmente en…
asked 2024-06-14T11:24:42.12+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, 21%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EX%3C/text%3E%3C/svg%3E)
Xavier
20
Reputation points
commented 2024-06-17T16:06:06.02+00:00
Alberto Morillo
33,251
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Best Practices for Securing services in the Azure ecosystem : Tools for Access Logging and Monitoring?
Good morning, Our organization utilises Azure for hosting web services, SQL Server instances, and SQL Server on virtual machines to re-design our current data warehouse structure. Ensuring robust data security protection across these environments is…
asked 2024-06-14T08:40:26.91+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(156.8, 18%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECA%3C/text%3E%3C/svg%3E)
Cristopher Aguilera
71
Reputation points
accepted 2024-06-17T07:49:52.3466667+00:00
Cristopher Aguilera
71
Reputation points
1 answer
One of the answers was accepted by the question author.
Data Lake as a storage/database for Express Angular Application?
So currently I'm using SQL server for our structured data, client uploads a file which has a minimum of a million of records, which gets uploaded to blob storage and then those million of records gets inserted into different tables in SQL. What I want to…
asked 2024-06-12T18:28:04.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(275.2, 46%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
Jayesh Nathani
40
Reputation points
accepted 2024-06-17T07:09:35.5+00:00
Jayesh Nathani
40
Reputation points
1 answer
Linked Server - how to set up in Azure Managed Instance
Hi Team How do we configure linked server to On Prem SQL in Azure Managed Instance. What the pre-requisites on the network side of things Thanks
asked 2024-06-17T05:11:23.1533333+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
answered 2024-06-17T06:57:25.86+00:00
Nandan Hegde
29,996
Reputation points MVP
4 answers
How to migrate SQL database to Azure ? What is the standard way?
What is the exact procedure to migrate on-prem SQL databases to azure?
asked 2024-06-12T14:14:07.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(236.8, 86%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
Divya wairkar
0
Reputation points
commented 2024-06-17T05:55:36.9966667+00:00
LucyChenMSFT-4874
2,400
Reputation points
1 answer
Azure SQL server: How to tell if the client is inside or outside Azure
Hi, I came across this documentation about Connection Policy to Azure SQL servers https://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql#connection-policy . There are 3 different methods: Redirect, Proxy,…
asked 2024-06-13T11:46:56.71+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(224.00000000000003, 24%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDL%3C/text%3E%3C/svg%3E)
Duc Le Trung
0
Reputation points
commented 2024-06-17T03:57:33.4633333+00:00
ShaktiSingh-MSFT
14,186
Reputation points Microsoft Employee
2 answers
The type initializer for 'Microsoft.Data.SqlClient.SqlAuthenticationProviderManager' threw an exception.
Getting error while connecting db with .net core Application
asked 2024-06-12T10:32:54.79+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(6.4, 86%, 10%)' 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)
Sagar Lugade
0
Reputation points
answered 2024-06-17T03:36:53.0633333+00:00
ShaktiSingh-MSFT
14,186
Reputation points Microsoft Employee
3 answers
One of the answers was accepted by the question author.
Azure SQL Database and Azure SQL Managed Instance
can anyone explain me the dff btween the "Azure SQL Database" and "Azure SQL Managed Instance"? Are they the same, or am I missing someything.
asked 2024-02-01T19:04:09.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(12.8, 47%, 11%)' 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)
dwaine
20
Reputation points
answered 2024-06-15T14:03:31.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(60.8, 69%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Nguyen Minh Tri
0
Reputation points
1 answer
Local SSIS Package Issues with MFA on Managed Instance
We have a SQL Managed Instance that we are testing with. I'm attempting to create local packages in SSIS and have them run against the Managed Instance data. When I manually run the SSIS package, I get an MFA validation. It works. However, when I try to…
asked 2024-06-13T14:00:26.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(156.8, 69%, 25%)' 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)
HSB
45
Reputation points
answered 2024-06-14T22:40:26.5066667+00:00
Oury Ba-MSFT
17,141
Reputation points Microsoft Employee
2 answers
Sql server Metrics : is 100% CPU percentage is a blocker for all DB operations?
HI All We have observed a case in our database where the CPU perncetage is 100% for quite some time but my application are still able to hit & operate over DB, is 100% CPU usage isnt a blocker for DB operations ?? I see 2 CPU metrics 1) CPU…
asked 2024-05-27T01:27:28.3866667+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, 91%, 23%)' 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)
Manoj Mathe
0
Reputation points Microsoft Employee
commented 2024-06-14T16:35:20.4633333+00:00
Oury Ba-MSFT
17,141
Reputation points Microsoft Employee