MS SQL – list instances

Get-ItemProperty 'HKLM:\Software\Microsoft\Microsoft SQL Server\Instance Name\SQL'

select [DatabaseName] = name,
[Status] = state_desc,
[RecoveryModel] = recovery_model_desc,
[CompatLvl] = compatibility_level,
[Collation] = collation_name,
[Owner] = suser_sname( owner_sid )
from sys.databases
order by name