Importing csv file with Json and data with text qualifier and column delimiter
Hi Team, I have a CSV with these details. Text qualifier: " Column delimiter: , Row delimiter: CRLF But as attached, I have 2 columns in csv file, which has json and data with text qualifier and column delimiter. I want to store this file as it…
I can't open sqlproj files in VS v17.8, v17.9, or v17.10.
I can't open sqlproj files in VS v17.8, v17.9, or v17.10. The last version that I could open SQL Server Database Projects was in v17.6. Why?
How to find midpoint of a polyline
How would you calculate the x,y of the midpoint of a polyline with MS SQL Server? I can get start point and end point by using shape.STStartPoint().ToString() and shape.STEndPoint().ToString() An arbitrary point using…
LinQ query m:n relation
Hello, My input is string vendor = "xxx3"; string vendorLocation = "bbb3"; The result should be which parameter is the right one. <Label id="3" vendor="xxx3" vendorLocation="bbb3"…
Windows Server 2022 Removing Roles always say "We couldn't complete the updates" if I restarted
Can you help me about my Windows Server 2022. If I remove roles in server manager when restarting always say "we couldn't complete the updates" (I remove roles of remote desktop services and all features but same issue can you please give me…
Getting info about available memory from scaleset
When I am using scaleset from azure pipelines. I see following error. Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space. scale set runs that pipeline I know it is 16 GB RAM for the scale…
How to remove the other user button for frontline devices
I'm trying to create a configuration policy in Intune that removes the 'Other user' button from the Windows 11 login screen. The account set up on this PC has an F3 license. I do not want anyone to log in with their own Microsoft credentials and create a…
How to 'Select the Sent Request command above the GET'
Hi there, I am learning the course 'Create a web API with ASP.NET Core controllers', https://learn.microsoft.com/en-nz/training/modules/build-web-api-aspnet-core/3-exercise-create-web-api It states 'Open the ContosoPizza.http file. This file has been…
How to correlate reverse Proxy server (windows ) server IIS logs and Exchange IIS logs for user access and mail send.
Hi all, I need help , regarding an analysis of event that took place in our organization. One email ID has send an email to all users inside the org. and we need to track it down. We have logs from exchange server (IIS) and message tracking and reverse…
Can we safely upgrade the version of Microsoft ODBC driver 17 for sql server, on a server running sharepoint server 2016?
We have a server running sharepoint server 2016. SQL is installed on another server. The sharepoint server has Microsoft ODBC driver 11 for sql server ( installed as part of the pre-reqs for sharepoint install) and also Microsoft ODBC driver 17 for sql…
Can we integrate IFrame in teams bot
Hi Team, We are using the teams bot for QNA purposes and we wanted to integrate the MS booking feature in the bot. Currently, we have tried to use the embedded link of ms booking. But one security issue which we see is that MS booking page is opening a…
Unable to start VM
I'm encountering an error message stating the virtual machine agent is not ready when attempting to start a VM through the portal. I've tried restarting the VM after logging in via RDP, but now the VM won't start at all, and the agent status remains…
Export single Configuration Profile (Settings Catalog) as a file
I am looking for a PS1 script or other simple solution to export and import single config profile created by Settings Catalog mechanizm as a file. Is there a such thing? Group Policies had this feature like 10 years ago :D (Please don't tell me go…
Graph API Create documentSetVersions in a List
Hi, I am trying to create a documentSetVersions using the POST API ("sites/{site-id}/lists/{list-id}/items/{item-id}/documentSetVersions"). Below is the body in JSON format being send to API. { "comment": "put your comments…
How to choose what the network option for your Azure Open AI Service that you create?
The guide does not offer information on how to deal with the network tab that comes after setting up the name and the subscription group details. Might be useful to add this section for other user who might have the same problem in the introductory…
Azure Portal | New UI Features
Hi I can see on my colleagues azure portal, that the new Function App Features are visible. For example, there is now an Environment Variables section on the Settings Blade in the Function App window. I am not able to see that.. Colleagues are saying…
Windows Hello for Business Entra ID Sync Issue
SOLVED: See my answer below. Hi all, Interesting issue we're running into while trying to deploy Windows Hello for Business. I've noticed in our Azure AD Synchronization Service Manager, during export from Entra to on-prem DC, the…
Python SDK for Product detection on shelf using Computer Vision and custom vision.
Hi im unable to find the correct documentation for product detection on shelf, using both computer vision and also using custom vision. I want to know whether a documentation exists outlining all functions and parameters that go into each function using…
Desktop Windows Files Missing After Windows 11 Upgrade
My local HDD & SSD laptop folders for desktop, photos, and docs are missing due to an upgrade to windows 11 and the automatic sync to onedrive due to the settings that I have on a different desktop computer. Is there a way to recover my local folders…
Cannot edit an existing data factory in synapse
I have a synapse workspace with several pipelines with data factories. Today I have noticed that existing data factories that are running correctly I cannot see the details when I edit them I attach two examples, one that is working and the other that I…