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, …
Blog Posts
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 …
The workshop “Agile, Scrum and DevOps – Let’s Play with LEGO” is part of TugaIT 2017 conference schedule and will happen at May 18th. TugaIT 2017 is one the greatest Portuguese IT conference and will happen between May 18th and 20th – 3 days with sessions and workshops to provide the highest possible quality training and knowledge to the community, on a variety of topics. My friend and agile coach Nuno Rafael Gomes (@nrgomes) challenged me to take his original …
Introduction to WordPress My first wordpress post: SQLSaturday#429 Porto 2015 experience Recovering an old post: Arduino Christmas Lights My first Porto.Data presentation: XIV Porto.Data 15 December 2015 In the end of 2015 I decided to create this blog with the purpose of documenting and sharing the acquired knowledge during my professional and personal journal. Writing what I learn is a good habit and helps me to structure my knowledge. Plus, is good to share with more people and even better get some feedback …
TugaIT is one the the greatest IT conferences that happens in Portugal. The TugaIT 2017 edition will happen between 18 and 20 of May in Lisbon (Microsoft HQ). This 3 day conference includes workshops and talks and the following tracks: Azure Infrastructure, Agile & DevOps, Integration, Microsoft Data Platform, Office 365, Open Source Data Platform, PowerShell, Professional Development, Programming, SharePoint. As a member of DevOps Porto I’m proud to represent one of the participating communities of TugaIT 2017. As a member …
One of the reasons for adopting Flyway command-line was the easy setup process (no need to install). First, I will show how to setup Flyway for a single database, i.e., as if have only one database in your server, and than the setup for multiple databases in a server. Single database You can download Flyway command-line here. After download and extract you have the following folders/files structure: In this case it’s only necessary to work the “flyway.conf” file (you can …