Blog Posts

#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

SQLSaturday Lisbon 2016

SQLSaturday #485 Lisbon 2016, held on February 20, was my third SQLSaturday event and my first as speaker. When  I received the email saying that my session had been accepted in schedule’s event I felt happy and honored.     My session, Road to database automation, was accepted as lightning talk. So I had 10 minutes to address the first stage of the database automation: database source control and it´s benefits. During that time I presented the reasons that lead me to

Continue Reading

Database Source Control – How?

In this post I describe some decision that you need to make when putting your database development under source control. “Commit a SQL script to a local repository and the push to a central repository” sounds easy. In fact the all process should be easy. The SQL script is the fundamental resource of the database source control process. The script can represent two perspectives: The desired definition of the database object (table, view, stored procedure, function…), a.k.a state-based approach; The desired

Continue Reading

Database Source Control – Why?

Nowadays the question “Why put database under source control?” no longer makes sense. Probably “How to put database under source control?” is now the correct question. But before answering the second question let me answer the first identifying the reasons that led me/us team to invest on database source control:   Is the first step of database automation In other words, if you want to assemble a database deployment pipeline you should put your database changes into a source control system; Keep

Continue Reading

Site Footer