Mike -
If I had one piece of advice it would be.
DO NOT USE CaSE SENSITIVITY in your SQL databases. It will mess you up going forward.
I will send you some code to detect index collation collisions.