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:
Want to Learn More?
Visit AzureDevOps.Show for show notes and additional episodes.
Popular Podcasts
Stuff You Should Know
If you've ever wanted to know about champagne, satanism, the Stonewall Uprising, chaos theory, LSD, El Nino, true crime and Rosa Parks, then look no further. Josh and Chuck have you covered.
Las Culturistas with Matt Rogers and Bowen Yang
Ding dong! Join your culture consultants, Matt Rogers and Bowen Yang, on an unforgettable journey into the beating heart of CULTURE. Alongside sizzling special guests, they GET INTO the hottest pop-culture moments of the day and the formative cultural experiences that turned them into Culturistas. Produced by the Big Money Players Network and iHeartRadio.
Dateline NBC
Current and classic episodes, featuring compelling true-crime mysteries, powerful documentaries and in-depth investigations. Follow now to get the latest episodes of Dateline NBC completely free, or subscribe to Dateline Premium for ad-free listening and exclusive bonus content: DatelinePremium.com