Ugh... I've decreased a query's max duration (40s down to 17s), but the average duration has increased (3s to 8s) Now, to figure out if I should revert it back

Tired Golden Retriever Dog Looks Down

Alt: Tired Golden Retriever Dog Looks Down and sighs

static.klipy.com

A handy new script on the blog - I know I'll need this in the future, so maybe you'll find it useful too. jesspomfret.com/dbatools-azu...

Azure SQL Database - Run queries against all databases on an Azure SQL Instance

Have you ever wanted to run a query against all of the Azure SQL Databases on an instance? This is the post for you, of course, using dbatools!

jesspomfret.com

Well folks, I'm ready for Barcelona now! Got my new shoes on and Maddox... Loves them 🤣 Come and join me and @robsewell.com at @fabconeurope.bsky.social for a full day of learning. Automation, SQL, Fabric.. what more do you need? #SQLCon #SQLKicks #MicrosoftSQL #SQLCommunity #StepIntoSQLCon

T-SQL Tuesday Roundup: You Know A Query’s Gonna Be Bad When… For this month's T-SQL Tuesday, I invited y'all to tell me how you know a query's gonna be bad when you open it. Riccardo Perico and Shane O'Neill says WHILE loops and/or CURSORs are pretty good indicators. I agree, because especially…

T-SQL Tuesday Roundup: You Know A Query’s Gonna Be Bad When…

For this month's T-SQL Tuesday, I invited y'all to tell me how you know a query's gonna be bad when you open it. Riccardo Perico and Shane O'Neill says WHILE loops and/or CURSORs are pretty good indicators. I agree, because especially when you're opening code in the year 2026, and someone still hasn't figured this out (or the code hasn't been changed in decades), then you're gonna be in for a rocky road.

brentozar.com

I am truly grateful for @gilbertsanchez.com and his work and stewardship on the project to revive PSDepend. Last week I migrated 60+ internal repos to PSDepend 0.4.1 from a crusty fork. No issues, butter smooth. www.powershell.org/modules/psde... #PowerShell

PSDepend

A PowerShell dependency handler. Declare your dependencies in a .psd1 file and let Invoke-PSDepend resolve, install, import, and test them.

powershell.org

I just published a MASSIVE update to the #SQLServer Execution Plan Reference. There are 4 new pages, for operations on JSON indexes, plus an additional 15(!) pages with various updates. Check out the Change Log for a full overview. sqlserverfast.com/epr/change-l...

Tick, tock. It you want to go to Edinburgh, Scotland in October, your window is closing fast. I just submitted a couple of sessions last-minute (sorry, Abhi).

Call for Data Speakers@callfordataspeakers.com · 2mo ago

Call for speakers: Data Day Edinburgh 2026 https://sessionize.com/data-day-edinburgh-2026?utm_source=callfordataspeakers&utm_campaign=bluesky

New blog post - trying to fix the mess that Vimeo made. Please read, especially if you own any of my SQLServerFast Execution Plan Video Training videos. sqlserverfast.com/blog/hugo/20...

Vimeo messed up, and you and I get the consequences - SQLServerFast

I am furious right now. Vimeo has made a mistake, and as a result, the SQLServerFast Execution Plan Video Training is currently not available for viewing. Vimeo’s announcement Four days ago, I got a n...

sqlserverfast.com

I have no idea where this came from, but

And the same for authors and books

Performance tuning... Pros: you can really make things faster! Cons: you have to wait for the original to finish to verify the results! #sqlserver

This was a fantastic talk; I learned wonderful things about what mocking means in technical terms. Thoroughly recommend it!

nohwnd@jakubjares.com · last mo.

My #PSConfEU 2026 talk is up: a deep dive into how mocking actually works in Pester — scopes, session states, and the workarounds needed to get it to behave. www.youtube.com/watch?v=K62J... #pspester #powershell

It's #tsql2sday time, and here's an entry: nocolumnname.blog/2026/06/30/t... I apparently didn't fully forget how to type, though I can't say the same for my writing ability... It is a full week or two early, but meh, what's done is done

T-SQL Tuesday #200: It’s Bad If I See

Words: 578Time to read: ~3 minutes I think that I shall never seethis developer’s query is blinding me – Joyce Kilmer (if she was a DBA) Welcome to T-SQL Tuesday, the monthly blog party…

nocolumnname.blog

Looking for some #SQLConfirmation more than #SqlHelp, but when you take away a stats modification_counter number from the potential stats update threshold and get a negative number... Does that mean the stat wasn't evaluated in a query recently enough to get updated?

If anyone in the #PowerShell space who loves @chocolatey.org wants my current role (I'm still here, just moving into another area), check out the posting! www.linkedin.com/jobs/view/44...

It has got to the stage where I can't be arsed to read the point the author prompted AI to make...

Stacy Cashmore@stacy-clouds.net · last mo.

Gah… LinkedIn AI slop. You can spot it instantly. Opening statement Rhetorical Question Overblown insight Triple point Rhetorical question to hook people It’s lazy, pointless, and wastes everyone’s time.

🎉🥳 IT'S HERE 🥳🎉 PerformanceMonitor v3.0.0 has landed, and it's a big one! 🚀 No more UI freezes 🔍 Object + index-level collection 🧠 Rebuilt recommendations engine Free, open source, zero breaking changes. 🍾 github.com/erikdarlingd...

Publish a script and it becomes a supply chain. 🔐 Adil Leghari (@adilio.ca) on baking provenance into your PowerShell & Chocolatey pipelines BEFORE publish. Now up: www.youtube.com/watch?v=TfRC... #PSHSummit #PowerShell

Provenance Before Publish: Building Safer PowerShell and Chocolatey Pipelines by Adil Leghari

Many PowerShell authors think of their work as automation rather th...

youtube.com

How to Get Real ROI from Automation? Hint: It's more than Time Saved - Time Spent Building. In my latest video, I explore what makes an automation worth the investment and share design principles to help maximize its long-term value. go.dowst.dev/automationro... #Automation #DevOps #Productivity

The Real ROI of Automation

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

go.dowst.dev

Passion doesn't scale. 🔥 When one maintainer carries a repo, the bus factor is real. Gilbert Sanchez (@gilbertsanchez.com) on running your project as an org. Live: www.youtube.com/watch?v=7m-p... #PSHSummit #PowerShell

From Burnout to Built-to-Last: The Open Source Org Advantage by Gilbert Sanchez

Open source is full of passion projects - but passion doesn’t scale...

youtube.com

Even seasoned scripters miss these. @dbaduck shares practical tips, clever tricks & smarter patterns for arrays, strings, loops & more. www.youtube.com/watch?v=k-qx... #PSHSummit #PowerShell #Scripting

Level Up Your PowerShell: Essential Tips, Tricks, and Techniques by Ben Miller

PowerShell is packed with capabilities that many of us use daily—bu...

youtube.com

You already write Markdown. Why not turn it into a blog, docs site, or resume? @gilbertsanchez.com tours Jekyll, Hugo, MkDocs, Docusaurus & more. www.youtube.com/watch?v=Np0N... #PSHSummit #PowerShell #StaticSites

Markdown Madness: Static Sites for Fun & Profit by Gilbert Sanchez

You already write Markdown. README.md, meeting notes, maybe even yo...

youtube.com

PlatyPS 1.0 GA is here! @sdwheeler.bsky.social & @steviecoaster.dev show how to create, update & publish your PowerShell help to a static site. www.youtube.com/watch?v=MBW2... #PSHSummit #PowerShell #Docs

Publish PowerShell help content using PlatyPS v1.0 by Sean Wheeler, Stephen Valdinger

PlatyPS 1.0 GA is out. Learn how to use this new version of PlatyPS...

youtube.com

Future You deserves answers. @steviecoaster.dev treats Chocolatey packages like the versioned code they are: repo structure, Git wins, mistakes to dodge. www.youtube.com/watch?v=IKYA... #PSHSummit #PowerShell

Source Control for Chocolatey Packages: Because Future You Deserves Answers by Stephen Valdinger

Chocolatey packaging is often learned by example—and sometimes by a...

youtube.com

Built something amazing in PowerShell Universal? Don't let it gather dust. @steviecoaster.dev shows how to package & publish it to the Gallery for the world. These are the modules you're looking for: www.youtube.com/watch?v=MZ7E... #PSHSummit #PowerShell

These Are the Modules You’re Looking For: Packaging and Publishing PowerShell.. by Stephen Valdinger

These Are the Modules You’re Looking For: Packaging and Publishing ...

youtube.com

The Case for Business Logic in Stored Procedures This is the second post in the "Where Does Business Logic Live?" series. In Part 1 I laid out the terms of the debate and split "business logic" into five different kinds of logic that behave very differently when you decide where to put them. Now…

The Case for Business Logic in Stored Procedures

This is the second post in the "Where Does Business Logic Live?" series. In Part 1 I laid out the terms of the debate and split "business logic" into five different kinds of logic that behave very differently when you decide where to put them. Now it is time to make the case for one side properly - not as a strawman to knock down, but as the strongest version of the argument a working DBA can make.

sqlserverscience.com

Sorry I couldn't make #DataCeili but hoping everyone had an epic time (educational is a given)

Last week I again had the opportunity to speak at #psconfeu, the biggest #PowerShell conference in Europe. Presented 2 talks on Pester. My code and presentations are already online at github.com/psconfeu/2026 Youtube videos hopefully coming soon!

If adulthood isn't not doing the programming and research you wanted to do because it finally stopped raining and you'd been complaining about not cutting the grass all week... then I don't know what is! Now, excuse me while I go yell at clouds

Optional Parameter Plan Optimization, introduced in #SQLServer 2025, is really a great idea. But with its current terrible implementation, I actively dislike this feature. Want to know why? Check my latest vlog! sqlserverfast.com/blog/hugo/20...

Optional Parameter Plan Optimization - SQLServerFast

It’s time to finish the triptych on bad parameter sniffing, and how Microsoft tries (and fails) to fix this for you. After first talking about bad parameter sniffing in general, I used my last video t...

sqlserverfast.com