Alright this is actually a follow up post from Gethyn Ellis post SELECT * FROM SQLBLOGGERS WHERE LOCATION = ‘UK’ . Where he composed a list of UK bloggers so I thought id summarize a list of Sql folk that tweet, but rather than make the list static I will just point you towards the list which I will keep up to date:
http://twitter.com/#!/blakmk/sqlserver-uk
It actually summarises people titles pretty well when viewed through DABR
http://dabr.co.uk/lists/blakmk/sqlserver-uk
I will keep this list updated so you are welcome to follow if you find it useful. If anyone feels left out, contact me and I will happily add you to the list.
I came across an interesting situation where a developer was trying to connect to a named instance using a DNS alias without specifying the instance name. Coincidently though he remembered to include the port number and miraculously it worked. So it appears that sql server accepts connections to a specific instance based on its port number.
While it may not seem to particularly useful, I can imagine it could be used in the following situations:
- To mirror to a server with a different instance name (but same port number)
- To hide the complexity of instance names from end users and just rely on port number (and optionally dns alias)