Get the size of all database in a SQL-Server

    SELECT DB_NAME(database_id) AS DatabaseName,
           sum((size * 8.0) / 1024.0) SizeMB
    FROM sys.master_files
    WHERE DB_NAME(database_id) in(SELECT name FROM sys.databases )
group by DB_NAME(database_id)
order by 1