Monthly Archives: October 2025

Lee Brownhill is a Principal Cloud DBA at Cloud Rede with deep expertise in SQL Server performance tuning and automation. With years of experience across Azure and AWS, Lee helps clients optimize their cloud data platforms.

His journey began in IT support, quickly evolving into a passion for SQL Server that led him through roles as a Production and Developer DBA. Now, he's a trusted consultant, known for making systems run faster and smarter.

Lee is a Redgate Community Ambassador, a regular at SQLBits and Data Relay, and once spent a transformative week learning from T-SQL legend Itzik Ben-Gan. Whether on-prem or in the cloud, Lee's mission is simple: make SQL Server shine.

Topics of Discussion:

[2:33] Lee shares his career journey, starting in general IT support and transitioning to a role involving Microsoft Dynamics NAV, which introduced him to SQL Server.

[5:48] Jeffrey discusses the challenges faced by young programmers who work with databases but lack deep experience.

[7:05] Lee highlights common anti-patterns in SQL Server.

[8:04] The concept of "row by agonizing row."

[8:46] Lee shares his thought process when addressing performance problems in SQL Server.

[9:12] Categorizing issues based on their severity and urgency using a tried-and-true checklist.

[10:36] Taking a step back to look at the issue holistically before diving into specific details.

[16:04] An optimal database structure and segmentation in 2025, and the importance of normalization to avoid redundant data and ensure data integrity.

[20:00] The different ways to host SQL Server in Azure and the benefits of each.

[23:02] Metrics for determining if an Azure SQL instance is over- or under-provisioned.

[25:02] The value of Azure's costing tools in helping to optimize resource usage and reduce costs.

[26:07] The work of site reliability engineers who use KQL to analyze logs and identify issues.

[30:09] Lee's blog is a repository of technical topics, including SQL Server, performance tuning, and unit testing.

[32:10] SQL Server 2025 features and the importance of learning and understanding new technologies.

Mentioned in this Episode:

Clear Measure Way

Architect Forum

Software Engineer Forum

Lee Brownhill's Blog

Lee Brownhill LinkedIn

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.

Download this episode (MP3, 38:41, 38.1 MB)

Watch this episode on YouTube

This episode on the AI DevOps Podcast site

Aaron Palermo is a Senior Solutions Architect, DevOps engineer, and all-around cybersecurity expert. He works for a global cybersecurity services company, Appgate. Aaron was last on the show in episode 196, sharing about Zero Trust Networking.

Topics of Discussion:

[3:20] Aaron shares his excitement for learning new things and solving innovative challenges, which keep him engaged in the field.

[3:30] Aaron explains his current role at Appgate, a zero-trust network access company.

[4:25] The importance of direct-routed solutions for federal customers who want to own and manage their infrastructure.

[6:27] Aaron recounts how he applied insights from previous ADP guests Scott Hunter, Burke Holland, and Greg Leonardo.

[7:56] He explains the process of querying the Appgate API with natural language and the insights gained from the AI agent's code generation.

[8:24] Testing an Integration in the Lab.

[11:05] Jeffrey and Aaron discuss the benefits of using open-source tools and the flexibility of Proxmox for network testing.

[14:47] VS Code and Copilot Integration, and what's next.

[19:39] Aaron introduces n8n.io as a low or no-code automation platform that integrates with AI agents and APIs for workflow orchestration.

[21:15] Integrating simple automation examples, such as weather-based watering systems and data-driven decisions without sensors.

[28:09] OpenWRT's flexibility and customization.

[30:01] What are some of the scenarios where a software-defined network might be the right tool?

[33:26] Know what you want, and write from a purpose.

Mentioned in this Episode:

Clear Measure Way

Architect Forum

Software Engineer Forum

Ep 196 with Aaron Palermo

n8n

AppGate

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.

Download this episode (MP3, 35:02, 34.6 MB)

Watch this episode on YouTube

This episode on the AI DevOps Podcast site

Jonathan Tower is known to friends and colleagues simply as "J." J. is a Microsoft MVP, Telerik Developer Expert, and the founder of Trailhead Technology Partners, a global custom software consultancy. With nearly 25 years of experience in the industry, J. has held roles ranging from senior architect to director of development, and now leads a team building high-quality, large-scale applications across a wide range of technologies.

J.'s technical expertise spans C#, .NET, ASP.NET MVC, and modern JavaScript frameworks, along with mobile app development. But what truly sets him apart is his passion for building community. He's the driving force behind Beer City Code, Michigan's largest software conference, and serves on the board of SoftwareGR, a nonprofit dedicated to growing the software industry in West Michigan.

He's also a frequent speaker at conferences and meetups around the world, a LinkedIn Learning course author, and a mentor to many through his work with robotics teams and local tech groups.

Outside of tech, J. is an adventurer at heart. He and his family recently completed a year-long road trip across the U.S., visiting 58 of the 63 national parks. He's also a fan of photography, hiking, reading, and catching every Best Picture nominee before the Oscars.

Topics of Discussion:

[3:30] Fun fact! J. has been to 58 of the 63 national parks, with his current favorite being Glacier National Park.

[4:46] J. explains his early interest in creating things and his discovery of software development in middle school.

[7:33] J.'s journey into leadership and consulting.

[11:04] J. talks about his Blue Blazes podcast and the inspiration behind the name.

[14:27] The "shiny object syndrome" and the misuse of microservices architecture.

[15:06] Understanding the true needs of a project before implementing complex solutions.

[21:20] AI should be viewed as a collaborative tool, not a replacement for team members.

[22:51] The insight that J. got at a Ford Factory about how AI can help us shape and create jobs instead of just replacing them.

[27:50] J. mentions he recently released courses on Dome Train about migrating legacy applications.

[29:05] Choosing the framework that is the most similar model.

[31:29] The type of traits that J. would look for in a lead engineer or a team leader.

Mentioned in this Episode:

Clear Measure Way

Architect Forum

Software Engineer Forum

Jonathan "J." Tower LinkedIn

JTower Website

Trailhead Technology

Jonathan "J." Tower MVP

Blue Blazes Podcast

.NET Foundation

Dome Train — Jonathan Tower

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.

Download this episode (MP3, 35:15, 33.8 MB)

Watch this episode on YouTube

This episode on the AI DevOps Podcast site

Peter Ritchie is a veteran software architect and consultant with over 35 years of experience in the tech industry. Peter is renowned for his deep expertise in .NET development, distributed systems, and agile methodologies. He's an accomplished author of several technical books, a former Microsoft MVP, and a sought-after international speaker. Peter is also actively involved in the .NET community and was a candidate for the .NET Foundation Board of Directors, reflecting his commitment to open-source and developer advocacy. Through his consulting work, he helps teams elevate their architecture, code quality, and development practices — especially in areas like ASP.NET, Clean Architecture, and CI/CD pipelines.

Topics of Discussion:

[3:45] Overview of .NET Foundation.

[5:33] Support for User Groups and .NET 10.

[5:48] The upcoming release of .NET 10 and Visual Studio 2026.

[6:39] Stability and backward compatibility.

[9:10] Challenges and approaches to business logic.

[11:24] Repository structure and team organization.

[15:27] Testing and continuous integration.

[17:12] The role of experienced developers in mentoring and reviewing the work of junior developers.

[20:02] Jeffrey mentions a recent blog post of Peter's and how we can define clear user stories, including roles, actions, criteria, and benefits, to ensure developers understand the requirements.

[24:15] The importance of context in AI-driven development and how it applies to working with people.

[25:06] How the AI revolution can lead to better understanding and communication within development teams.

Mentioned in this Episode:

Clear Measure Way

Architect Forum

Software Engineer Forum

Peter Ritchie LinkedIn

Want to Learn More?

Visit AzureDevOps.Show for show notes and additional episodes.

Download this episode (MP3, 28:05, 27.9 MB)

Watch this episode on YouTube

This episode on the AI DevOps Podcast site