Convert xlsx files to csv via automated script?
Hello, we have .xlsx files (not xls) and would like to convert them into csv files (so we can import into SQL Server) via some type of automated script to avoid manually doing each day. (Tried different methods via Import Wizard and OPENROWSET and got…
How to automatically update all application in intune
Hi Team, Under Security > Endpoint > Vulnerability Management > Recommendations, we have a lot of recommendations that ask to update applications. We want to know if there is a way to apply the software updates automatically on user devices…
Azure Data Share to Share data from Azure Managed Instance SQL Server
As part of my migration project requirements, I am looking to share data from my source system which is in Azure MI SQL Server and to the target system which is also in Azure MI SQL Server. I need to share the source data which is in Azure MI SQL Server…
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…
When will i get the original certificate of AZ900
Hi Team, As i have passed the AZ900 certification . When can i expect the AZ900 orginal certificate to be delivered / where i can download . I could see online verified cert under my credentials . Kindly help on this . Thank you. Regards, Farooq Hussain…
GET /users throws InternalServerError with 200 status code and POST /users UnknownError with 405 status code
GET v1.0/users?$select=id,delet... throws…
The VM does not load due to invalid password
https://learn.microsoft.com/en-us/training/modules/working-with-option-sets/3-exercise This question is related to the following Learning Module
Can a release date be provided for when will system role messages be available in Assistant API for ChatGPT?
Hello, I'm currently developing a product for my company that uses Azure ChatGPT with an Assistant API through Python scripts. It is almost mandatory for us to use system role messages, since using only user role messages to give instructions impacts…
Trying to use AI studio GPT 4 but got 401 Error
When I try to use GPT-4 in Azure AI Studio with a URL and key, AI Studio shows it is running normally, but the URL returns a 401 error. How can I solve this issue?
Printer Query/ SPL and SHD to PDF converter
Hi all! When I press "Keep Printed Documents" in advanced settings it saves as a SPL and SHD file. Is there an easy way to change it into a pdf/ a way I can automate changing it into a pdf? Thanks.
How to copy big file 5g with task and within impersonation
Hi, How to copy big file 5G from source to destination using impersonation: WindowsIdentity.RunImpersonated( ImpersonationHelper.Token Thanks,
Access Blob Storage from Azure SQL Server using a Managed Identity
Greetings, As the title suggests I am trying to bulk insert data from a file in Blob Storage in an Azure SQL database using an external data source with a credential using a managed identity. However the bulk insert fails saying the sql server doesn't…
Returning consistent errors in .NET Web API
I have a backend .NET Core Web API application and React App on the front. I would like to be able to return errors from the API and display them in the app. The problem I'm facing is that some classes return errors differently. For example, I'm using…
auto shutdown vm using azuresdk fluent in c sharp
this is my code to create vm in azure using azure sdk fluent my question is i need to set auto shutdown option while creating vm i need to set the time while creating the vm so in that case the vm will get poweroff when the time arrives is that…
who hold account administrator on azure CSP subscription?
my company starting to migrate PAYG subscription to CSP subscription. but still pending, because my supervisor need explanation who hold account administrator on CSP subscription. even i login to tenant csp portal, still i must contact csp support to…
How can I have my App Service always ready?
Hi all; I want my app service to always be running, so that when someone hits it, there's no delay. So how can I set it to: When restarted, it starts up immediately. In never shuts down due to inactivity. When Azure needs to apply patches or restart…
Not able to use aka.ms, Error message: Your sign-in was successful, but you don't have permission to access this resource. Error Code: 53003
When attempting to use aka.ms, the error message: "Your sign-in was successful, but you don't have permission to access this resource." is displayed with the error code: 53003 Can you please help to resolve this issue!
The subscription is not allowed to create or update the serverfarm.
As has been reported by many over the last 1-2 weeks I am seeing the above error on the deployment of all resources that require a Microsoft.Web/serverfarms resource. I have tried deployments via portal and CLI, to multiple regions, over the last 5 days…
Is their a graph API for microsoft teams admin, where I can assign a phone number to a user?
So, I am trying to find an API so that our customer can assign a phone number from our system, and it will call a graph API that would assign the phone number to their users. Is there away? because we don't want our customer to manually setup everything…
How to fix StackOverflowException after upgrading from .Net 6 to .Net 8
Hello, I have upgraded 5 projects in my solution from .Net 6 to .Net 8 using upgrade assistant in Visual Studio. When I run the solution, StackOverflowException is being thrown and Swagger is not loading. Looks like onchangetokenfired() method is being…