Skip to content

Instantly share code, notes, and snippets.

View MartinMiles's full-sized avatar

Martin Miles MartinMiles

View GitHub Profile
@MartinMiles
MartinMiles / TransformWithMsConfig.bat
Created April 8, 2019 11:33
That is how MsConfig performs config transformation
"C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\amd64\MSBuild.exe" /nologo /maxcpucount /nodeReuse:False /property:Configuration=Debug /property:Platform="Any CPU" /property:WebConfigToTransform=C:\inetpub\wwwroot\Platform.dev.local\ /property:TransformFile=C:\Projects\Platform.dev.local\src\Project\Careers\code\web.config.xdt /property:FileToTransform=web.config /target:ApplyTransform /toolsversion:15.0 /verbosity:minimal C:\Projects\Platform.dev.local\scripts\applytransform.targets
stop-service solr6
get-childitem -path c:\Solr\6.6.2\server\solr\Platform*\Data -recurse | remove-item -force -recurse
start-service solr6
Restart-WebAppPool platform.dev.local
@MartinMiles
MartinMiles / UploadFTP-File.ps1
Created April 1, 2019 19:10
Uploads local file to remote FTP from PowerShell
$File = "c:\Projects\output.zip"
$ftp = "ftp://erad-test-sitecore-615907-single\eradFTP:[email protected]/site/deployments/output.zip"
"ftp url: $ftp"
$webclient = New-Object System.Net.WebClient
#$uri = New-Object System.Uri($ftp)
$uri = [uri]::EscapeUriString($ftp)
(Get-Content Web.config).replace('<add key="role:define" value="ContentDelivery" />', '<add key="role:define" value="ContentDelivery" /><add key="localenv:define" value="PreProd" />') | Set-Content Web.config
@MartinMiles
MartinMiles / Test-SQL.ps1
Last active April 1, 2019 17:51
PowerShell
Invoke-Sqlcmd -ServerInstance "." `
-Username "sa" `
-Password "SA_PASSWORD" `
-Query "SELECT GETDATE() AS TimeOfQuery"