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…
can not start sql server2012.the request failed or ther service did not respond in a timely fashion.
This error will be reported after starting sql server 2012, check the log,Please refer to the following picture to view the log. How to solve it? The description for Event ID 17836 from source MSSQL$MSSQL2012 cannot be found. Either the component that…
Creating ActionRule from an ARM template results date format error for effectiveFrom field
This is the excerpt from my ARM template I try to deploy, but getting the following error: Status Message: Invalid input parameters: Wrong DateTime format of the parameter: 'effectiveFrom', with value: '2022-03-08T00:00:00Z'. Expected date time format…
Azure python runbook import_py3package_from_pypi : Exception: Error importing package cryptography into Automation account. Error code is 400. from p
hi all, on Azure Automations I am receiving this Exception when I try to run import_py3package_from_pypi runbook on module msgraph-sdk -v 1.2.0. I only require the functionality from the runbook to access the microsoft graph using certificate…
Why is there no way to sort the SharePoint pages I am following?
I have to "follow" many pages on SharePoint - why is there no way to sort or pin the pages listed in the Following section? Additionally, why do they need to appear in Card format. with a text list at least they would take up less room on the…
Can a single Entra P1 license be used to collect account configuration data within a tenant without requiring P1 licenses for every user?
I am trying to evaluate a tenant's user accounts for proper configuration of conditional access policies, MFA registration, and more. I've found that a single service account with a P1 license can query the graph API for this information, but I'm unsure…
Migrating from VNET (Classic) to ARM has interruption on the resources?
Have a good day, Migrating from VNET (Classic) to ARM has interruption on the resources (apparentaly not) ?, Also in case something goes wrong there's a rollback for this change ? we don't want to have issues with the services. the following link is what…
A random file started popping up in my desktop named SZCCID
Hello i don't know from where did this file started popping up named SZCCID i deleted it every time but it create its self every time i reset my pc if any one have similar problem or found solution pls tell me . Thanks for the future help and sorry for…
Connecting the log analysis workspace to the Azure update manager.
Is it possible to integrate azure update manager with log analytic workspace? If the answer is in the affirmative, could you please provide me with a high-level guide?
Delta Column in Application Insights Performance
I would like to know what is the use of Delta Column in Application insights performance when zoomed in, I mean there is an information stated above but could u guys please elaborate?
Set ACLs on Storage Container using Powershell - Authorization Mismatch
Hi all, I am having trouble using Powershell to set ACLs on a storage account container using: Update-AzDataLakeGen2AclRecursive The error suggests that I do not have permissions, however I can set ACLs through the Azure Portal, and can set and…
Unable to drag and drop outlook attachments to file explorer after new outlook preview turned on
Hi Everyone, Out organisation is now being prompted to try the new outlook version in preview. We have noticed that in this new version you cannot drag and drop attached files in an email to file explorer (downloads, OneDrive etc) you have to actually…
Azure Synapse Analytics Workspace connector in power bi is not connecting, are there system issues? It was working fine yesterday.
I am unable to view data in power bi using the "azure synapse analytics workspace" connector, the navigator view just spins forever. IS there an issue with the service? It was working yesterday and there have been no changes to our…
EDI cross reference table
Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?
Timeout and Connection Issues in ADF with Azure Managed Postgres: Npgsql Exception
I’m currently engaged with ADF and Azure Managed Postgres, and I’ve been encountering a persistent issue where look-ups and query-sourced copy activities consistently time out around the 35-second mark. Failures happened on 'Source' side.…
HyperV Virtaul Machine live migration Failed
I am getting quite strange issue with HyperV as some of virtual machines able to migrate between hosts in cluster without any issue but others are failing with error. "The virtual machine is using processor-specific features not supported on…
SQL2022-SSEI-Expr setup file is not opening
I downloaded the express edition file from here :https://www.microsoft.com/en-us/sql-server/sql-server-downloads When I try to open it , the file dont open . dont know whats wrong with it. Need Help with the installation. TIA
Failed to Initialize Registry Root Hive
I recently have Visual Studio 2022 installed and had used it for approximately 2 weeks. Today in all of a sudden when I tried to start Visual Studio, it showed up a error and told me to go look at the ActivityLog.xml: <?xml version="1.0"…
Put Blob REST API Content-Length error
I'm trying to write the XML response obtained from a REST API GET request to a file in Azure Blob Storage, using Azure Data Factory. I'd prefer to use the Copy activity to achieve this, but it doesn't support XML sinks. I've therefore been forced into…
excel file doesnt not load up
excel file does not load up from my pc. Failed to read metadata from file source. Response from the end service is : Bad Request clientRequestId: 44b6fe67-83f0-4bfb-9cd7-c8939fd9eb9f serviceRequestId:…