Honestly, I'm very pro case-insensitivity, but my experience with SQL servers have impressively demonstrated how not to do it. For example, MS SqlPackage, used

Honestly, I'm very pro case-insensitivity, but my experience with SQL servers have impressively demonstrated how not to do it. For example, MS SqlPackage, used for deploying schema, is case-insensitive... But that also means changes to text constants within your stored procs do not get treated as changes.