Happy birthday @cporteous.bsky.social

I've never seen a LEFT JOIN written as a CTE, used in another CTE before.

With the 2nd CTE reading like a recursive one (anchor stmt, union all, recursive stmt) with NOLOCK **AND** index hint.

1. Don't do that
2. If you call the 1st CTE in both parts of the recursive CTE, then its not recursive!!

The kickoff of @powershellsummit.org
week is off to an exceptional start!

Too many fantastic #DevOps #PowerShell #Terraform and #Ansible sessions to mention, and it’s only Tuesday 😁

#PSHSummit #MVPBuzz

Congrats to @jborean.bsky.social for receiving the #PSHSummit26 Jeffrey Snover Innovation Award. As last year's winner I was proud to present it and it sure is nice that it happened to be for the person I voted for.

Lightning Demos from PowerShell Summit We're coming to you live from PowerShell Summit with back-to-back Lightning Demos! These are fast, focused, and packed with practical PowerShell goodness — think of it as a highlight reel of some of the coolest things the community is building and automating right now. Whether you're a seasoned scri

Not at PowerShell Summit this year? Good news.

We're bringing Lightning Demos straight to you, LIVE from Summit on PowerShell Wednesday. Fast demos, real learning, no travel required.
Come learn with us.

www.youtube.com/watc...

#PowerShell #PSHSummit

Yeah i should. I have half of them as random passwords, but i got lazy half way through 🙈

Meh, the older I get the more I see the attractiveness of rural Ireland

Shane O';WAITFOR DELAY '05:00';--Neill

Think it would annoy me more than them after a while though

It get tempting from time to time...

"The response for 'What is your maternal grandmother's first name' is too short"

Really? Nobody told Nana that 🤔

Also! As you made me spell my name as ONeill instead of O'Neill, i think you don't know what you're on about...

There's a whole community around thoughtful/insightful/heartfelt messages from people with ...questionable... usernames

So... @steviecoaster.dev

I blame @millerb.co.uk
Sorry, gotta blame someone

I'd recommend a nice, relaxing burrito

Finally, finally, Postgres 19 will get query hints: www.depesz.com/2026/03/22/w... The developers were dead set against this forever, seeing it as a footgun.

Shuffle (move) could be an issue. Have you tried Cha-Cha (slide)?

Day 23 of International Women's Month: @jpomfret.co.uk reminds us of the power of representation. Be sure to visit her blog: jesspomfret.com, on the youtubes: www.youtube.com/@findingdata..., or any other of the gatrillion places she can be found helping others.

#datawit #celebratingwomen

Chrissy LeMaire's blog SQL & PowerShell MVP. GitHub Star. Creator of dbatools. Need to oil my knees.

Day 21 International Women's Day - remembering a quote from Chrissy LeMaire on AI: "We're no longer alone in finding the right words or ideas, and confronting problematic situations becomes far less daunting. And we can remove bias when we are upset."
#datwit #celebratingwomen
blog.netnerds.net

Awkward Judd This channel is for the dad jokes I have written and posted, along with any content related to these jokes. I work hard to create, write, test, and fine-tune my own unique material. Any similarity to ...

As we are at the start of a new week, I have done my part and have my #dadjokes all lined up and ready to go for you. If you want to know when they go live, well then go here and do the cliche of Subscribe with notifications: www.youtube.com/@awkwardjudd

Data Organization in Spreadsheets Karl W. Broman & Kara H. Woo Pages 2-10 | Received 01 Jun 2017, Accepted author version posted online: 29 Sep 2017, Published online: 24 Apr 2018 1. Introduction 2. Be Consistent 3. Choose Good Names for Things 4. Write Dates as YYYY-MM-DD 5. No Empty Cells 6. Put Just One Thing in a Cell 7. Make it a Rectangle 8. Create a Data Dictionary 9. No Calculations in the Raw Data Files 10. Do Not Use Font Color or Highlighting as Data 11. Make Backups 12. Use Data Validation to Avoid Errors 13. Save the Data in Plain Text Files ABSTRACT Spreadsheets are widely used software tools for data entry, storage, analysis, and visualization. Focusing on the data entry and storage aspects, this article offers practical recommendations for organizing spreadsheet data to reduce errors and ease later analyses. The basic principles are: be consistent, write dates like YYYY-MM-DD, do not leave any cells empty, put just one thing in a cell, organize the data as a single rectangle (with subjects as rows and variables as columns, and with a single header row), create a data dictionary, do not include calculations in the raw data files, do not use font color or highlighting as data, choose good names for things, make backups, use data validation to avoid data entry errors, and save the data in plain text files.

Every day is a good day for sharing one of the most useful papers about research data ever written. PLEASE get your people to understand and follow this advice.

www.tandfonline.com/doi/full/10....

EightKB is back for 2026!

The largest online SQL Server internals conference is coming on August 20th...and the CFP is open!

Calling all you experts out there...fancy talking at the online SQL Server conference? :-)

dbafromthecold.com/2026/03/18/e...

Swedish whisky with a recipe generated by AI

@erikdarling.com is this the next step after your next release?

That's what I'm scared of 😅
Always good to see you too, Matt

Mohamed @MohamedSkandari ... Reading books is so profound because it denies you the ability to speak when confronted with an idea. You must listen. It isn't a conversation. Sometimes it shouldn't be a conversation. Sometimes we should just listen. & st listen.

All this. Yes.

just.... one.... more....

@sdwheeler.bsky.social will be on stage for #PSConfEU 2026 in #Wiesbaden (1-4 June)

🎙️ Make a PowerShell profile that runs on any version or platform
🎙️ What's new with PlatyPS

🎟️ psconf.eu

#Europe #Germany #PowerShell

Back in hospital - SQLServerFast (Warning: This blog post is non-technical but purely personal. I write openly about my current health issues. This blog might be triggering for people who struggle with, or lost dear ones to, cancer a...

I just blogged with an update on my leukemia treatment. First days in hospital, and the work I have been doing.

sqlserverfast.com/blog/hugo/20...

Enjoy! Send pics and/or knowledge

Dammit, I've moved from "I should check this out" to "I want to check it out"!