New Dba Date Desc -
If you manage a heterogeneous environment, centralize this data. Steps:
SELECT * FROM db_inventory ORDER BY first_seen_date DESC;This artificial creation date (first seen by your monitoring) is often more practical than relying on unreliable system tables. new dba date desc
| DBA Name | Action | Action Date | |----------|---------------|---------------------| | jdoe | New DBA role | 2026-04-19 08:30:00 | | asmith | New DBA role | 2026-04-18 17:45:00 | | bjones | New DBA role | 2026-04-17 09:15:00 | If you manage a heterogeneous environment, centralize this
SQL Server tracks database creation in sys.databases. The column create_date holds the UTC timestamp. Report with date desc – Simple SQL: SELECT
Basic query for newest databases:
SELECT
name AS DatabaseName,
create_date AS CreatedOn,
state_desc AS Status
FROM sys.databases
ORDER BY create_date DESC;
To match "new dba date desc" precisely:
-- New DBA date desc: latest first
SELECT TOP 10
name,
create_date,
compatibility_level
FROM sys.databases
WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb')
ORDER BY create_date DESC;
Automation tip: Schedule this query daily and output results to a monitoring table or email alert.
