Cody Konior
Cody Konior
 I have the same problem in SQL 2017 CU19. Commenting out this specific comparison fixes it for me, the others don't.
My fix was to change the block like this, because I don't know what causes the problem, at least I limit any potential negative impact to just the backup/restore processes....
Having this is still desirable. - Add a SeedingMode property to SqlAG which will fill out the SMO property if it's available. - Any replica where SeedingMode = 'Auto' the...
If this were true then the module would not function in the first place, because not every file used a BOM header. Only some files had BOM header and this...
It's caused by PoshRSJob.psm1 ``` powershell $PoshRS_jobCleanup.Runspace =[runspacefactory]::CreateRunspace() $PoshRS_jobCleanup.Runspace.Open() ``` If you uncomment those (which obviously breaks everything) it will load without overwriting the module path. But only if you've...
The description is very long and complex. I don't think it affects me because I always declare param() in my scriptblock. I always assumed -ArgumentList should not work with Pipeline....
I've been working on setting up a multi-subnet cluster where each node only has one subnet so I have some information to add to the discussion. - You can't modify...
Just get all the replicas up and added to the AG before you create the listener. See https://github.com/codykonior/OftenOn/blob/master/OftenOn/Configuration/OftenOn.ps1 for one way to do it.
I use xCluster with multi-subnet; where each node has its own subnet (search for xCluster): https://github.com/codykonior/OftenOn/blob/f39caad8efd2484273db7acb1836c2b5273c99c5/OftenOn/Configuration/OftenOn.ps1 And the configuration it’s parsing is here (search for StaticAddress): https://github.com/codykonior/OftenOn/blob/f39caad8efd2484273db7acb1836c2b5273c99c5/OftenOn/Configuration/OftenOn_Template.psd1 It’s been a...
What else I found useful adding to Save-MSCatalogUpdate.ps1: * Only use the language to filter down, if filtering down returns a value, otherwise don't use it. ``` } elseif ($Language...