December 2010 - Posts

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.

Posted by blakmk | 1 comment(s)
Filed under: , ,

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)
Posted by blakmk | 1 comment(s)