SQL Server Aliases

As part of a meeting on setting up DR systems, one of the Server Techs mentioned using SQL Server Aliases to allow the cubes to be identical in structure – right down to connections – yet live on separate environments and point at different SQL Servers. This was news to me, but a quick google turned this up: How to setup and use a SQL Server alias.

An Alias is an Operating System level setting that allows you give a friendly name to your Server – and you can then connect to the server using that friendly name. What this means is that as you migrate your code from environment to environment, if you use the same friendly name for your SQL Server in each tier of the deployment, you don’t have to change your connection strings.

It’s a neat trick (though i’m not sure how the names resolve if you use the same name in environments that can see each other) – it certainly requires some proper planning from an infrastructure point of view.

2 thoughts on “SQL Server Aliases

  1. I am so please to see this issue being canvassed
    As someone who manages projects i get so tired of IT people who set up an instance with some obscure technical name that is usually either functional, relates to the software or if it is thought about is way too obscure. That’s where e are stuck with things like http://Image076/ or some such useless domain name that is embedded all our URLs .

    As for planning on infrastructure and everything upwards from there it is often a forlorn plea to start where we want to end up. That is often too hard and too detailed for most in the get it done urgency to have something working and adding value. So it gets underway without good thought on the impact of a later change.

    All URLs in the public domain are always cleared by marketing. But internally in project that does not work and is most often done by IT. And so often as learning is done in the development die is cast and the system life is then limited as people struggles to find it later once the initial system is done.

    Using and understanding aliases, I believe is essential so we can break this nexus on what may also be driven by standards and security issues to make the transition easier and always friendly.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>