With the latest release of dbachecks we have added a new check for testing that foreign keys and constraints are trusted thanks to Cláudio Silva b | t
To get the latest release you will need to run
Update-Module dbachecks
You should do this regularly as we release new improvements frequently.
We have also added better descriptions for the checks which was suggested by the same person who inspired the previous improvement I blogged about here
Instead of the description just being the name of the check it is now more of a, well, a description really
This has the added effect that it means that just running Get-DbcCheck in the command line will not fit all of the information on a normal screen
You can use the Format-Table command (or its alias ft at the command line) and select the properties to display using
Get-DbcCheck | ft -Property UniqueTag, Description -Wrap
or you can use Format-List (or its alias fl at the command line)
Get-DbcCheck | fl
Get-DbcCheck | ogv