Shane O'Neill

Awww man, I did not need to know about PSBite 🙈 I'm going to sink so much time into learning how that works

#sqlblog What's Wrong With this Query? nocolumnname.blog/2026/10/06/w... Yes, it's short and dumb... Add a few million records, and it took me a bit longer than I'd like to figure out

Everybody give a warm round of thankful applause for Randolph West, the Microsoftie who owns all the SQL Server documentation and oversaw massive improvements to it. He's leaving MS: bornsql.ca/blog/goodbye...

Its 2 bytes to 3 bytes. How hard could it be? Well is it register to register? Is it immediate. What's the D field? And the W field? Have you got the MOD? Or the Reg? R/M? They interact differently, you know! Every so often I realise how thankful I am for SQL

Classic post: "UPDATE, INSERT, and DELETE are not normally processed in parallel" www.brentozar.com/archive/2020...

I'm heading to Scotland for the long weekend! _read in accent of your choice_

@mikefrobbins.com and @sdwheeler.bsky.social, thank you for your astounding contributions to the #PowerShell community. Docs are the gateway to new user to this community and the staple reference for Veterans, and you two have worked tirelessly carrying the torch of the culture of great docs. Thanks

Knock knock. Who's there? An implicit conversion. An implicit conversion who? Doesn't matter. You're scanning the whole table now. T-SQL That Doesn't Suck, my #PASSDataSummit West precon. Bring your worst stored procedures. passdatacommunitysummit.com/west/

Just got done chatting with @andrewpla.tech for the PowerShell Podcast! Always a pleasure. Keep an eye out if you want to hear me ramble.

I'm in awe of the ability to figure out the minute of executions, figure out a theory, AND create a test for it too!

New blog post! In this detailed and deep #SQLServer #Plansplaining post, I revisit the execution plan for frameless window aggregation (OVER without ORDER BY), to address some details previously overlooked, which leads me to uncover a bug and an invisible property. sqlserverfast.com/blog/hugo/20...

Blogged: #tsql2sday 202 - your most memorable outage flxsql.com/2026/09/08/t...

New blog post & my 4th contribution to T-SQL Tuesday: About a two week long outage caused by the Ryuk ransomware. 60+ instances restored, reinfections fought, and how I used Ryuk's own file filtering logic to protect local backups. #sqlserver #mssqlserver #infosec #tsql2sday #cybersecurity #mvpbuzz

Fucking Azure Backend Pools, man! Ok, I gotta get my learnings on and figure out how the whole thing works

Call for Speakers for PSConfEU MiniCon 2026 is open on Sessionize and I've just submitted a session about Pester 6. This is great opportunity to speak publicly, go check it out! #pspester #powershell sessionize.com/psconfeu-min...

I tend to do the opposite and tack on an extra check on myself to check data lengths. This is arguably better...

Thank you to Andrea Allred and her post on index %s I can now see some sort of progress! #sqlserver royalsql.com/2026/07/14/e...

Pester 6: Should-BeEquivalent deep-compares objects, recursively and order-insensitive, property by property. Check a whole API response against an expected object in one line. #pspester #powershell

I'm not going to spoil any of it here. The good stuff (and the numbers) are in the posts. The round-up, with links to all nine: www.jefftaylor.io/post/t-sql-t... The original invitation that kicked it off: www.jefftaylor.io/post/t-sql-t... Which camp are you in?

Temp tables in tempdb: friend or foe? I asked, and nine bloggers answered for T-SQL Tuesday #201. One of them built a lab. Another swears by CTEs until the exact moment they fall apart. And I took my own dare to see whether I could beat a temp table without one.

New in Pester 6.1: Should-HaveType understands PowerShell custom types, not just .NET types. Tag an object with PSTypeName 'MyApp.Person' and Should-HaveType 'MyApp.Person' passes. #pspester #powershell

We're just about a week away from @mdowst.dowst.dev joining us at the Ohio #PowerShell User Group to bust some PowerShell myths! psoh.io/events/2026-...

On the downside, I'm leaving Greece after an incredible week-long holiday. On the upside, I've a lot of @psconf.eu and @eightkb.online learnings to come back to!

🗄️ What if your database could handle #AI too? @jpomfret.co.uk & @robsewell.com demonstrate #SQL #Server 2025 embeddings, vector search, RAG workflows, and how #PowerShell helps connect everything together. 🍿 youtu.be/76gYUUecVJM?si=89n... #SQLServer #PSConfEU

Some conferences end. The learning continues. Our final #PSConfEU 2026 recordings drop this Friday, including all Community Demos. 9 speakers. 9 ideas. Countless things to try in your next PowerShell project. Watch here: youtube.com/playlist?list=P... #PowerShell #Automation

Woo! @eightkb.online is tomorrow! Five amazing in-depth mind-melting sessions from expert speakers...Registration is still open and as always, completely free. Come join us tomorrow @ 13:00 UTC eightkb.online

🔬 Ever wondered how #PowerShell chooses which .NET method to call? @jborean.bsky.social explores reflection, overload resolution, generics, async methods, and ref/out parameters in this deep dive into PowerShell internals. 👉 youtu.be/hKRbQUDYqeI?si=Lli... #DotNet #PSConfEU #Programming

#tsql2sday asks us about Temp Tables. Friend or foe? 🤔 If you need a brew to tackle a query, you might want to give one a try ☕ andybrownsword.co.uk/2026/08/11/t...

Happy #tsql2sday! This month's topic is about #temptables (and it's only appropriate to use a hashtag for that.) Here's my contribution:

Finally did it. If you want to learn testing in PowerShell, hopefully this helps. Please share any feedback to improve it. 🙂

#tsql2sday post is up - ignore the 4 mins past midnight time. it's still Tuesday somewhere... nocolumnname.blog/2026/08/12/t... #sqlserver #sqlblog

"A [Galway] bye-law forbade [...] 'neither O' nor Mac shall strutte nor swagger through the streets of Galway' [...]" Ah! True! However, I shall be doing a mix that I call stagger for the Streets of Galway 8K, so I'm good. I shall also revert to some cryptid form to even get through this "run"

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

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

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…

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

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).

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

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

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

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

🎉🥳 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...