Dan Reist

Results 39 comments of Dan Reist

The only reason the `SqlServer` or `SQLPS` modules are required is to run the _create database_ and _database rights_ scripts using `Invoke-SqlCmd`. If another native method natively available that can...

The resource should evaluate if the current node is actively hosting the SQL instance. If it is not hosting the instance, it should write a verbose message stating that it...

To resolve this issue, a parameter called `ProcessOnlyOnActiveNode` should be created on the `Set-TargetResource` and `Test-TargetResource` functions. The `Get-TargetResource` function will execute the helper function `Test-ActiveNode` to determine if the...

I am unable to locate the seeding_mode property in SMO. So far the only place I've been able to locate it is in sys.availability_replicas.

No worries! I've been collecting stuff for this in the back of my head. Once I finish up the AG database resource, I'll wrap back around to this.

Looks like my Azure VMs started working again last week, so, hopefully soon!

@johlju, how do we log into the build servers to troubleshoot what is wrong? I recall seeing something somewhere, but I don't remember where!

/AzurePipelines run

@johlju, looks like the only failure in the pipelines was well before `SqlRs` was attempted. Can you re-start the pipeline to verify?

All right, thanks. I'll continue troubleshooting