stevepereira

DELIMITER $$

DROP PROCEDURE IF EXISTS add_email_address_column_to_customers_table $$

-- Create the stored procedure to perform the migration
CREATE PROCEDURE add_email_address_column_to_customers_table()

BEGIN
  
  -- Add the email_address column to the customers table, if it doesn't already exist

stevepereira

Transformation stories - siloed to agiled  
Value Streams  
Logging  
Monitoring  
Tech burnout   
Project-to-Product  
DevOps and regulation  
DevOps and the monolithic/12 factor app  
Continuous delivery  
QA automation  

stevepereira

If you came here from a talk or workshop:

Please take a minute and send me some feedback here

Connect with me on LinkedIn or Twitter
Send me an email
Book a call

Get all the most current info here

Older Talks and Info:

stevepereira

CASE #1 - Changing which revision of a dependency a feature branch depends on

Current process:

cd parent-repo
git checkout master
git pull --rebase
git checkout -b feature_branch
cd gem

stevepereira

#!/usr/bin/env -e bash
# bootstrap statflo dev - curl -sSL http://j.mp/statflodev | bash
ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
brew install caskroom/cask/brew-cask
brew cask install dockertoolbox the-silver-searcher
docker-machine create dev
eval "$(docker-machine env dev)"
mkdir -p ~/statflo
git clone https://github.com/Statflo/statflo-webapp.git ~/statflo/
curl -Ls https://install.convox.com/osx.zip > /tmp/convox.zip

stevepereira

SELECT CONCAT("ALTER TABLE ", TABLE_NAME," DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;") AS ExecuteTheString
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA="99"
AND TABLE_TYPE="BASE TABLE";

stevepereira

{
  "variables":{
    "home": "{{env `HOME`}}",
    "iso": "{{ user `home` }}/Downloads/CentOS-6.3-x86_64-bin-DVD1.iso"
  }
...

stevepereira

---
# file ruby.yml
- hosts: all
  gather_facts: false
  sudo: true

  vars:
    # Where to install rbenv
    - rbenv_root: /usr/local/rbenv
    # The version of Ruby to install

stevepereira

server {
  listen   8443 default ssl;
  server_name  www.yourdomain.com;
  ssl                  on;
  ssl_certificate      /etc/nginx/conf.d/cert.pem;
  ssl_certificate_key  /etc/nginx/conf.d/cert.key;

  client_max_body_size 50M;

  error_log   /var/log/nginx/elasticsearch-errors.log;

stevepereira

---
# ^^^ YAML documents must begin with the document separator "---"
#
#### Example docblock, I like to put a descriptive comment at the top of my 
#### playbooks.
#
# Overview: Playbook to bootstrap a new host for configuration management.
# Applies to: production
# Description: 
#   Ensures that a host is configured for management with Ansible.