SELECT @@VERSION;

SELECT SERVERPROPERTY('EngineEdition');

1 = Personal or Desktop Engine
2 = Standard
3 = Enterprise
4 = Express
5 = SQL Database
6 = SQL Data Warehouse
8 = SQL Managed Instance

SELECT * FROM sys.databases;
SELECT * FROM sys.objects;

SELECT * FROM sys.dm_os_schedulers where STATUS = 'VISIBLE ONLINE';

SELECT * FROM sys.dm_process_memory

Azure SQL:SELECT * FROM sys.dm_user_db_resource_governance;SELECT * FROM sys.dm_os_job_object

SELECT * FROM sys.dm_exec_requests;