Get-DbaProcess: Fix for empty most_recent_sql_handle

[andreasjordan]

Type of Change

• [x] Bug fix (non-breaking change, fixes # )
• [ ] New feature (non-breaking change, adds functionality, fixes # )
• [ ] Breaking change (affects multiple commands or functionality, fixes # )
• [ ] Ran manual Pester test and has passed (.\tests\manual.pester.ps1)
• [ ] Adding code coverage to existing functionality
• [ ] Pester test is included
• [ ] If new file reference added for test, has is been added to github.com/dataplat/appveyor-lab ?
• [ ] Unit test is included
• [ ] Documentation
• [ ] Build system

Purpose

Sometimes, when there is no last sql handle, most_recent_sql_handle is 0x0. Then the CROSS APPLY filters out that process.

Approach

We now use OUTER APPLY to get the row.

[potatoqualitee]

Thank you! This works all the way back to 2005 as well 👍🏼