Simple-Talk.com came out with a great article titled SQL String User Function Workbench
It has some great sql functions that I’ve spent hours looking for in the past (or had to write myself):
- Split function
 - SplitLines
 - Within (not from python)
 - EndsWith
 - StartsWith
 - Contains (not from python)
 - Join
 - Parts (not from python)
 - Partition
 - RPartition
 
Anyway, I bookmarked it to go back to in the future.
One the hardest tasks, at least I find, is picking a good color scheme for a website. There are a number of good color pickers out there, but they all generally work off of a set formula. A good example of them is