loader from loading.io

Lee Brownhill: The Data Community - Episode 373

Azure & DevOps Podcast

Release Date: 10/27/2025

Carola Lilienthal and Henning Schwentner: Domain-Driven Transformation - Episode 384 show art Carola Lilienthal and Henning Schwentner: Domain-Driven Transformation - Episode 384

Azure & DevOps Podcast

Carola Lilienthal is an architect and coach at Workplace Solutions. She is the author of Sustainable Software Architecture and shares her knowledge at international conferences. Henning Schwentner is a software architect, coach, and consultant at WPS – Workplace Solutions where he helps teams modernize legacy systems. He is a thought leader in DDD and software architecture, and he has also authored Domain Storytelling.     Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

info_outline
AD 2025 - The Year of AI-Driven Development – Looking Ahead to 2026 - Episode 383 show art AD 2025 - The Year of AI-Driven Development – Looking Ahead to 2026 - Episode 383

Azure & DevOps Podcast

Today I'm going to reflect back on 2025, highlight some things and project forward into 2026. I think there are some very important developments and changes that we all shipping custom software need to be on top of. Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

info_outline
Scott Hanselman: The Future of Software Engineering - Episode 382 show art Scott Hanselman: The Future of Software Engineering - Episode 382

Azure & DevOps Podcast

Scott Hanselman is a teacher at heart. He speaks all over to whoever will listen. He's have written code that you, dear listener, has used. Scott has been blogging, coding, and podcasting a LONG time. He codes, writes, speaks, empowers, promotes, braids, learns and listens - usually not in that order. And he's a Vice President at Microsoft in his day job focusing on Developer Community. You can find him on YouTube, TikTok, Instagram, and Mastodon! His Hanselminutes podcast has surpassed 900 episodes, and his Azure Friday show, over 750 episodes. Connect with him at hanselman.com Mentioned in...

info_outline
Glenn Condron: Aspire Strategy for .NET - Episode 381 show art Glenn Condron: Aspire Strategy for .NET - Episode 381

Azure & DevOps Podcast

Glenn is a Principal Product Manager for the App Platform team within the Developer Division at Microsoft, focusing on .NET. Before joining Microsoft Glenn was a developer in Australia where he worked on software for various government departments.   Mentioned in this Episode     Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

info_outline
Jared Parsons: The Latest with C# - Episode 380 show art Jared Parsons: The Latest with C# - Episode 380

Azure & DevOps Podcast

Jared Parsons is a Developer Manager for the .NET Tools team at Microsoft. He's also done extensive work on the C# Compiler Team. Everybody tuning in probably uses his code on a day-to-day basis! Jared started out at Microsoft over 20 years ago as a Developer; moved on to become a Senior Developer; then Principal Developer on Midori OS; and most recently, the Principal Developer on C# Compiler Team, and now a Developer Manager. He's spoken at many conferences, like Microsoft Build and others. Mentioned in this Episode           Want to Learn More? Visit...

info_outline
Chris Wilke: Generated AI Stories - Episode 379 show art Chris Wilke: Generated AI Stories - Episode 379

Azure & DevOps Podcast

Chris has 25 years experience as a seasoned SaaS and AI product leader known for practical, people-first strategies to harness value from Generative AI for operational excellence. Chris developed the AI Vantage framework—a strategic approach that emphasizes process-driven transformation to unlock immediate and long-term value from GenAI technologies. He works for Viewport as the Head of Technology and is a respected voice in the AI and product management space, frequently sharing insights through training, blogs, and speaking engagements. Chris holds certifications in SAFe Product Ownership...

info_outline
Alvin Ashcraft: Community Conferences - Episode 378 show art Alvin Ashcraft: Community Conferences - Episode 378

Azure & DevOps Podcast

Alvin is a senior content developer at Microsoft, author, and longtime leader in the .NET developer community. With over 27 years of experience in software development, Alvin has been recognized as a Microsoft MVP for more than a decade, honored for his contributions to Windows development, Visual Studio, and the broader Microsoft ecosystem. He is currently writing docs for multiple Microsoft technologies. In 2021, Alvin wrote a book for Packt Publishing, Learn WinUI 3.0. This is the first book Alvin authored and has been the technical reviewer for eight other .NET-related titles from Packt....

info_outline
Dan Clarke: Personal Productivity - Episode 377 show art Dan Clarke: Personal Productivity - Episode 377

Azure & DevOps Podcast

Dan Clarke is a seasoned software consultant, Microsoft MVP, and founder of Everstack Ltd. Dan is widely known for his contributions to the .NET ecosystem and hosts the Unhandled Exception Podcast.  With a background in DevOps, Azure, and developer tooling, Dan brings a thoughtful, systems-level perspective to software craftsmanship. His work spans technical education, community leadership, and content creation—from blog posts and newsletters to YouTube tutorials and conference talks.  Dan resides in the UK and when he isn't programming, he enjoys daily weightlifting, playing the...

info_outline
Andrew Lock: Testing Frameworks - Episode 376 show art Andrew Lock: Testing Frameworks - Episode 376

Azure & DevOps Podcast

Andrew Lock is a staff software engineer at Datadog and educator whose contributions to the .NET ecosystem have shaped how developers approach modern web applications.  Located in the UK, Andrew is a Microsoft MVP, Author of , and has an active blog all about his experience working with .NET and ASP.NET Core.   Topics of Discussion: [2:56] Andrew talks about appreciating the joy of coding and the minutiae of figuring out the correct way to do things. [3:28] Andrew discusses the various testing frameworks available for .NET, including MS Test, NUnit, XUnit, and TUnit. He explains the...

info_outline
Ben Day: SlideSpeaker.AI - Episode 375 show art Ben Day: SlideSpeaker.AI - Episode 375

Azure & DevOps Podcast

Ben Day is a seasoned software consultant and fractional CTO. With over two decades of experience, he brings a blend of hands-on coding expertise, strategic clarity, and people-focused coaching to help companies — from startups to Fortune 500s — deliver high-quality software faster and with less friction.   As the founder of Benjamin Day Consulting, Inc., Ben offers training, coaching, and architectural guidance rooted in Agile, Scrum, Azure DevOps, and GitHub best practices. He’s a Microsoft MVP, a certified Professional Scrum Trainer for over 15 years, and a sought-after speaker...

info_outline
 
More Episodes

 

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.