Naming Linked Servers v2

Bill Graziano on SQL Server, linked-servers |

I've always had a love-hate relationship with linked servers.  On one hand, they are very easy to use and query.  On the other they can be a pain to configure, secure, and performance tune. I wrote about naming linked servers [https://billg.sqlteam.com/2011/08/15/how-to-name-linked-servers/] in 2011.…

How to Name Linked Servers

Bill Graziano on SQL Server Stuff, linked-servers |

I did another SQL Server migration over the weekend that dealt with linked servers.  I’ve seen all kinds of odd naming schemes and there are a few I like and a few I suggest you avoid. Don’t name your linked server for its IP address.  At some point…