TIL while you can create a Dist AG on a Dist AG, it will completely feck up your AG dashboard
| Blog | https://nocolumnname.blog/ |
Shane O'Neill
@SOZDBA@techhub.social
- 201 Followers
- 208 Following
- 125 Posts
He/Him. DBA. Automation. Food, Coffee, Whiskey (not necessarily in that order)...
Oh, snap!
Wordle 1,202 2/6*
⬜🟨🟨🟨⬜
🟩🟩🟩🟩🟩
Geoff 🏴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.
nixCraft 🐧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 😂
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/
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/
@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 🤷♂️
Picard TipsPicard management tip: If specific implementation details are important, then include them when giving the order.
2meterdba | Reitse EskensBlog alert!
A fun question today: why is SQL Server Hashbytes conversion not working as expected?
#SQL #datahashing #techtalk #SqlServer #Microsoft
