Add Pester V5 Database Level Checks

[jpomfret]

Database level checks need some Pester V5 love Each check needs rewritten and added to: \checks\Databasev5.Tests.ps1 We will also need to improve performance by reducing the trips to the instance/database and gathering all information in one hit before discovery, similar to initfields in #882

• [x] AsymmetricKeySize
• [x] AutoClose
• [x] AutoCreateStatistics
• [x] AutoShrink
• [x] AutoUpdateStatistics
• [x] AutoUpdateStatisticsAsynchronously
• [ ] CertificateExpiration
• [x] CLRAssembliesSafe
• [x] CompatibilityLevel
• [x] ContainedDBAutoClose
• [x] ContainedDBSQLAuth
• [X] DatabaseCollation
• [ ] DatabaseExists
• [ ] DatabaseGrowthEvent
• [ ] DatabaseMailEnabled
• [ ] DatabaseMailProfile
• [x] DatabaseStatus
• [ ] DatafileAutoGrowthType
• [ ] DisabledIndex
• [ ] DuplicateIndex
• [ ] FileGroupBalanced
• [x] FKCKTrusted
• [ ] FutureFileGrowth
• [x] GuestUserConnect
• [ ] IdentityUsage
• [x] InvalidDatabaseOwner
• [ ] LastDiffBackup
• [ ] LastFullBackup
• [ ] LastGoodCheckDb
• [ ] LastLogBackup
• [x] LogfileCount
• [ ] LogfilePercentUsed
• [ ] LogfileSize
• [ ] MaxDopDatabase
• [ ] OrphanedUser
• [x] PageVerify
• [x] PseudoSimple
• [x] QueryStoreDisabled
• [x] QueryStoreEnabled
• [x] RecoveryModel
• [X] SuspectPage
• [ ] SymmetricKeyEncryptionLevel
• [ ] TestLastBackup
• [ ] TestLastBackupVerifyOnly
• [x] Trustworthy
• [ ] UnusedIndex
• [x] ValidDatabaseOwner
• [x] VirtualLogFile

[jpomfret]

Reopened this issue as there are still checks to be converted

cc @SQLDBAWithABeard - think it closed automatically because you mentioned it in a PR

[SQLDBAWithABeard]

Hmm, that's odd. Sorry 😂

[SQLDBAWithABeard]

Ah, yes.

I put some check fixes and then the issue number so it was doing what it thought was right.

Just Rob speak wasn't aligned!!