A little road trip to bean town is planned this weekend. I am really honored to have the opportunity to present at SQL Saturday #364 in Boston. It will be a good time to meet old friends and make new ones. This year’s event has an all star line up of MVP’s who are talking at this free event on April 18th, 2015. If that is not enough excitement, the 119th Boston Marathon is gearing up for Monday’s race and the Red Sox are playing the Orioles until Monday. I…
I am finally back in the writing saddle again with a spree of tidbits for the month of April 2015. These articles will focus on learning a simple TSQL command or technique. Today, I want to talk about how synonyms can be used to preserve backward compatibility objects while allowing for schema redesign in existing databases. The CREATE SYNONYM and DROP SYNONYM key words were added to the TSQL language in the 2005 version. The main purpose of the construct is to provide a simple name to reference a database…