Module Signing was introduced in SQL Server 2005, and yet people are still using Impersonation and TRUSTWORTHY. This needs to stop.
Who will win "Who's Collation is it Anyway?" Database Collation is ahead, but Column Collation isn't about to give up.
Microsoft says string literals not prefixed with "N" are converted to the Code Page of the Database OR referenced column. Is that true?