I am trying to implement the mirror architecture for SQL Server 2008 standard database. We have different processes that connected to database and I don’t have control over those environments.  I got impression that in such cases it’s better to create DNS on server site that could be used by...