Activity overview
Latest activity by PeterDaniels
@Eddie D Please see my previous post. I am unable to match filehashes using PowerShell's Get-FileHash with the hash value in script_schecksum. Can you tell me how I can get matching hash, please? / comments
@Eddie D Please see my previous post. I am unable to match filehashes using PowerShell's Get-FileHash with the hash value in script_schecksum. Can you tell me how I can get matching hash, please?
How can I configure SCA to script index options with ONLINE = ON and SORT_IN_TEMPDB = ON?
I have created indexes in my dev DB with (ONLINE = ON, SORT_IN_TEMPDB = ON, FILLFACTOR = 85) options per ops DB standards, but when I refresh the SCA project, it does not include those options in t...
No, but I do have Import-Module SQLChangeAutomation in the script. / comments
No, but I do have Import-Module SQLChangeAutomation in the script.
None of the algorithms available in PS's GetFilehash match what I'm finding in the script_checksum column in __MigrationLog. / comments
None of the algorithms available in PS's GetFilehash match what I'm finding in the script_checksum column in __MigrationLog.
Thanks, Eddie. I have been checking this by using powershell's Get-FileHash, and I'm not getting a match. For example, in my __MigrationLog, one of my scripts (attached) shows a checksum of: E0F10404E1FDCBBEF178991783B426B5FCF4BA2A906DDF75CFB54DF025721EDB but using Get-FileHash -Algorithm SHA256 gives me: 222A98897E8773854BED4584B70176BA74188E5EA1D28A8ADE8DB1E1A2B59941 I've also checked my git history and none of my migrations that SCA was warning about has changed. / comments
Thanks, Eddie. I have been checking this by using powershell's Get-FileHash, and I'm not getting a match. For example, in my __MigrationLog, one of my scripts (attached) shows a checksum of:E0F10...
Hi @Dan B. Apologies for the delay in my reply. This was using powershell cmdlets in a powershell script - not a CI plugin. So, the question is how to turn off powershell gallery check in the individual cmdlets. / comments
Hi @Dan B. Apologies for the delay in my reply. This was using powershell cmdlets in a powershell script - not a CI plugin. So, the question is how to turn off powershell gallery check in the i...
Couldn't agree more, Mr Yates. Our org moves... s l o w l y [image] / comments
Couldn't agree more, Mr Yates.Our org moves...slowly
Thanks, @AlexYates. I figured as much - just wanted to make sure I wasn't missing anything. I do like having a version stamp in individual DBs as it helps to identify version as they get backed up and restored elsewhere. Could even be an extended property. It's also helpful while we don't have CI servers in place. Post-deploy script option seems reasonable. Thank you, -Peter / comments
Thanks, @AlexYates. I figured as much - just wanted to make sure I wasn't missing anything. I do like having a version stamp in individual DBs as it helps to identify version as they get backed u...
How can I tell the version of each lifecycle database using SSC?
With SCA, I can use the __MigrationLog table and its columns like Version, PackageVersion, and ReleaseVersion to see all of the changes applied to a lifecycle DB (dev integration, QA, UAT, prod) al...
How do I tell SCA to not attempt to download from the powershell gallery?
I was demonstrating SCA today without an internet connection. It showed the warnings below. How can I tell SCA to skip DL and use the currently installed versions?
WARNING: Network connectivity m...