I have an address table with human-readable columns like street, city, state, zip - and also columns with spatial data (the SQL Server geography type). Technically, this violates 3rd Normal form (i.e. since you can derive street, city, state from Geo) but we know the convenience reasons for doing this. I have custom encryption for the human-readable forms but I want to do math operations in the database against the geography columns - so this is not currently encrypted.
The problem: I effectively have plain-text and the corresponding cipher-text side-by-side. (i.e. I can go find out the street that a plain-text Geo coordinate corresponds to and now I know plain-text street and cipher-text street, somewhat compromising my encryption scheme).
I don't mind having the Geo exposed, but how can I hide/encrypt the link between Geo and human readable? I see that SQL Server does NOT support doing Transparent Data Encryption for columns of the geography type (which seems like it's exactly where you'd want it).