SQLSaturday #685 Porto 2017

At SQLSaturday Porto 2017 edition I was speaker and a member of the organization team of the event. From the organization perspective the event went smother than the previous year. We were happy with the improvements that we were able to made.

My presentation was about how to set a WordPress website using Azure Web Apps and a Azure Database for MySQL but the “demo gods” were not on my side, and the last demo crashed. However the interaction with the audience was quite good, they were curious about the MySQL database engine provided by Azure.

WinOps London 2017

WinOps London 2017 was my first international conference as speaker. WinOps it’s conference dedicated to DevOps in the “Windows world” and I’m proud to have been part of the event.

At the time I was excited and scared, the lineup of speakers was great: Jeffrey Snover, Steve ThairElton StonemanRob Reynolds and others. I also found two familiar faces: Alex Yates and Ed Elliott. I felt like a little kid playing with the big game with the grown ups. It was a great experience and a privilege to meet the other speakers.

About my presentation: “Deployment pipeline for databases (Azure SQL Databases, SQL Server)” my performance wasn’t brilliant (I was nervous) but the audience  was able to make questions and gave me feedback, so I was happy. Here you can find the video of my presentation here.

DevOps Lisbon June 19th 2017, Operations for databases – The agile/devops journey

In June I made the presentation “Operations for databases – the agile/devops journey” at DevOps Lisbon. This talk is the combination of the different moments of my agile journey through Scrum and Kanban and the operations scope at three different levels: database, application and infrastructure.

It was great to present to DevOps Lisbon community and I’m hoping to repeat in future.

Roadmap review and retrospective – 2017: DevOps way

2017: DevOps way


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


  • 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


  • Elastic stack (Logstash, Elastic Search, Kibana)


  • Azure Monitor
  • Datadog


  • Azure Resource Manager
  • Web Apps
  • SQL Database


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


  • 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).