Andreas Jordan comments

Results 390 comments of


                                            Andreas Jordan

Use template: Restart service to let instance changes take effect

Unfortunately, the topic is too big for the time available to me. Therefore, I will close the topic. If someone else would like to work on it, they are welcome...

Export Xel to JSON for the purpose of ingesting to Elasticsearch easily

@Angrboda2 Can you provide a litte more technical detail? Maybe some code that shows the needed transformation? Then we can try to build a command around it.

Copy-DbaLogin cannot clone a login on AG primary

I agree that the test is to strict. Maybe they wanted to test for a database on a secondary replica? @potatoqualitee - do you remember the reason for the test?

Copy-DbaLogin cannot clone a login on AG primary

Please have a look at the linked pull request.

Invoke-DbaQuery throws error "cannot be changed or read after a connection string has been set"

I'll take a look.

Invoke-DbaQuery throws error "cannot be changed or read after a connection string has been set"

I can not repro the problem at the moment. @ajaydwivedi-angelone can you please run the command with `-Verbose`?

Invoke-DbaQuery throws error "cannot be changed or read after a connection string has been set"

Thanks for the details. To dig deeper we need to introduce a new step to first change the connection context and test the resulting connection before using Write-DbaDbTableData. So please...

Invoke-DbaQuery throws error "cannot be changed or read after a connection string has been set"

The last one is interesting: It looks like `$DistributorConfig` is already a connected SMO. Can you tell me more about `$DistributorConfig`? The parameter SqlInstance has to be a string like...

Invoke-DbaQuery throws error "cannot be changed or read after a connection string has been set"

I would like to eleminate the use of registered servers. Can you connect to the instance without using `Get-DbaRegisteredServer`?

Invoke-DbaQuery throws error "cannot be changed or read after a connection string has been set"

Invoke-DbaQuery may not force a change of the connection context. Write-DbaDbTableData forces a non pooled connection and sets a database context. And that is not working properly. In any case...