sp_Blitz - some default configs may be missing

[BrentOzar]

Hi Brent,

for some config values there are no records in #ConfigurationDefaults.

When running below script on my SQL Server 2014 I get 6 configs that
are not in #ConfigurationDefaults (blocked process threshold (s),
common criteria compliance enabled, EKM provider enabled, backup
compression default, filestream access level, backup checksum
default).

For backup compression default there is another check.
Maybe all the others a new with SQL Server 2014?

select sc.*
from #ConfigurationDefaults cd
right join sys.configurations sc
on cd.name = sc.name
where cd.name is null;

best regards
Tobias Ortmann tobias.ortmann@gmail.com

[BrentOzar]

Fixed in v44.