Don’t specify IP’s in your SQL connection string
In today's SQL newsletter from SQL-Server-Performance.com I was horrified to find the following tip: When you specify a server in an ADO.NET connection string, use the server's IP address, not the server's DNS name. By using an IP address instead of a DNS name, name resolution does not have to occur, reducing the amount of…
