sql_squared: The Data Community & Database Testing w/ Lee Brownhill

In this episode of The sql_squared Podcast, we're joined by our special guest, Lee Brownhill, for a deep dive into unit testing for databases, the importance of community, and the future of data platforms. As an expert with nearly 20 years of experience as a DBA and cloud consultant , Lee shares his unique insights on implementing the T-SQLT framework to create robust SQL unit tests. This conversation is centered around our guest's experiences and knowledge.

Guest Information

Name: Lee Brownhill
Bio: Lee Brownhill is a seasoned data professional with nearly two decades of experience in the IT industry. Starting in general IT support, he quickly specialized in SQL Server, moving from a production DBA to a hybrid developer-DBA role focused on scaling applications for enterprise customers. Now, as a DBA Consultant, he helps clients optimize their data workloads in Azure and AWS. Lee is also a Redgate Community Ambassador and a passionate advocate for community involvement and continuous learning.
LinkedIn: https://www.linkedin.com/in/leebrownhill/
Blog: https://www.leebrownhill.com/

Support the show!
Enjoying The sql_squared Podcast? The best way to support us is by subscribing to our YouTube channel!
- Watch & Subscribe on YouTube
- Listen on other platforms: Apple Podcasts | Spotify
- Leave a Review: If you found this episode helpful, please leave a 5-star review wherever you get your podcasts or leave a like and comment on YouTube.
- Share: Know someone who would love this episode? Go ahead and share a link!
The sql_squared podcast is your guide to navigating the ever-evolving world of data. We go beyond the code to explore the tools, techniques, and trends that shape the data landscape, from SQL Server and cloud platforms to AI and developer productivity. Join us as we chat with experts from the community to help you learn, grow, and make the right decisions on your data journey.
- Website: https://www.sqlsquared.co.uk/
- Twitter/X: @sql_squared
- LinkedIn: @sql_squared
- Email: mailbag@sqlsquared.co.uk

00:00:09 - Experiences with the Finding Data Friends Podcast
00:03:46 - A Career Forged in Data
00:08:21 - Consulting in the Cloud
00:10:56 - The Continuous Learning Mindset
00:14:00 - Introduction to T-SQLT
00:21:43 - Overcoming Challenges in Adopting Unit Tests
00:26:34 - Redgate, Community, and Code Coverage
00:31:31 - Giving Back as a SQLBits Helper
00:35:48 - The Balance Between Innovation and Delivery
00:44:08 - The Future of Data Platforms

Resources Mentioned

T-SQLT Framework: https://tSQLt.org/ - The open-source unit testing framework for SQL Server discussed in the episode.
Redgate Software: https://www.red-gate.com/ - Provider of tools like SQL Test, SQL Prompt, and SQL Monitor that aid database professionals.
SQLBits: https://sqlbits.com/ - The data platform conference where Lee will be volunteering.
Finding Data Friends Podcast: https://www.youtube.com/@findingdatafriends - A community-focused podcast where both David and Lee have been guests.
Redgate's Simple Talk: https://www.red-gate.com/simple-talk/

Видео sql_squared: The Data Community & Database Testing w/ Lee Brownhill канала sql_squared