Send us a text

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.

Listeners will walk away with a deeper understanding of how to get started with T-SQLT , practical tips for overcoming resistance to testing from development teams and leadership , and a fresh perspective on the value of continuous learning and giving back to the data community. This is a can't-miss episode for anyone interested in SQL Server development, improving code quality, and growing their career in the data space.

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/

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-ga

Support the show

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

Welcome back to SQL Squared! In this episode, host David Morgan-Gumm is joined by Tonie Huizer, a respected Database DevOps expert, known for his blog posts for Redgate and his speaking engagements globally.

Tonie, head of the Microsoft-focused consultancy ProMicro in the Netherlands, shares his journey into the data field. The conversation dives into his involvement with the recent SQL.NL event, aiming to recapture the SQL Saturday focus on SQL Server, and his podcasts, including The Tony and Tony Show which highlights Redgate articles.

The core of the episode explores Database DevOps. Tonie identifies 'People' as the biggest challenge in implementing DevOps, referencing Donovan Brown's definition focusing on people, processes, and products. He discusses common misconceptions, particularly the need to view database code (T-SQL) as code that requires source control, similar to software development, and the importance of a mindset shift away from direct production modifications.

The episode also touches upon Tonie's experiences with writing and speaking, offering advice for aspiring technical speakers. He shares a common mistake he has learned from: going over time during presentations. In a lighter moment, Tonie reveals his favourite food to make is lasagna from scratch.

The key takeaway from the discussion is the paramount importance of 'People' in technology and DevOps.

Connect with Tonie Huizer on LinkedIn or check his GitHub for code examples.

Find more about this episode, including relevant links, in the blog post at sqlsquared.co.uk.

If you enjoyed this chat, please like, subscribe, and leave a review to help support the podcast.

Website: www.sqlsquared.co.ukPlaylist: https://www.youtube.com/watch?v=PZCkMmqNuVc&list=PLmGdyAdQaW1xpMITxO5YiQ_WpRlRDO0SX

Get in touch: mailbag@sqlsquared.co.uk

Support the show

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: https://www.youtube.com/@sql_squared
• 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!

About The sql_squared Podcast

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.

Connect With Us

• Website: https://www.sqlsquared.co.uk/
• Twitter/X: @sql_squared
• LinkedIn: @sql_squared
• Email: mailbag@sqlsquared.co.uk

Website: www.sqlsquared.co.uk
Playlist: https://www.youtube.com/watch?v=PZCkMmqNuVc&list=PLmGdyAdQaW1xpMITxO5YiQ_WpRlRDO0SX
Blog: https://www.sqlsquared.co.uk/blog/the-blog-1/sql-squared-podcast-ep-2-the-usage-of-data-in-web-applications-2

Episode 2 has been a long time coming and this is one that the more junior among you might find useful! In this episode I talk to Matthew Williams, an inspiring web developer for Vita Group who has a hunger to learn more about the tech that surrounds his roll.

We talk about the usage of data in web based architectures, when to use SQL or NoSQL and how to keep it secure.

Discussion Topics:
- Development Bootcamps
- Most Interesting Projects
- Data TECH
- Data Security

Support the show

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: https://www.youtube.com/@sql_squared
• 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!

About The sql_squared Podcast

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.

Connect With Us

• Website: https://www.sqlsquared.co.uk/
• Twitter/X: @sql_squared
• LinkedIn: @sql_squared
• Email: mailbag@sqlsquared.co.uk