Andreas Jordan

## Type of Change - [x] Bug fix (non-breaking change, fixes #8442 ) - [ ] New feature (non-breaking change, adds functionality, fixes # ) - [ ] Breaking change...

Invoke-DbaQuery: Add new parameter to convert byte-arrays to hex strings

4

### Summarize Functionality This is a follow up to #8453. The output of querys like `Invoke-DbaQuery -SqlInstance SQL01 -Query "SELECT sql_handle FROM sys.dm_exec_query_stats" -As PSObject` returns an array of bytes,...

A new idea: What about having some templates for code that is used in more commands, including some information about how and why to help new contributors. We already have...

Update logging framework based on new version of PSFramework

9

### Summarize Functionality See: https://twitter.com/FredWeinmann/status/1533198245496758274 > Yo fellows, the latest version of the [#psframework](https://twitter.com/hashtag/psframework?src=hashtag_click) [#powershell](https://twitter.com/hashtag/powershell?src=hashtag_click) module shipped today! Massively improved logging performance for the logfile provider (and no more collision...

Use ClearAndInitialize to improve performance

1

### Summarize Functionality We implemented ClearAndInitialize to improve performance in Get-DbaDbView in #8042. Background info (https://github.com/sqlcollaborative/dbatools/pull/8042#issuecomment-1003418389): Write up from SMO team for those interested: https://github.com/microsoft/sqlmanagementobjects/wiki/Refresh-vs-ClearAndInitialize > ClearAndInitialize offers a parameterized...

Get-DbaDbTable does not work on Azure without access to master

4

### Verified issue does not already exist? Yes ### What error did you receive? The server principal 'myUser' is not able to access the database "master" under the current security...

Code Review to find problems with too many connections

1

@tboggiano asked me to have a look at the code to find problems causing too many open connections. First of all: As you extensively use `.ForEach` and `.Where`, it is...

[New Feature]: Support for Oracle Linux

9

### Description I tried to use Oracle Linux today - as it should be working like RedHat. The ISO "OracleLinux-R8-U9-x86_64-dvd.iso" was displayed by `Get-LabAvailableOperatingSystem` like this: ``` Architecture : x64...

Not sure if bug or feature, but the code only runs `Remove-NetNat` and not `Remove-VMSwitch`: https://github.com/pluralsight/PS-AutoLab-Env/blob/d93c1a577e073f1b4f8638a86e7ddf3337d3b9da/functions/public.ps1#L1190-L1199 So I had to also run `Remove-VMSwitch -Name $Labdata.AllNodes.Lability_SwitchName`.

This is based on our findings that we documented here: https://blog.ordix.de/instant-file-initialization-microsoft-sql-server-set-up-check TL;DR: setup.exe uses "NT SERVICE\MSSQLSERVER", the Configuration Manager uses "LABDOM\SQLServerGMSA$". We currently use "LABDOM\SQLServerGMSA$" with `Set-DbaPrivilege`. And we use...