Kendra Little on Database DevOps - Episode 46

Today's guest on this week's Azure DevOps Podcast is Kendra Little, a DevOps Advocate for Redgate Software and a Microsoft Certified Master in SQL Server. She has trained IT leaders, developers, and database administrators around the world on topics including performance tuning, preventing and managing incidents with business-critical databases, and optimizing operations and the software development cycle. Kendra is also the founder of SQLWorkbooks where she creates online training videos and teaches in-person courses on SQL Server. And one last neat fact about Kendra: she has been awarded the 'Most Valuable Professional' award by Microsoft seven times!

Today Kendra and Jeffrey will be discussing database DevOps — which doesn't get much play in the sea of noise that is DevOps for web applications or backend services! It's kind of a hard topic, but it's also where a lot of the magic happens — and Kendra lives in it day-in and day-out! Tune in to get her insight on what database DevOps is, how you should be thinking about it, her views on branching and where it fits into database DevOps, what automating database deployments looks like, and what tools and resources developers should be looking at in regards to database DevOps.

Topics of Discussion:

[:36] Be sure to visit AzureDevOps.Show for past episodes and show notes!

[:47] Where to get a hold of Jeffrey's new book, .NET DevOps for Azure.

[1:26] About today's episode and guest.

[1:58] Jeffrey welcomes Kendra to the show!

[3:26] Kendra shares her background and journey in the industry of software development.

[7:22] What is database DevOps? And how should people be thinking about it?

[11:00] Where should the DBA be in the process of planning a change in the database code?

[15:05] Kendra gives her view on branching and how it fits into database DevOps.

[21:23] A word from Azure DevOps Podcast's sponsor: Clear Measure.

[21:49] Kendra describes what automating database deployments — and, if it fails and you have to rollback — looks like.

[26:37] If you do write undo scripts, where does that fit in with all the tooling?

[33:09] What tools should developers be looking at in regards to database DevOps? And what tips does Kendra have for those just getting started?

[39:02] Kendra gives her recommendations on what listeners should first follow-up on after listening to this week's episode!

Mentioned in this Episode:

Azure DevOps

Clear Measure (Sponsor) — Reach out to Jeffrey @JeffreyPalermo on Twitter if you have a user group or conference and would like some free copies of .NET DevOps for Azure!

.NET DevOps for Azure, by Jeffrey Palermo

bit.ly/dotnetdevopsproject

Kendra Little (LinkedIn)

SQLWorkbooks

Redgate Software

Redgate's SQL in the City Summit

DevOps Topologies

"The Unnecessary Evil of the Shared Development Database," by Troy Hunt

Redgate's SQL Change Automation

Redgate University

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.