Synonyms in SQL Server 2005

Mike Gunderloy describes in great detail a new feature in SQL Server 2005 that has been largely overlooked.

Synonyms, as Mike says here, allow you to take an ungainly name, that might include server, owner, etc., and replace it with a short name. This is actually quite a cool feature, though of course not one that I would switch over to SQL Server 2005 to get.

I hope to cover more of these little features as time goes on. At Tech Ed, I picked up a couple of new features, especially in T-SQL, that I hope to learn more about and blog about here. Stay tuned.

Posted by Douglas Reilly at 10:21 AM  Permalink