Preview Mode Links will not work in preview mode

Azure DevOps Podcast

Message from Jeffrey Palermo: Howdy.  Welcome to my podcast.  I hope it helps you ship software more quickly and more reliably. Through the topics and guests, I hope your life is made easier. Let me know what topics would be helpful for you.

Podcast sponsor: Clear Measure We are a software architecture company that empowers our client's development teams to be self-sufficient: moving fast, delivering quality, and running their systems with confidence.

Jul 22, 2019

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

Kendra Little (LinkedIn)


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.