Getting local tests to fail

[potatoqualitee]

I'm working on a whole upgrade of SMO which requires an upgrade of our library.

There are like 4 tests that fail on appveyor that I can't get to fail locally. Can you? The branch is smonewest.

Note that you will have to close out every open copy of PowerShell and VSCode to switch branches as there are a bunch of DLLs being swapped out.

The commands I can't get to fail locally are:

• Get-DbaUserPermission - Can you get it to return nothing for Get-DbaUserPermission -SqlInstance $script:instance1 -Database tempdb
• Install-DbaDarlingData - Install it
• Sync-DbaLoginPermission - Can you sync some perms?
• Invoke-DbaBalanceDataFiles - Can you get it to not work?

I manually copied the commands ran in each of the .Tests.ps1 and cannot get these to fail but I don't want to just ignore them just yet because they may be a canary.

[potatoqualitee]

I ran this on a Windows 2008 R2 machine with PSv3 and could not get it to break. Arg.

[potatoqualitee]

Testing locally on appveyor works 😡 So far, I'm leaning this works, it's just appveyor, suddenly

[potatoqualitee]

K, I've determined that appveyor just chose these commands to to fail. I'll add them to pester_groups to skip and uncomment a lot of others that failed with previous versions of SMO

[potatoqualitee]

Removed these from the ignore group, so we'll have to keep an eye if they work better with the new SMO

        # weird too often
        'Add-DbaComputerCertificate',
        'Get-DbaComputerCertificate',
        'Get-DbaMsdtc',
        # a bug in SMO prevents availability group scripting :(
        'Export-DbaAvailabilityGroup',
        # these work but fail too often on appveyor
        # will revisit once they get their new data center
        'Remove-DbaAvailabilityGroup',
        'Get-DbaSuspectPage',
        'Reset-DbaAdmin',
        'Remove-DbaAgDatabase',
        'Export-DbaDacPackage',
        'Set-DbaAgReplica',
        'Test-DbaOptimizeForAdHoc',
        'Test-DbaDbRecoveryModel',
        'Set-DbaDbState',
        'Test-DbaDeprecatedFeature',
        'Test-DbaInstanceName',
        'Test-DbaTempDbConfig',
        'Measure-DbaDbVirtualLogFile',
        'Test-DbaAgentJobOwner',
        'Resume-DbaAgDbDataMovement',
        'Get-DbaDbMasterKey',
        'Test-DbaAgentJobOwner',
        'Stop-DbaXESession',
        'Get-DbaPrivilege',
        'Get-DbaPermission',
        # strange pester issues
        'Find-DbaAgentJob',
        'Remove-DbaDatabaseSafely',
        'Set-DbaDbOwner',
        'Test-DbaManagementObject',
        'Test-DbaMaxDop',
        'New-DbaLogin',
        'New-DbaDbUser',
        'Get-DbaLastGoodCheckDb',
        'Read-DbaAuditFile',
        # doesn't work on appveyor but so works locally D:
        'Read-DbaXeFile',
        'Find-DbaCommand',
        'Watch-DbaDbLogin'

[potatoqualitee]

Resolved ✔️