Salt Lake City SQL Server User Group

Welcome to the Salt Lake City Chapter

EventDisplay

Next Meeting: Wed, May 16 2018

SLC SQL Server User Group May Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: None

May SLC SQL Meeting - IMED DOTY CR 3+4+5

Presentation by Scott Peterson and Tim Collinson

Abstract:
· Application change testing

o No more manual configuration before an application can be tested

§ Demo: Show gitlab-ci.yml or travis.yml for configuration steps.

o Consistent integration and deployment practices mean more time testing and less time configuring

§ Demo: Show speed increase as code is moved from environment to environment seamlessly.

o Automated testing suites run every time so that QA can focus on human testing strengths

§ Demo: Show automation test suites and coverage statistics and talk about human testing elements.

· Database change testing

o Consistent ability to deploy schema changes

§ Demo: Explain and show schema change best practices like Rails migrations.

o A clear integration and deployment path from Developer machine to production environment

§ Demo: Show roll back technique and importance of being in a database consistent state.

o Automated testing of schema changes before QA completes other testing types

§ Demo: Show how schema changes can be tested using automation and auto generation of known good datasets.

· Environment configuration change testing

o Configuration as code means configuration is testable

§ Demo: Show docker file setup. Also show docker compose for local and remote environment creation.

o Environment consistency is the same for testing on developer or QA machine as well as all environments

§ Demo: Show how testing is much more reliable because of consistent environments. Show how production can be tested without taking down production.

o Environment creation as part of automated testing suite

§ Demo: Automated environment spin up and tear down for integration testing.

· Conclusion: All of this is possible even in existing environments

o Iterative approach is important, even small changes have large impact

o Approach is language and environment agnostic

o Simple steps to take tomorrow to help you start on the path

Bio:
Scott Peterson: More than a decade ago Scott Peterson changed careers, coming into technology and engineering from a long and varied path. Since establishing his career in engineering Scott has worked with the LDS Church, Hewlett Packard, and as a consultant for numerous other organizations. He specializes in the areas of highly distributed systems and DevOps which he learned while working with Pivotal Labs and HP Labs. He has spoken at a number of conference, meet ups, and companies about Extreme Programming Agile principles and how they can be applied to highly distributed systems and DevOps. Scott is married and has 3 young rambunctious boys as well as two dogs. One of his dogs is the size of a horse.

Tim Collinson: Tim has worked in the software industry for two decades now and has gained a breadth and depth knowledge about many things pertaining to a plethora of areas. Starting as a QA Engineer and learning in depth about how to properly regress a site and working his way through many jobs in the industry including Software Engineer, Lead Engineer, Consulting Engineer and Development Manager roles. Tim is a published author of articles in the prestigious Cutter Consortium and has written popular articles on Agile Development, DevOps and other principles. He has addressed audiences at many conferences on topics such as Test Driven Development, Agile Development, DevOps and much more. He has worked for large corporations such as Hewlett Packard with their HP Labs Division and has worked for small companies to make their dreams a reality. He has pushed companies to implement the proper practices to enabled them to push code to production so that they can realize profit quickly and often. Tim is married and is the proud father of 6 kids and one ankle biter dog.

When

iCal
UTC : Wed, May 16 2018 21:00 - 23:00
Event Time : Wed, May 16 2018 15:00 - 17:00 Mountain Daylight Time
Your Local Time: Wed, May 16 2018 21:00 - 23:00

Where

Doty Family Education Center
Murray, Utah

Featured Presentation

Application change testing

Speaker: Scott Peterson

Summary: May SLC SQL Meeting - IMED DOTY CR 3+4+5 Presentation by Scott Peterson and Tim Collinson Abstract: · Application change testing o No more manual configuration before an application can be tested § Demo: Show gitlab-ci.yml or travis.yml for configuration steps. o Consistent integration and deployment practices mean more time testing and less time configuring § Demo: Show speed increase as code is moved from environment to environment seamlessly. o Automated testing suites run every time so that QA can focus on human testing strengths § Demo: Show automation test suites and coverage statistics and talk about human testing elements. · Database change testing o Consistent ability to deploy schema changes § Demo: Explain and show schema change best practices like Rails migrations. o A clear integration and deployment path from Developer machine to production environment § Demo: Show roll back technique and importance of being in a database consistent state. o Automated testing of schema changes before QA completes other testing types § Demo: Show how schema changes can be tested using automation and auto generation of known good datasets. · Environment configuration change testing o Configuration as code means configuration is testable § Demo: Show docker file setup. Also show docker compose for local and remote environment creation. o Environment consistency is the same for testing on developer or QA machine as well as all environments § Demo: Show how testing is much more reliable because of consistent environments. Show how production can be tested without taking down production. o Environment creation as part of automated testing suite § Demo: Automated environment spin up and tear down for integration testing. · Conclusion: All of this is possible even in existing environments o Iterative approach is important, even small changes have large impact o Approach is language and environment agnostic o Simple steps to take tomorrow to help you start on the path Bio: Scott Peterson: More than a decade ago Scott Peterson changed careers, coming into technology and engineering from a long and varied path. Since establishing his career in engineering Scott has worked with the LDS Church, Hewlett Packard, and as a consultant for numerous other organizations. He specializes in the areas of highly distributed systems and DevOps which he learned while working with Pivotal Labs and HP Labs. He has spoken at a number of conference, meet ups, and companies about Extreme Programming Agile principles and how they can be applied to highly distributed systems and DevOps. Scott is married and has 3 young rambunctious boys as well as two dogs. One of his dogs is the size of a horse. Tim Collinson: Tim has worked in the software industry for two decades now and has gained a breadth and depth knowledge about many things pertaining to a plethora of areas. Starting as a QA Engineer and learning in depth about how to properly regress a site and working his way through many jobs in the industry including Software Engineer, Lead Engineer, Consulting Engineer and Development Manager roles. Tim is a published author of articles in the prestigious Cutter Consortium and has written popular articles on Agile Development, DevOps and other principles. He has addressed audiences at many conferences on topics such as Test Driven Development, Agile Development, DevOps and much more. He has worked for large corporations such as Hewlett Packard with their HP Labs Division and has worked for small companies to make their dreams a reality. He has pushed companies to implement the proper practices to enabled them to push code to production so that they can realize profit quickly and often. Tim is married and is the proud father of 6 kids and one ankle biter dog.

About Scott : Scott Peterson: More than a decade ago Scott Peterson changed careers, coming into technology and engineering from a long and varied path. Since establishing his career in engineering Scott has worked with the LDS Church, Hewlett Packard, and as a consultant for numerous other organizations. He specializes in the areas of highly distributed systems and DevOps which he learned while working with Pivotal Labs and HP Labs. He has spoken at a number of conference, meet ups, and companies about Extreme Programming Agile principles and how they can be applied to highly distributed systems and DevOps. Scott is married and has 3 young rambunctious boys as well as two dogs. One of his dogs is the size of a horse.

Announcements

PASSChapterLogo.jpg

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids