Converting UTC to EST with daylight saving
I am trying to convert UTC to EST with following formula but its not taking daylight saving time to consideration. toString(fromUTC(currentUTC(),'EST'),'yyyyMMddHHmmss') it shows time one hour behind EST. Is there a workaround?
Authenticator app is requesting a code from the app itself
I'm the admin and I cleared my computer's cache and it asked me to log in again to my professional account. Once I entered the email and password, it told me to write a code in the authentication app, but the app does not give me any option to enter the…
Auto MDM Enroll: Device Credential (0x0), Failed (The system tried to delete the JOIN of a drive that is not joined.)
We are trying to enroll a device into a third party MDM via autopilot, the device successfully joins but the enrollment does not happen and the above error is found in the Devicemanagement-Enterprise-Diagnostics-provider event viewer logs The following…
xamarin control changing button invisible true false in code
How can I control if a button is visible in code. <buttons:BindableButton BindingContext="{Binding Close_Page_Clicked}" HorizontalOptions="EndAndExpand" IsVisible="{Binding…
Inaccurate and wrong output on C# training p2
I am experiencing issues with the C# training p2 module, found at https://learn.microsoft.com/en-us/training/modules/guided-project-arrays-iteration-selection/5-exercise-implement-selection-statements. In this exercise, the variable sumAssignemtScores is…
SharePoint File Permissions Properties and User Granting Mechanisms
Hello! I have a requirement to fetch permissions for files stored in SharePoint. Most of my work is done, but I'm struggling to identify some properties available in the permission resource. I need to understand how these properties can be accessed for…
How to Update and Migrate from Sql Express 2012 to Sql Express 2019 on aus-possum.
Hi Team, Good Day! We have got one request from our user that he need to Update and Migrate from Sql Express 2012 to Sql Express 2019 on aus-possum. Is it possible to do this? If yes means please provide the steps to do this. Thanks & regards…
Regarding waking up from sleep on a Modern Standby PC
Currently, on a Modern Standby PC, I'm trying to wake it up from sleep at a specified time every day using Task Scheduler and then execute a task. In Task Scheduler, I've set it to "Run whether the user is signed in or not" and "Wake the…
How to remove duplicate devices in denfender and intune
Hi team, We have devices that are listed twice, or three times, with the same device ID but different names in defender under asset >devices . This happens when we offboard a user, we wipe his computer and then assign it to another person, so the…
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…
Azure backbone network traffic allow access to storage account
Hi, We should allow access to storage account from Dynamics 365 Microsoft managed environment, the access must be granted to blob storage account. The problem is when we try to access storage account in same Azure region the connection from Dynamics 365…
Shared mailbox sent items
We have a hybrid O365 environment. For shared mailboxes we are trying to configure it in such a way that the sent items from said shared mailbox, only save to the shared mailbox sent items and not that of the user who sent as the SM. In the 365 console…
Using REPLICATE_REWRITE_DB in Azure MySQL database
Database names in my Master and Replica server are different. Master DB name - uas-tms-20211111 Slave DB name - uas-tms-uat To get the replication working in this scenario, we use REPLICATE_REWRITE_DB option in on-prem MySQL servers. …
The Static Web App contents cannot be updated while a backend migration is in progress
When attempting to deploy via an Azure DevOps pipeline or the SWA cli we get the error: The content server has rejected the request with: BadRequest Reason: The Static Web App contents cannot be updated while a backend migration is in progress. It was…
sharepointIdentitySet (application, device)
Hello! Referring to the documentation, I've noted that the sharing permission resource (grantedToV2 and grantedToIdentitiesV2) contains a SharePointIdentitySet. I require clarification on how to assign permissions using an identity set that includes a…
When training a custom extraction model, how should column names be labeled to ensure accurate recognition during testing?
I have a collection of documents containing various tables. When attempting to label the column names, direct labeling is not possible. Initially, we must insert the column names in the first row (i.e., #0), and then use this as a template to rename the…
MSSql 2k16 cannot switch version
running an express edition of 2k16, that reached file size limit, on a w10/64 OS. All OS updates done. SMSS v 20.1 Purchased serial with 20 cals. Started the "2k16 install center" --> Maintenance --> Edition upgrade type in the serial.…
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…