PSSUG 10/2021: Automate! Use GitHub Actions to Build and Test DB Projects

-->> This Is an ONLINE-Only Event <<--

IMPORTANT:

The meeting will be held on Zoom. The information you need to join will be sent out a few hours before the event. However, we recommend downloading and installing the app now.

(https://zoom.us/download)

Agenda 

Abstract: 

Automate! Use GitHub Actions to Build and Test Database Projects

Unit Testing is a great way to make hunting down defects and implementing new features faster and easier. But it is an investment, and for that investment to pay off, you need to take the extra step and automatically run all unit tests on newly committed code, before it is moved to downstream environments. This is commonly referred to as Continuous Integration (or CI) and one way to set it up is to use GitHub Actions.

Attend this session by the maintainers of the open-source database unit testing framework tSQLt and learn how to use GitHub Actions to build your database projects, spin up brand new SQL Servers on the fly, deploy those database projects to these new environments, and then run the tests - all automatically for all your commits.

After attending you’ll not only know where Continuous Integration fits into the lifecycle of your projects, you’ll also have the tools needed to set up your own CI environment to support your and your team’s database unit testing efforts.

Speakers:

Liz Baron

Liz Baron has successfully introduced DevOps practices into Data Platform teams, leading efforts that resulted in a 90% reduction in defects. She is a partner at sqlity.net and an open-source advocate, serving as a maintainer of the tSQLt project. In addition, she works as Director in the Technology team at Cityblock, working to improve health outcomes for vulnerable communities.

Sebastian Meine, Ph.D.

Sebastian Meine, Ph.D. founded sqlity.net llc in 2010, to fully engage in his passion for SQL Server.

Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in Database DevOps and Unit Testing, SQL Server Security, and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, and coauthor & lead developer of tSQLt.