My latest blog on the QDS Toolbox is up at sqljared.com/blog/qds-toolb…. These procedures make it easy to find significant changes to waits in Query Store. #sqlserver #sqlblog #querystore

Finished a foundational blog on nested loops at sqljared.com/blog/nested-lo…. Have a good weekend everyone.

My latest foundational blog on hash match joins is up at sqljared.com/blog/hash-matc….

I'm happy to be speaking at #PASSDataCommunitySummit this fall. I'll be presenting on "Maximizing Performance with Memory Optimized Table Variables", and I'm looking forward to seeing everyone in Seattle! #sqlfamily #sqlpass

Our next event is live and on Thursday, August 18th at 12 noon EST with @BefriendingDragons @ Insta & Threads: Cindy Gross called "Stepping Stones from Diversity Learning to Equitable Actions". Come join us for the must see presentation around #DEI efforts. bit.ly/3A2Rh8n

Posted my last blog, a foundational post on merge joins at sqljared.com/blog/merge-joi…. Likely to post another comparing the three join types soon. #sqlserver #sqlblog

Thanks to everyone who attended my session at #PASSDataCommunitySummit. I've updated my slides and demos, and the updated versions should be available for download shortly.

The conversations at #PASSDataCommunitySummit last week might have been the best part. Thanks to everyone in #sqlfamily for being so helpful and positive. Way too many to list.

Posted my last blog about being an introvert at #PASSDataCommunitySummit and how I approached the networking opportunities there at sqljared.com/blog/introvers…. Happy new year, #sqlfamily! #sqlblog

My latest blog on tempdb contention is up at sqljared.com/blog/tempdb-co…. I discuss improvements that minimize its effects and have several useful links on the subject. #sqlblog #sqlfamily

Posted a new blog about Manual Halloween protections and how this coding technique can allow you to skip unnecessary write operations at sqljared.com/blog/manual-ha…. #sqlfamily #sqlblog

My latest blog on Parameter Sensitive Plan Optimization in SQL Server 2022 is up at sqljared.com/blog/parameter…. My next post will be on this subject as well, discussing an issue that may affect your Query Store scripts! #sqlfamily #sqlblog

I've posted a second blog about PSP Optimization at sqljared.com/blog/variant-q…. Check it out to see why you may need to update your Query Store scripts for #SQLServer2022. #sqlfamily #sqlblog

I've posted a new blog on PSPO at sqljared.com/tag/parameter-…. This blog has links for a known issue, updates a previous script using sys.query_store_query_variant, and discusses PSPO plans with multiple variables. #sqlfamily #sqlblog

#sqlfamily, consider upvoting this feedback to add a filter for an object id\name in Query Store. This will help make variant queries from Parameter Sensitive Plan Optimization more visible and allow us to see a procedure's activity in one view. feedback.azure.com/d365community/…

This is likely my last post on this platform. I don't want to be part of what it is now. I'll keep up my previous posts, but you can find me on other social media locations like bsky going forward. #sqlfamily #sqlblog