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.
Tag: DbOps
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 …
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 …
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 …
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 …
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 …
The first question I thought was: if applications development includes “by default” concepts as source control, continuous integration and continuous delivery, why not database development? As Len Bass said in a conference: “A script is just a program”. All database changes can be scripted, so what is so special about databases? The answer is simple: data, specifically data persistence. One of my favorite answers was given by Grant Fritchey: “Deploying databases has the inherent problem of retaining the data after the …
Last Tuesday (15 December 2015) I made my first presentation in Porto.Data community. “Road to database automation” was the title and the this session had two main goals: discuss the challenges of database inclusion in the Application Lifecycle Management (ALM) and present a set of strategies and tools to achieve this inclusion. The effort of database inclusion in the “agile context” is designated as Database Lifecycle Management (DLM) and is composed by 3 main parts: database source control, database continuous …