Getting a list of databases on a MS SQL Server

The below query will return a list of none system databases on a Microsoft SQL Server;

Or you can run the below to get a list of databases along with their size and remarks;