Lee Brownhill
@leebrownhill.bsky.social
Avid reader and full-time coffee drinker
I recently joined Steve Jones on the @redgate-software.bsky.social Simple Talks Podcast and had a blast.
Topics covered include:
• The data community
• Blog writing
• Working in the cloud
Thanks for having me, Steve!
youtu.be/cWlLbjsgCwc?...
Topics covered include:
• The data community
• Blog writing
• Working in the cloud
Thanks for having me, Steve!
youtu.be/cWlLbjsgCwc?...
Simple Talk Podcast – Coffee Chat with Lee Brownhill
YouTube video by Redgate Software
youtu.be
October 23, 2025 at 4:24 PM
I recently joined Steve Jones on the @redgate-software.bsky.social Simple Talks Podcast and had a blast.
Topics covered include:
• The data community
• Blog writing
• Working in the cloud
Thanks for having me, Steve!
youtu.be/cWlLbjsgCwc?...
Topics covered include:
• The data community
• Blog writing
• Working in the cloud
Thanks for having me, Steve!
youtu.be/cWlLbjsgCwc?...
New blog post!
In a bid to learn the new features within SQL 2025, today's blog post covers the SQL 2025 feature – OPTIMIZED_SP_EXECUTESQL.
We walk through a straightforward demo to highlight how this feature can reduce plan cache bloat.
#sql #sql2025
www.leebrownhill.com/posts/13_sql...
In a bid to learn the new features within SQL 2025, today's blog post covers the SQL 2025 feature – OPTIMIZED_SP_EXECUTESQL.
We walk through a straightforward demo to highlight how this feature can reduce plan cache bloat.
#sql #sql2025
www.leebrownhill.com/posts/13_sql...
Learning SQL Server 2025: Optimized sp_executesql
Explore SQL Server 2025’s OPTIMIZED_SP_EXECUTESQL feature with a hands-on demo showing how it reduces plan cache bloat and boosts query performance.
www.leebrownhill.com
October 2, 2025 at 6:03 AM
New blog post!
In a bid to learn the new features within SQL 2025, today's blog post covers the SQL 2025 feature – OPTIMIZED_SP_EXECUTESQL.
We walk through a straightforward demo to highlight how this feature can reduce plan cache bloat.
#sql #sql2025
www.leebrownhill.com/posts/13_sql...
In a bid to learn the new features within SQL 2025, today's blog post covers the SQL 2025 feature – OPTIMIZED_SP_EXECUTESQL.
We walk through a straightforward demo to highlight how this feature can reduce plan cache bloat.
#sql #sql2025
www.leebrownhill.com/posts/13_sql...
Parameter Sniffing in SQL Server? I'm here to help!
In my last post, I shared a simple demo showing how parameter sniffing can lead to inconsistent performance.
This follow-up explores practical solutions I’ve seen work.
#SQLServer #QueryTuning
www.leebrownhill.com/posts/12_sol...
In my last post, I shared a simple demo showing how parameter sniffing can lead to inconsistent performance.
This follow-up explores practical solutions I’ve seen work.
#SQLServer #QueryTuning
www.leebrownhill.com/posts/12_sol...
Parameter Sniffing: Practical Fixes That Work
Struggling with parameter sniffing in SQL Server? This guide explains simple, effective fixes using built-in tools and features
www.leebrownhill.com
July 7, 2025 at 6:48 AM
Parameter Sniffing in SQL Server? I'm here to help!
In my last post, I shared a simple demo showing how parameter sniffing can lead to inconsistent performance.
This follow-up explores practical solutions I’ve seen work.
#SQLServer #QueryTuning
www.leebrownhill.com/posts/12_sol...
In my last post, I shared a simple demo showing how parameter sniffing can lead to inconsistent performance.
This follow-up explores practical solutions I’ve seen work.
#SQLServer #QueryTuning
www.leebrownhill.com/posts/12_sol...
New Blog Post! 🎺
Ever had a SQL query run fine one day, then crawl the next?
You might be facing Parameter Sensitivity.
In my latest post, I walk through a real world scenario where a procedure went from quick to 31M reads.
www.leebrownhill.com/posts/11_par...
#SQLServer #ParameterSniffing
Ever had a SQL query run fine one day, then crawl the next?
You might be facing Parameter Sensitivity.
In my latest post, I walk through a real world scenario where a procedure went from quick to 31M reads.
www.leebrownhill.com/posts/11_par...
#SQLServer #ParameterSniffing
Parameter Sniffing: A Simple Example
Explore how SQL Servers parameter sensitivity can impact performance, with a clear demo showing plan reuse pitfalls and practical insights.
www.leebrownhill.com
July 1, 2025 at 5:34 AM
New Blog Post! 🎺
Ever had a SQL query run fine one day, then crawl the next?
You might be facing Parameter Sensitivity.
In my latest post, I walk through a real world scenario where a procedure went from quick to 31M reads.
www.leebrownhill.com/posts/11_par...
#SQLServer #ParameterSniffing
Ever had a SQL query run fine one day, then crawl the next?
You might be facing Parameter Sensitivity.
In my latest post, I walk through a real world scenario where a procedure went from quick to 31M reads.
www.leebrownhill.com/posts/11_par...
#SQLServer #ParameterSniffing
New Blog Post! 🎺
This year I joined the incredible SQLBits 2025 helper crew. Two days in the orange T-shirt, on my feet, and loving every minute.
Thinking of helping out next year? Do it.
#sqlbits #dataevents #volunteering
www.leebrownhill.com/posts/10_sql...
This year I joined the incredible SQLBits 2025 helper crew. Two days in the orange T-shirt, on my feet, and loving every minute.
Thinking of helping out next year? Do it.
#sqlbits #dataevents #volunteering
www.leebrownhill.com/posts/10_sql...
SQLBits 2025: Helping out and having fun
Brent Ozar, Erin Stellato & Bob Ward were highlights—but SQLBits 2025 was really about community, connection, and stepping up as a first-time volunteer.
www.leebrownhill.com
June 23, 2025 at 6:41 AM
New Blog Post! 🎺
This year I joined the incredible SQLBits 2025 helper crew. Two days in the orange T-shirt, on my feet, and loving every minute.
Thinking of helping out next year? Do it.
#sqlbits #dataevents #volunteering
www.leebrownhill.com/posts/10_sql...
This year I joined the incredible SQLBits 2025 helper crew. Two days in the orange T-shirt, on my feet, and loving every minute.
Thinking of helping out next year? Do it.
#sqlbits #dataevents #volunteering
www.leebrownhill.com/posts/10_sql...
New Blog Post! 🎺
I recently joined two fantastic data podcasts:
1️⃣ SQL_Squared with David – where we dived into all things data
2️⃣ Finding Data Friends with Jess Pomfret and Ben Weissman
Check it out:
www.leebrownhill.com/posts/9_podc...
#DataCommunity #PublicSpeaking #CareerGrowth #PodcastLife
I recently joined two fantastic data podcasts:
1️⃣ SQL_Squared with David – where we dived into all things data
2️⃣ Finding Data Friends with Jess Pomfret and Ben Weissman
Check it out:
www.leebrownhill.com/posts/9_podc...
#DataCommunity #PublicSpeaking #CareerGrowth #PodcastLife
Podcasts, Speaking, and Why I’m Doing This Now
I recently stepped outside my comfort zone by appearing on two YouTube podcasts about data. Heres why I am doing this, what I learned, and where this journey might take me next.
www.leebrownhill.com
June 17, 2025 at 6:19 AM
New Blog Post! 🎺
I recently joined two fantastic data podcasts:
1️⃣ SQL_Squared with David – where we dived into all things data
2️⃣ Finding Data Friends with Jess Pomfret and Ben Weissman
Check it out:
www.leebrownhill.com/posts/9_podc...
#DataCommunity #PublicSpeaking #CareerGrowth #PodcastLife
I recently joined two fantastic data podcasts:
1️⃣ SQL_Squared with David – where we dived into all things data
2️⃣ Finding Data Friends with Jess Pomfret and Ben Weissman
Check it out:
www.leebrownhill.com/posts/9_podc...
#DataCommunity #PublicSpeaking #CareerGrowth #PodcastLife
Automated Database Testing with Redgate SQLCop
SQLCop offers 100+ open-source tests to enhance database security and standardisation.
See my latest blog post on how to install, run and apply SQLCop to your SQL Server setup.
www.leebrownhill.com/posts/8_redg...
#SQLServer #Redgate #SQLCop #tSQLt
SQLCop offers 100+ open-source tests to enhance database security and standardisation.
See my latest blog post on how to install, run and apply SQLCop to your SQL Server setup.
www.leebrownhill.com/posts/8_redg...
#SQLServer #Redgate #SQLCop #tSQLt
Redgate SQLTest and SQLCop
SQLCop, part of Redgate SQL Test, provides over 100 tSQLt-based tests to standardise databases, enforce best practices, and detect common issues. It helps teams adopt structured SQL Server unit testin...
www.leebrownhill.com
June 11, 2025 at 6:48 AM
Automated Database Testing with Redgate SQLCop
SQLCop offers 100+ open-source tests to enhance database security and standardisation.
See my latest blog post on how to install, run and apply SQLCop to your SQL Server setup.
www.leebrownhill.com/posts/8_redg...
#SQLServer #Redgate #SQLCop #tSQLt
SQLCop offers 100+ open-source tests to enhance database security and standardisation.
See my latest blog post on how to install, run and apply SQLCop to your SQL Server setup.
www.leebrownhill.com/posts/8_redg...
#SQLServer #Redgate #SQLCop #tSQLt
New Blog Post! 🎺
Many SQL Server installs stick with defaults like Cost Threshold for Parallelism and Max Degree of Parallelism, but those defaults can quietly hurt performance.
#sqlserver #performance #cxpacket #parallelism
www.leebrownhill.com/posts/7_para...
Many SQL Server installs stick with defaults like Cost Threshold for Parallelism and Max Degree of Parallelism, but those defaults can quietly hurt performance.
#sqlserver #performance #cxpacket #parallelism
www.leebrownhill.com/posts/7_para...
Parallelism Problems within SQL Server
Understanding SQL Server parallelism and the risks of default settings — optimise queries for better performance
www.leebrownhill.com
June 3, 2025 at 6:22 AM
New Blog Post! 🎺
Many SQL Server installs stick with defaults like Cost Threshold for Parallelism and Max Degree of Parallelism, but those defaults can quietly hurt performance.
#sqlserver #performance #cxpacket #parallelism
www.leebrownhill.com/posts/7_para...
Many SQL Server installs stick with defaults like Cost Threshold for Parallelism and Max Degree of Parallelism, but those defaults can quietly hurt performance.
#sqlserver #performance #cxpacket #parallelism
www.leebrownhill.com/posts/7_para...
New Post! 🎺
In my latest post, I explain how refining SQL queries, minimising unnecessary operations, and guiding the optimiser can transform sluggish queries into efficient, scalable solutions.
Check out the full post here:
www.leebrownhill.com/posts/6_sqlo...
#sql #server #performance #tuning
In my latest post, I explain how refining SQL queries, minimising unnecessary operations, and guiding the optimiser can transform sluggish queries into efficient, scalable solutions.
Check out the full post here:
www.leebrownhill.com/posts/6_sqlo...
#sql #server #performance #tuning
SQL Server Optimisation: Why Less Is More
A blog post discussing the merits of minimising your SQL Server code to improve not only readability but also performance
www.leebrownhill.com
May 20, 2025 at 6:36 AM
New Post! 🎺
In my latest post, I explain how refining SQL queries, minimising unnecessary operations, and guiding the optimiser can transform sluggish queries into efficient, scalable solutions.
Check out the full post here:
www.leebrownhill.com/posts/6_sqlo...
#sql #server #performance #tuning
In my latest post, I explain how refining SQL queries, minimising unnecessary operations, and guiding the optimiser can transform sluggish queries into efficient, scalable solutions.
Check out the full post here:
www.leebrownhill.com/posts/6_sqlo...
#sql #server #performance #tuning