BI on SharePoint

Getting reports onto SharePoint is an important step in centralizing knowledge and increasing awareness of a company's available Business Intelligence. Unfortunately, people shy away from taking this step because it seems like something that would require a lot of time, effort and expense. This two part series will illustrate the process of putting BI on SharePoint, remove some of the mystery around it and hopefully encourage further investigation.  Part one will cover the setup and part two will illustrate working with SSRS reports within SharePoint.

As a follow-up to my last post on How SQL Server Sorts the UNIQUEIDENTIFIER Type, I thought it would be useful to have a function that would reorder the bytes of UNIQUEIDENTIFIERS whenever I need to show them in numerically correct order. Here's the User-Defined Function (UDF) I wrote to do this:

When you read sorted UNIQUEIDENTIFIER values in the query results from Microsoft SQL Server, it's not immediately clear how they may be ordered. Alberto Ferrari wrote a blog post about this subject a while ago. However, I didn't find that Alberto's article highlighted the answer to my fundamental questions about UNIQUEIDENTIFIER sorting. Numbering the octets in the UNIQUEIDENTIFIER from left to right as 0..9 then A..F, what is the Most Significant Byte (MSB) to Least Significant Byte (LSB) ordering of the type from SQL Server's perspective?