Azure SQL Database
An Azure relational database service.
5,412 questions
1 answer
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
commented 2024-07-19T19:33:14.5+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, 9%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kumar Sing
0
Reputation points
0 answers
my virtual machine cannot ping public IPs
Hello guys, I need help from everyone, my issue is with the public IP addresses that I cannot ping in my virtual machine. So if anyone can help me with this. I specified that the public IP address of my firewall is what works on my virtual machine but…
asked 2024-07-19T19:30:10.0233333+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, 79%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
amadou diallo
0
Reputation points
asked 2024-07-19T19:30:10.0233333+00:00
amadou diallo
0
Reputation points
0 answers
# of users for Azure Account
How can I revise the number of total licenses that I am subscribed to? Thanks
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,065 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(249.60000000000002, 28.999999999999996%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFC%3C/text%3E%3C/svg%3E)
1 answer
Intemittent Login failed for user '<token-identified principal>'.","details":"SqlException: Login failed for user '<token-identified principal>
Hello. We've an API running on Azure App Service that uses user assigned managed identity to authenticate against an Azure SQL DB. The app works most of the time, no problem with authentication, however, we get an intermittent authentication issue like…
asked 2024-07-19T07:35:14.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(128, 6%, 22%)' 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)
mustafa altunok
0
Reputation points
answered 2024-07-19T19:28:34.64+00:00
Amira Bedhiafi
19,626
Reputation points
1 answer
Risky Users table does not apply filters
Has anyone had issues with applying filters to their Microsoft Entra ID Risky Users table? We recently lost the ability to add a filter to identify anyone with a specific risk state ie remediated, At Risk, Dismissed OR Risk Level, Low, Medium, High or no…
asked 2024-07-15T20:49:40.5466667+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, 35%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Bates, Kevin
0
Reputation points
answered 2024-07-19T19:27:40.6866667+00:00
Andy David - MVP
145.1K
Reputation points MVP
6 answers
Dynamic Folder Names with AjaxFileUpload
I'm attempting to replace the upload /download pages of our very old ASP classic web site with a web forms app. Keeping as much of the back end stuff the same is important as there is code (mostly VBA in Word, Excel and Outlook) in our daily operation…
![](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(25.6, 57.99999999999999%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
1 answer
How to add custom 3d Models like a car or truck instead of pins in Azure Map Line layer
Hi I want to show a route followed by a shipment truck, currently I am showing a green marker for the current location and the blue pins are the previous reported location of the truck. How can I show a 3d model of a truck instead od the green marker on…
asked 2024-07-19T11:49:33.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(224.00000000000003, 98%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Satyam Chauhan
542
Reputation points
edited an answer 2024-07-19T19:21:58.86+00:00
rbrundritt
16,461
Reputation points Microsoft Employee
3 answers
Blazor Server Application - Integrated SAML2
Good Day Everyone at our company we have a SSO provider which is in SAML2, we have integrated this on ASP.NET Webforms and ASP.NET MVC 5 projects, but we haven't tried to integrate it on Blazor Server Application as we are starting to develop our first…
asked 2021-06-03T08:11:19.55+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, 7.000000000000001%, 18%)' 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)
hydeinthesky
11
Reputation points
commented 2024-07-19T19:20:49.0933333+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(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
61,181
Reputation points
1 answer
One of the answers was accepted by the question author.
project plan for Azure migration
Hi All I need a detailed project plan for Azure migration My Business Requirement: Lift and Shift Migration through Az Migrate from VMware / Hyper-V via DevOps/IaC. and Automation using DevOps Pipeline. help me with some ARM or PS scripts…
asked 2022-08-09T18:33:26.197+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, 62%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERN%3C/text%3E%3C/svg%3E)
Rath, Niranjan (Cognizant)
26
Reputation points
commented 2024-07-19T19:20:44.4066667+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, 21%, 21%)' 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)
Ion Ciubuc
0
Reputation points
2 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
answered 2024-07-19T19:18:29.6966667+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, 67%, 18%)' 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)
hbjytdrsedfc
0
Reputation points
0 answers
Retiring of the WindowsAzure.ServiceBus nuget package by 30 September 2026 (Azure WCF Relay)
We frequently use the "Azure WCF Relay" service and "WindowsAzure.ServiceBus" nuget package in our .NET Framework projects. It seems that we may not be able to easily port our projects to .NET (v6/v8) in the near future. We received a…
asked 2024-07-17T16:04:05.9133333+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, 71%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETI%3C/text%3E%3C/svg%3E)
Timuçin DURSUN
0
Reputation points
edited a comment 2024-07-19T19:15:55.0633333+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, 59%, 10%)' 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)
JananiRamesh-MSFT
23,566
Reputation points
0 answers
Error code: 80192EE7
Hi, I dont have any option to add work or school account while setting up windows 10 Lenovo T430 laptop. So I login with personal Microsoft account. I am going to settings and trying to switch to M365 domain but it doesnt allow me. It keeps giving this…
asked 2024-07-19T19:06:24.6066667+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(252.8, 49%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Prachi Patel
0
Reputation points
asked 2024-07-19T19:06:24.6066667+00:00
Prachi Patel
0
Reputation points
0 answers
Document not deleted when Blob is removed using Indexers Automatically generated from Azure OpenAI Data Studio
I am testing an Azure OpenAI on your data solution. I have set up an Azure Open AI resource and walked through the 'Add your data' workflow with Azure Blob Storage and the backing data source, this generates two indexers in the associated Azure Search…
asked 2024-07-16T15:43:17.9266667+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, 42%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFY%3C/text%3E%3C/svg%3E)
Fulwani, Yash
5
Reputation points
commented 2024-07-19T19:04:28.5633333+00:00
Fulwani, Yash
5
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure Extended Network
Azure Extended Network Just following Azure certification material mention of Extended networking, i've tried to follow the below and don't quite understand the below: Does this need a vpn on prem? Is this built of a Site to Site link? The Article from…
asked 2024-04-01T12:26:30.4733333+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, 33%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Dalbir Singh
120
Reputation points
answered 2024-07-19T19:03:05.2733333+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, 77%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETK%3C/text%3E%3C/svg%3E)
Taryel Kazimov
0
Reputation points
0 answers
Locked out of MS365 for Business admin account -> Action Required MFA loop
Originally asked on the Microsoft 365 forum but was redirected to this place. Pasting the original message below. I hope someone can help me out. -------------------------------------------------------------- Hi, I am playing around with a MS 365 for…
![](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, 91%, 22%)' 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
PL-300 certification process, for Russian/Ukrainian speakers
Good afternoon, I would like to register for the PL-300 exam in the near future. Since my level of English does not always allow me to understand the questions well, I would like to clarify whether it is possible to take the exam in Ukrainian or Russian.…
asked 2024-07-19T12:58:29.8366667+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, 54%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
yehor kunchenko
0
Reputation points
edited the question 2024-07-19T18:57:06.7533333+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, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
VasaviLankipalle-MSFT
15,941
Reputation points
2 answers
How can I enable the use of osDisk.managedDisk.storageAccountType in my Azure subscription ?
I am trying to use spot instances with ephemeral disks to save costs within a VMSS, but when I run this command: az vmss create \ --name vmssagentspool \ --resource-group Lenguage_VirtualAgents \ --image Ubuntu2204 \ --vm-sku Standard_E2as_v4 \ …
asked 2024-07-03T19:54:44.8+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, 91%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Julian Steven Molina Campos
40
Reputation points
answered 2024-07-19T18:56:41.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(160, 89%, 25%)' 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)
Iheanacho Chukwu
165
Reputation points
1 answer
how to import only the public side of an RSA key
We have data to be exported via Azure Blob Storage that we want to encrypt with the recipent's RSA public key. However, the only way I can find to import a public key (without the private key) to is as a Key Vault Secret. Unfortunately, secrets don't…
asked 2024-07-18T14:36:11.0333333+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, 93%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Moyer, Todd
80
Reputation points
commented 2024-07-19T18:50:29.7066667+00:00
Moyer, Todd
80
Reputation points
1 answer
Why doesnt the checkbox result in a value of -1?
I am checking the boxes of these fields but for whatever reason the the value doesnt result in -1. Every single box i check returns a value of 0. What can I do so that I get the -1 value of a checked box. One thing to note is that the table from which…
asked 2024-07-19T17:22:19.23+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(70.4, 15%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELA%3C/text%3E%3C/svg%3E)
Lopez, Ahiezer
236
Reputation points
commented 2024-07-19T18:50:16.51+00:00
Lopez, Ahiezer
236
Reputation points
0 answers
cannot Sign in for MFA because i change my phone
Hi Everyone i cannot Sign in for MFA because i change my phone and i don't have idea where i have to contact to ask a reset of my MFA to let me login again in my microsoft account they big issue is that email is not a real one because it use…
asked 2024-07-19T18:50:01.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(76.8, 71%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGE%3C/text%3E%3C/svg%3E)
Gustavo Esquivel | Markovations
0
Reputation points
asked 2024-07-19T18:50:01.0266667+00:00
Gustavo Esquivel | Markovations
0
Reputation points