DevOps

• DevOps as Code
• Pipeline – the ultimate cultural tool
• Delivering changes for databases (including databases in the DevOps routine)

Database

• Data masking
• Data generation

Source Control

• Redgate SQL Source Control
• Migrations vs State

Continuous Integration

• Jenkins 2
• TeamCity
• Travis CI
• VSTS Build

Continuous Delivery

• Octopus Deploy (@ Linux)
• VSTS Release Management

Configuration Management

• Puppet

Logging

• Elastic stack (Logstash, Elastic Search, Kibana)

Monitoring

• Azure Monitor
• Datadog

Azure

• Azure Resource Manager
• Web Apps
• SQL Database

AWS

• The basics – resources creation, configuration, management
• CloudFormation

Redgate

• SQL Source Control
• DLM Automation
• DLM Dashboard
• SQL Clone
• SQL Monitor

Looking at this roadmap and thinking about what I was able to do, the first improvement is: making smaller roadmaps, I need to be more focused on the covered subjects.

• DevOps
  • This year the discussion around DevOps was about it’s implementation (“how to get Devops!?”).
  • I dedicated lot of time and effort talking and writing about the deployment pipeline as a cultural and technical organization tool.
  • The same happen with the how and the why database changes should be included in deployment pipeline together with application development.
• Database
  • Data masking – topic not covered (but since in 2018 GDPR is arriving I will comeback to this topic).
  • Data generation – topic not covered.
• Continuous Integration
  • Gained a good knowledge and experience using TeamCity.
  • Continued to deepen my VSTS build knowledge.
  • Made the first approach to TravisCI and AppVeyor.
• Configuration Management
  • Made a good introduction in the use of Puppet.
• Logging
  • Created the ELK stack – single node and cluster.
• Monitoring
  • Gained a good knowledge about Azure Monitor, Applications Insights.
  • Made an introduction to Datadog and NewRelic.
• Azure
  • Deepened my Azure knowledge (PaaS approach)
• AWS
  • Made the introduction to AWS and CloudFormation.
  • I’m now able to make a basic comparison between the two cloud providers.
• Redgate
  • Topic not covered

At professional level it was a good adaptation year working at Basecone (different cultures, different way of working).

As a speaker I made my first international experience in WinOps London conference.

And in my personal life my family just got bigger – my son Vasco born in the summer (June 3rd).