THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Working with Aliases for Windows Azure SQL Databases in SQL Server Management Studio

Published Monday, January 21, 2013 12:17 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Martyn Jones said:

This is a great post, it's going to save me a lot of time looking up each alias against which client is which.

Looking forward to how to push it out the rest of my domain too!

Thanks very much.

January 23, 2013 6:40 AM
 

retracement said:

Hi Greg thanks for a useful post. I am presuming you are talking about using group policy to push out the client alias registry entries which is something I first mentioned on my blog in 2009 http://bit.ly/9BXhDm and demoed at SQLBits 7 -video can be found here http://bit.ly/XCpnTF

I most recently discussed it during my PASS summit presentation on upgrading to SQL 2012, and I always find it amusing since until now 4 years later I have never heared any one else mention it.

Looking forward to seeing whether there are any differences or considerations with respect to SQL Azure database instances.

January 26, 2013 3:55 AM
 

Greg Low said:

Yes, indeed. I'm surprised you haven't heard it mentioned before. That's how I've always done it. I used to teach the folk in the SQL Masters program about it back when the course ran in Redmond. I think it's a very straightforward way to deal with the issues.

After all, an alias is just a registry entry and so it can be pushed out by group policy like any other registry entry.

January 26, 2013 4:27 AM
 

Ken Abrams said:

Alternatively, you could just store the connection information as a registered server in SSMS. Personally, I do not store passwords in my connection information, but it enables you to have a user defined display name for the server.

January 27, 2013 9:32 PM
 

Alexey said:

Brilliant!

Thx, you save my time!

February 11, 2015 4:04 AM
 

DBAicampos said:

Great post, very well explained

April 8, 2015 6:25 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

Archives

Privacy Statement