Sometimes, when developing in a hurry, devs make poor choices on column names.
Changing them can be a challenge, having to stage code, and time migration perfectly.
I'm told that Oracle has a way to give a secondary name to a column. Does SQL Server have anything like this? The best I can think of is to add a calculated column to duplicate the column, but this will lead to follow on indexing and performance challenges.
Any good patterns or a magic bullet for SQL Server 2008 or 2012?
(Someone mentioned a view, which would definitely work, but wondering if there's a built-in option.)
I guess I'm looking for a Synonym for Columns. http://msdn.microsoft.com/en-us/library/ms177544.aspx