Lesson Learned #497:Understanding the Ordering of uniqueidentifier in SQL Server
Today, I worked on a service request that our customer asked about how SQL Server sorts the uniqueidentifier data type. We know that uniqueidentifier store globally unique identifiers (GUIDs). GUIDs are widely used for unique keys due to their extremely low probability of duplication. One common method to generate a GUID in SQL Server is by using the NEWID() function. However, the ordering of GUIDs, especially those generated by NEWID(), can appear non-intuitive. I would like to share my lessons learned how to determine the shorting method using uniqueidentifier and NEWID().
Term GUID showing in sharepoint list filter
I'm adding metadata to a sharepoint list via power automate. From testing and other posts, below is the fomat that I have found to work to add the term to the list. Issue is, when I filter the list, I get the Location + its term. It appears that the metadata is being added to the list properly. Am I passing the wrong string in power automate or any ideas on why the guid is showing in the filter?
OneDrive sync restriction not working properly - some legit machines blocked.
We've recently deployed OneDrive for Business for a customer and we set up the client sync restriction to the domain GUID. There seem to be some HUGE issues with the feature to make me think it's buggy. Issue #1 - Random computers on the "allowed" domain are not recognised as such and clients are denied sync. The error thrown is "Sorry, OneDrive can't add your folder right now." Furthermore, Fiddler shows an HTTP response "X-ClientErrorCode: MachineIsNotAllowedToSync". Issue #2 - Users randomly get a problem in Office ProPlus when opening OneDrive files. For example, in Excel, going to the "Open" menu item and select OneDrive as the storage location, they are prompted for credentials to sign-in. When they enter correct credentials, the error thrown is "That Microsoft account doesn't exist. Enter a different account or get a new one." For both of these issues, disabling the OneDrive for Business client restriction fixes the problem immediately. I've also tested affected client computers both on the local network (which has a proxy) and direct Internet access. Anyone seen this behaviour? I'd love to see some documentation on how the domain GUID is confirmed at the client-side to point me in the right direction.
