Why SQL Unit Testing Matters

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.