https://www.ssw.com.au/rules/create-new-databases-in-the-default-data-directory
DBAs - Do you create new databases in the default data directory? | SSW.Rules
Learn how to create SQL Server databases without specifying paths using default settings for simpler, version-agnostic scripts.
create new databasesssw rulesdbasdefaultdirectory