Shane O'Neill

@SOZDBA@techhub.social
201 Followers
208 Following
125 Posts
He/Him. DBA. Automation. Food, Coffee, Whiskey (not necessarily in that order)...
Bloghttps://nocolumnname.blog/
TIL while you can create a Dist AG on a Dist AG, it will completely feck up your AG dashboard

Oh, snap!
Wordle 1,202 2/6*

⬜🟨🟨🟨⬜
🟩🟩🟩🟩🟩

Death: "MR JAMES EARL JONES?"

JEJ: "IS IT THAT TIME ALREADY?"

Death: "ARE YOU DOING MY VOICE?"

JEJ: "NO. PRATCHETT WROTE YOU WITH MY VOICE IN MIND."

Death: "WOW. THAT'S A FIRST."

JEJ: "AND THE ONLY TIME. IN ETERNITY. BEER?"

Death: "I THINK I NEED ONE."

James gently took his hand and led him into the desert.

By the time you're 35, you should have successfully done following at least once:

1. rm -rf / on your unix or linux box
2. Reboot production server by mistake
3. Drop CPU/hard disk and damage it permanently
4. Changing firewall rule instantly blocked you out
5. No backup was made/verified ever...
6. Delete source code before actually committing to source control
7. Run a SQL update/delete with wrong where clause

Managed to log all the books on my bookshelves (excluding audiobooks, books around the house, etc.).
I'm not sure if this means I should read the books that I have... or get the number up to 500 books 😂
Tough decision coming where we have a project to move to #SQLServer2022 but have been hitting plan regression incidents recently.
This post by @kendralittle is food for thought on the process
https://littlekendra.com/2024/08/12/query-store-failed-forced-plans-general-failure-even-slower-compile-time/
General Failure Failed Forced Plans in Query Store Cause Even Slower Compile Times

Kendra Little writes and draws comics about SQL Server, Data Platforms, and Database DevOps.

LittleKendra.com

Strangest thing where 7 out of 16 servers, all of which were created together the same way, are missing Microsoft.SqlServer.SqlWmiManagement.dll

No clue how, but now I've to either fix it or workaround it 🤷‍♂️

#sqlserver2022 #powershell

Picard management tip: If specific implementation details are important, then include them when giving the order.

Blog alert!
A fun question today: why is SQL Server Hashbytes conversion not working as expected?
#SQL #datahashing #techtalk #SqlServer #Microsoft

http://sqlreitse.com/2024/04/11/mind-your-collation/

Mind your collation!

Blog alert! My colleague recently came to me with a fun challenge: why is their SQL Server Hashbytes conversion not working as expected? After some digging, I discovered significant differences bet…

Reitse's blog
My blog is mostly 25 years of me having an intense and long running argument with myself.