For some reason, I have a problem remembering server name but don’t have any problem remembering SQL name instances. Maybe because I connect to the name instance more often then not. But when someone ask me what’s the physical servername of so and so SQL name instances, i’m lost.
a co-worker showed me a SQL function a few days ago that will tell you the physical servername of a SQL name instance:
select serverproperty(‘ComputerNamePhysicalNetBIOS’)
I have to look around some more to see if this function will allow me to identify clustered nodes, be it active/active or active/passive.