IT bits and pieces
IT: geamuri and open source
get the instance name:
select convert(nvarchar(128), serverproperty('servername'));