Lee Brownhill: The Data Community - Episode 373

Lee Brownhill: The Data Community - Episode 373

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.

Avsnitt(386)

Maddy Montaquila: .NET Update - Episode 386

Maddy Montaquila: .NET Update - Episode 386

https://clearmeasure.com/developers/forums/ Maddy Montaquila is a Senior Product Manager on the Aspire team and has previous been on the MAUI team and has been working with .NET mobile apps since 2018 working on Xamarin tooling. When she first joined Microsoft and worked with the Xamarin team as an intern, she realized the impact that she could have in creating amazing developer tools and frameworks, which inspired her to pursue a role as Program Manager. You can connect with her on Twitter and GitHub @maddymontaquila! Mentioned in this episode: Github - Maui Maddy's Linkedin  .NET Maui  Github Maui Samples  Github - Development Guide  Episode 244  Episode 120  Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

26 Jan 47min

Graham McMillan: Database DevOps - Episode 385

Graham McMillan: Database DevOps - Episode 385

Graham is the Chief Technical Officer at Redgate Software, where he leads the teams behind industry‑leading Database DevOps tools. Before Redgate, Graham's experiences includes multiple decades in complex projects and leadership oversight at many companies including Elsevier, IBM, Sun, BEA, and Oracle. He's also a two‑time round‑the‑world yachtsman, bringing hard‑earned leadership experience from some of the most demanding environments on earth. - Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

19 Jan 36min

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

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

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. Carola's LinkedIn  Henning's LinkedIn  Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

12 Jan 35min

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

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

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.

5 Jan 12min

Scott Hanselman: The Future of Software Engineering - Episode 382

Scott Hanselman: The Future of Software Engineering - Episode 382

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 This Episode Episode 280  Scott Hanselman's TEDx Portland Talk Want to Learn More?  Visit AzureDevOps.Show for show notes and additional episodes.

29 Dec 202538min

Glenn Condron: Aspire Strategy for .NET - Episode 381

Glenn Condron: Aspire Strategy for .NET - Episode 381

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 X Account Episode 293 Episode 58  Github Microsoft Devblog  Building Cloud Native apps with .NET 8 Simplifying Cloud-Native Development with .NET 8 Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

22 Dec 202552min

Jared Parsons: The Latest with C# - Episode 380

Jared Parsons: The Latest with C# - Episode 380

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 Episode 287 Episode 53  Github - Rosyln  Github - Analyzers  Github - Csharplang  Jared's LinkedIn  Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

15 Dec 202542min

Chris Wilke: Generated AI Stories - Episode 379

Chris Wilke: Generated AI Stories - Episode 379

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 and Pragmatic Marketing, and is an alumnus of Texas A&M University. Mentioned in this Episode Chris' Website Chris' X Account Chris' LinkedIn Want to Learn More? Visit AzureDevOps.Show for show notes and additional episodes.

8 Dec 202538min

Populärt inom Politik & nyheter

p3-krim
rss-krimstad
svenska-fall
flashback-forever
rss-viva-fotboll
motiv
aftonbladet-daily
rss-sanning-konsekvens
aftonbladet-krim
rss-vad-fan-hande
rss-krimreportrarna
olyckan-inifran
grans
dagens-eko
rss-frandfors-horna
fordomspodden
spar
rss-flodet
blenda-2
politiken