SQL Dumbass

Fighting dumbasses, one query at a time…

More Vendor Brilliance

Vendors never cease to amaze me. I know they could not possibly be as obtuse as they come across, but their communication skills and documentation needs so work. For example, consider this gem:

Have your SQL Server Administrator create a database named ‘[name_withheld_to_protect_the_dumbass]’ with their desired options. The database collation must be SQL_Latin1_General_Cp1_CI_AS or SQL_Latin1_General_Cp1_CS_AS.

The hell?

You want me to create a database, with MY desired options, and then you tell me it has to have a specific collation. Hey, any chance you want to tell me that before I create the database? And look closely at those collations. One is case-insensitive, the other is case-sensitive. Well? Which is it going to be? Do you care, or not?

Vendors. Can’t live with ‘em…pass the beer nuts.