Add is_MSshipped or similar to sys.databases or databasepropertyex
There are situations when you want to run an operation on all databases on the server, for instance creating a DDL trigger, stored procedure. But you don't want to perform this operation on databases which are created by SQL Server itself. The classic system databases are simple to filter out, but these days there are DWQueue, databases for SSRS and whatnots. Filtering out these by name is error-prone and not very safe. It would help if there was something similar to is_msshipped you could filter on. This could either be in sys.databases (preferred) or in databasepropertyex. As for the actual name, I leave that to Microsoft to decide on.
Solomon Rutzky commented
This is very similar to a request I made a couple of years ago and received less-than-ideal feedback on:
Add "type" and "type_desc" fields to sys.databases DMV (to make life easier on EVERYONE) ( https://feedback.azure.com/forums/908035-sql-server/suggestions/32897959-add-type-and-type-desc-fields-to-sys-databases )
I was hoping to go one step further than just knowing that it was a "MS Shipped" DB: to also know a basic "type" of DB, whether it was system, or demo, or feature-specific (e.g. for SSIS, SSRS, Replication, etc).
Perhaps my request was too complicated and this one might be easier to accomplish. In either case, something/anything is better than the current nothing :-).