Update CI/CD pipeline

[Kralizek]

Take inspiration from latest versions of appveyor.yml and build.cake from:

• Repos in https://github.com/insight-architectures
• https://github.com/Kralizek/AWSSecretsManagerConfigurationExtensions
• https://github.com/Nybus-project/Nybus.Templates