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
@guamwatt I'll check on Monday. What's a smsts log?

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