Jared Poche

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

#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/…

Anyone interested can email me at sqljared@outlook.com if they can't message me directly.

If anyone in #sqlfamily needs an invite to the other place, let me know. I'm hoping the community continues going in that direction.

@erikdarlingdata "Was editing a row via Views->Create a view" But, wait. What? No!

there is so much wrong here: dba.stackexchange.com/q/331201/32281

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

@SQLBek I'd love one if there are any left.

Looks like I have some bsky invites if anyone wants to join. More and more #sqlfamily are migrating

@grrl_geek @chapmandew You have my full attention with this arcade that serves beer.

@GFritchey @SQLMCT That's pretty scary.

@SQLMCT Nah, it's mine. After frantic searches through email & slack, I've found that it's a webinar I'm just hosting (whew) and that's getting delayed to July (double whew). Still. Stone. Cold. Panic.

That moment when looking at your calendar: Who the heck put that webinar on there? What's the topic? Uhhmmmm... I don't have a presentation ready for that. Uh oh.

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

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

@erinstellato There are videos of millennials trying to use rotary phones that are hilarious.

This is...painful...

@crashdan I'd be happy to do a remote talk for a new user group.

There's some chatter about starting up the south jersey sql server chapter (SJSSUG) again but concern about speakers. Is there a good place to start besides just posting here on #sqlfamily? More details to come. Reach out to me if interested.

@ChrisHyde325 @erinstellato I had no idea...

@erinstellato There are alphabetical and categorized buttons on those pages? 😆

👋SSMS friends - how often (if ever?) do you use the alphabetical or categorized buttons on the various properties pages? Thanks for the feedback!

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

Found an issue with one of my examples, so I added an addendum and updated the conclusion. Thanks to @SQL_Kiwi for pointing out that the compatibility level in WideWorldImporters is 130 by default.

My latest blog on the Halloween Problem is up at sqljared.com/blog/halloween…. Complete with examples showing the typical protections and some performance numbers. #sqlfamily #sqlblog

@GFritchey Hence, scary dba.

Important safety tip: Don't ask me how to performance tune a query that is "SELECT * FROM dbo.MySillyTable" while live and in-person. You'll be in reach and I can't guarantee your safety. Asking online is safer because I can throw things without hurting you.

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

@SQLEspresso Motivation varies, but cute corgis are forever.

My Motivation Level Status Update. What's yours? Am I alone in this today.