SQL Collation Made Easy
In what seems to be a common theme in my posts, here's a snippet of information that everyone probably already knows but I just learned about. Have you ever had two tables you're trying to join in a query using text-based columns (eg varchar), but they're different collations so you get a...