Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY Data Technology Group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and Redgate Community Ambassador. His original data professional role was in database development, which quickly evolved into query tuning work that further evolved into being a DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of live site SQL Server implementations. As a Microsoft Lead Data Architect at Centric Consulting, he works with customers large, medium, and small to migrate to the cloud, make their data estate operate efficiently, and find the right tools and solutions within the Microsoft Data Platform.

Topics of Discussion:

[3:08] Matt’s career journey and overcoming a fear of public speaking.

[5:42] Changes and consistencies in working with SQL Server over the years.

[7:18] Advice on the process and tools for database change management and DevOps.

[12:29] Recommendations for database monitoring and observability.

[19:30] Specific monitoring tool recommendations and their pros and cons.

[24:04] The role of ORMs and their impact on database performance.

[30:59] Thoughts on the evolution of microservices and database architecture patterns.

[36:55] Considerations for working with small versus large database sizes.

Mentioned in this Episode:

Clear Measure Way

Architect Forum

Software Engineer Forum

Programming with Palermo — New Video Podcast! Email us at programming@palermo.net.

Clear Measure, Inc. (Sponsor)

.NET DevOps for Azure: A Developer’s Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon!

Jeffrey Palermo’s Twitter — Follow to stay informed about future events!

SQLBITS

Author Matt Gordon

Matt Gordon Microsoft Page

Matt Gordon on LinkedIn

Racing

FivecoRacing IG

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.