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().
Onedrive albums - allow custom photo sorting
One of the things I like about google photo albums is that you can easily drag photos around in order to create a "custom sort" of the photos. This is important in order to make a gallery look "just right". I like many things about onedrive albums (and onedrive), and I'd like to start using it, but as far as I can tell, it doesn't allow for any custom photo sorting. If I am right about this, will microsoft ever be adding a "custom photo sort" capability to the onedrive albums? ThanksHow to Detect Files of the Same Size on your Computer via PowerShell
Learn how to use PowerShell to detect files of the same size on your computer quickly and easily. This article provides a script to automate the process and save storage space. Follow the step-by-step instructions and improve your file management skills with PowerShell automation.
Sort by Name not proper for numbered files.
Just trying to understand the logic of OneDrive's "Sort by Name" when it comes to numbers. Take a look at the below. "9-26" shouldn't be coming before "9-3". The number 26 should be perceived as after 3. I cannot honestly say I've seen that issue with other storage services.Sheet View is generally available
Introducing Sheet View on Excel for the web, a new way of letting you create customized views in an Excel worksheet to sort and filter your data. You can filter to display only the records that are important to you without being affected by others collaborating in the document. All your cell level edits propagate through the file regardless of your view, so you can make all of your in-cell edits in your Sheet View, too.Apply view only for a specific folder
Hello everyone I have a folder within a default document library which is connected to a team in teams. So, in this folder I have documents that must be sorted by its number in the file name. Example: File_1 File_2 ... First, I figured out that it isn't possible to sort numeric, if the number is only in the filename. SharePoint will then sort it like: File_1 File_11 File_2 ... Very frustrating but okay. So, I created a numeric column that can be used to sort the files properly. But what I noticed is that the column is now visible in the whole document library 😞 So now my question: Is it possible to apply the column to only being visible in this specific folder where I need it? I tried it with different views and so on, but it seems that this cannot be achieved. Thanks for your help.
Sharepoint Sort by Czech Alphabet (or set locale)
Dear community, I'm sorry if the question was already asked but I couldn't find any. I would like to ask, if it's possible to sort by (order by) alphabet (which works fine) but to specify Czech alphabet, which has specific letters in addition to English. We have built employee directory based on LocalePeopleResults (package https://github.com/microsoft-search/pnp-modern-search) in Sharepoint but we are unable to sort by Czech alphabet. Therefore for example letter "Č" which is after letter "C" is at the end of directory as special character. Our sharepoint site language is set to Czech, basically everything is in Czech, but not the alphabet. Would you have any recommendation what we could try or if we can set locale in KQL? Custom managed property probably can not be used as number of employees is not final. Thank you in advance. All the Best, Adam
