Blog Posts

Roadmap review and retrospective 2015: Hello WordPress

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

Continue Reading

DevOps Porto as TugaIT 2017 participating community

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

Continue Reading

Flyway command-line easy setup

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

Continue Reading

#c9d9 Continuous Discussions, Open Source and DevOps

During my vacations in August I participated on a Continuous Discussions (#c9d9) episode about Open Source and DevOps. Continuous Discussions is a community initiative powered by Electric Cloud, and consists of a series of community panels about Agile, Continuous Delivery and Devops. This formate, a discussion panel that debates different perspectives about a specific topic, surprised me with the interaction and fun that was to make part of this event. So, well done #c9d9, I really enjoyed. Following, some insights

Continue Reading

Porto.Data 28 July 2016, Delivering changes for applications and databases

Last July at PortoData event I made my first co-presentation with my friend Miguel Alho (@MytyMyky) and the explored topic was the relationship between databases and applications in the development process. After doing some presentations about database developing process and DevOps, this presentation was the “missing link” that allows the audience to see the “big picture”. The presentation chosen title was “Delivering changes for applications and databases” and its content is the result of the shared experience by me and

Continue Reading

Agile Connect and the DevOps challenge

“How about the operations?” This was a recurring question in the conversations that I had with Nuno Rafael (@nrgomes). After several discussions about agile methodologies and his effects and challenges on the operations world I accepted his challenge to deliver a session at Agile Connect community about DevOps. I decided to give my session, made at June 29, the following title: “DbOps, DevOps and Ops” because my first contact with operations was at database level (as DBA), then I progressed to infrastructure

Continue Reading

TugaIT 2016, Road to database automation

The TugaIT 2016, May 21, was so far the biggest event that I participated was a speaker. The logistic challenge was characterized by 9 tracks, each track with 6 sessions, making a total of 64 sessions. At the end of the event two combined words remain in my mind: monstrously amazing. My participation on the TugaIT event started on the day before, Friday May 20, with the workshop “Deep walkthrough of some of the most popular/innovative features in SQL server storage engine” by

Continue Reading

Porto.Data April 20th 2016, Database source control: Migrations vs State

My second presentation at Porto.Data (April 20) was about the two approaches, migrations and state, for database source control. During the presentation I explored the advantages and disadvantages of each approach. For migrations approach I used the tool Flyway and for state approach I used Redgate SQL Source Control. Besides presenting the pros and cons of each approach my goal was also to show that two approaches can be needed in different parts of the system, or at different times

Continue Reading

Flyway: “Hello database migrations”

Flyway is a open source database migration tool that allows you to manage database changes using migrations. Last week the version 4.0.1 has been released and I decided to write my first post about Flyway. I started to use Flyway command-line almost 3 years ago (version 2.2.1) and the main reason that took me to use and keep using nowadays is: it’s simplicity, “database migrations made easy”. This key factor is translated into the following: Zero dependencies (you need java and

Continue Reading

My new friend FoRG

In February I made a new friend, I have joined the 2016 Friends of Redgate (FoRG) Program. I found Redgate and his products when I started working as DBA with special focus on database development and database changes delivery. SQL Source Control  and DLM Automation Suite are great products for this purpose. However, what really impressed me were Redgate’s people: always ready to give you support, always ready to listen your feedback. As a Friend of Redgate I have the opportunity

Continue Reading

Site Footer