In July at Porto.Data community I made a presentation about the deployment pipeline for Azure SQL databases.
Blog Posts
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.
In March 2017 I made the presentation “Delivering changes for databases and applications” especially focusing Azure platform.
This was my second time as a speaker at SQLSaturday Lisbon and this time the session was about “Delivering changes for databases and applications”. As usual was a well organized event, a great experience.
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, …
Source Control Mercurial (TortoiseHg) vs Git (SourceTree) Flyway Redgate (Source Control, DLM Automation Suite) ReadyRoll Continuous Integration Jenkins TFS Build vNext (2015) Database unit/integration tests tSQLt DbFit Continuous Delivery Octopus Deploy TFS Release Management (2015) Infrastruture as Code Chef Puppet Powershell DSC Azure Resource Manager During 2016 the main focus around DevOps was the its definition. My DevOps definition was built around databases operations and development (hence the title “DbOps”). The plan was to cover the 3 stages of the …
Scrum Gathering Portugal was my last event of 2016. My good friend Miguel Alho (@MytyMyky) and I delivered the workshop “DevOps: delivering changes for applications and databases”. The purpose was to explore the key technical (and cultural) aspects of creating a continuous delivery pipeline, from code inception to getting the conde into production. We created so much and so good material that we hope we can repeat this experience/workshop in the future.
24HOP Portuguese is a online event that is organized and executed by PASS together with Portuguese and Brazilian SQL Server communities a and with the support of Global Portuguese Virtual Chapter. The event had 24 sessions in Portuguese about Microsoft data platform. My session was about state vs migrations approach for database source control.
This was my second SQLSaturday Porto as member of the organization team and my first time as speaker. After the stressful initial preparation: conference rooms, speakers room, check-in area, networking/coffee break area and all the other logistic details, I presented my session about source control for database. The feeling and the feedback from attendees and speakers about the event organization was globally positive. The same thing can be said about my talk. You can find the slides here:
This was the first SQLPort event held in Aveiro. I was invited by Niko Neugebauer to deliver a session and I chose to explore the topic migrations-based approach vs state-based approach for database source control. The purpose of my talk was to let audience know about the two existing approaches to start with source control at database level. After presenting the advantages and disadvantages of each approach I promoted a discussion with the participants so they could understand how, where …