SQL Max(Date) query could return multiple rows
Having a devil of a time trying to find a query to return what I need. I have a table as above. I am trying to use max(eff_date) to return the last record(s). Most of the time, only 1 record will be returned for the max(eff_date), but sometimes, more…
server 2016 patches
With regards to slightly older versions of windows server (namely windows server 2016), is it still standard that Microsoft issue monthly patches every month for that version, or do patches become less frequent the older a version becomes, and more…
How to create multiple vm by using powershell
Hi Team, I am creating multiple virtual machine by using powershell script. I am getting below error. How can I fix this. New-AzNetworkInterface : Cannot attach a Standard public IP address…
AZ-900 Certificate Not Showing in Microsoft Portal
Hi, I took AZ-900 exam on 10th of May, 2024 and get my result in Pearson VuE portal but same is not showing in the Microsoft Portal. just wanted to know when will it show on Microsoft portal to download and save. Thanks
How to extract part of the text from the line with a special format
hi Bolded areas need to be extracted. I don't know how to use Regex library. my Format [One of the tags] is Sample '10LBA04CT004-XQ01' Start text with 150,000 lines and have different tags. thank { N 3-SH 3-sh 3-sh 3-SH N 10LBB09 EQUIPMENT =…
Visual Studio App Center is scheduled for retirement
May be you know, that Visual Studio App Center is scheduled for retirement on March 31, 2025. My question is, "will Visual Studio App Center retirement affect the functionality of Azure Active Directory Conditional Access after March 31, 2025?
Azure OpenAI: DALL-E image variation and image editing
Dear, experts. Could you please confirm or rebut that currently image variation and image editing is not supported by Azure OpenAI? OpenAI reference: https://platform.openai.com/docs/api-reference/images/createEdit and…
Can't open port in Azure
I had opened port in firewall And i had added rule in NSG But the port still not opened. Can someone give me the solution, thanks a lot
Sharepoint Online Site Audit Log
In the Site Collection Audit log I need to run the Deleted Items report. The problem is it only gives me the option to save the document to a SharePoint location, which I do not want to do since others will see it. Is there anyway I can save the document…
Create MSI from EXE in MAUI
Hi, In cmd i create the exe of MAUI App. using this command: dotnet publish -f net8.0-windows10.0.19041.0 -c Release -p:WindowsPackageType=None -p:WindowsAppSDKSelfContained=true…
How to create service principal, link to the azure sql database in the azure portal.
I want to know how to create service principal to connect to azure SQL server database. (I tried by creating user assigned identity. But this also not succeeded.) The user assigned manage identity is configured by, *create user assigned manage identity…
Exam scheduling issues.
I have completed Microsoft azure AI foundamental challenge which challenge allowed me to schedule exam free of cost by providing voucher. I have received voucher after completing the challenge but while scheduling exam i am unable to redeem this voucher.…
How to fix "Could not load file or assembly 'Microsoft.Azure.WebJobs.Script.Abstractions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=3c5b9424214e8f8c'. 指定されたファイルが見つかりません。" error when "func start"
I am trying to run my function written as "Azure Functions" with Node.js on my Windows using "func start" command, but I am encountering an error message that says: $ func start Azure Functions Core Tools Core Tools Version: …
Hi folks , Getting this error while running copy data activity in azure data factory " Http Url Address 'https://github.com/https://github.com/cloudboxacademy/covid19/blob/main/ecdc_data/cases_deaths.csv' is invalid." Even the url is accessible.
Hi folks , Getting this error while running copy data activity in azure data factory. Consider this is source url " Http Url Address 'https://github.com/https://github.com/cloudboxacademy/covid19/blob/main/ecdc_data/cases_deaths.csv' is…
Azure Data Factory - Pipeline always fails at the second connection to On-Premise data source
I have SSIS Package that pulls data from On-premise data Source and push data to Azure Database. In that package, I have 3 data flow tasks, each of them connect to one db on On-premise data Source. SSIS Package has been deployed to Azure SQL DB (SSISDB)…
Help with SQL
Hi Experts, Need help in creating calculated columns as below. My Data: Expected Result of two calculated columns: Calculated Column 1 = Previous calculated value in Calculated Column 1 * Rate Calculated Column 2 = RecentMinRent * current…
PAID subscrip
I have payment of almost 80$ on my Azure account. I learn programming and I haven't notice that it is paid. On my Microsoft there is no information on this payments whatsoever. I am surprised, as I don't have much knowledge, and I have been using my web…
Internal error while using Excel add-in copyFrom
The following error occurred while copying a short row of coloured empty cells from Q31:AB31 to Y1:AJ1 on a different worksheet. The cells did not contain any data and appear to have been copied successfully before the error…
How to display Image Data on .NET MAUI Blazor App
How to display Image Data on .NET MAUI Blazor App Here is the api that fetches Image data https://quizapijwt.azurewebsites.net/api/Questions Images are stored in imagedata bytea CREATE TABLE public."Questions" ( "SNo" int4 NOT NULL…
I didn't recieve teh badges for AZ104 and AZ400
Hello team, I have cleared both exams but still, I didn't receive the badge.