Zikato

Made one myself this week, it was a hit

Onion dip

agreed

ctrl + h in SSMS

I already did

one line of cocaine would also solve it

I have a list of servers and I'm dynamically generting execution of sp_addlinkedsrvlogin for each server in the list. The raw password is in the dynamic generation

basically generating a bunch of linked servers dynamically and trying to hide the rmtpassword param value. I did it with manual replacement

alright, I'll replace it manually

yeah. Sp password has the same behaviour as create login

yeah, good call. That is masked with XE but only the create login statement not the whole batch. Maybe I've made a human hallucination and batch is never masked

yeah that's what I'm testing. I thought it might be the cert creation but that's not it. I remember there was some operation that masked it

we have internal audit using XE to capture batch text. So I wanted to mask it for the operation

I guess I can generate the dynamic sql with a placeholder and then replace it myself but was hoping for another option

I thought there was some trick that if you include some other secure activity in the same batch it won't be logged (or at least the batch text will be anonymized)

hmm there must be another trick I was thinking of. My problem is that I need to generate some dynamic sql that involves a password. But the actual statement of generation would be logged and thus expose password in plain text.

that's the one, thank you

@PaulWhite I'm pretty sure you had some blog post with a trick that had some sort of password and goto but I have trouble finding it. Do you know what I mean?

It got screwed. The whole county went down the tubes

Who knew that when Pennywise said "You'll float too" he was talking about Australian port corks

@PaulWhite yes please

I didn't read that far up on the transcript

“Blessings be on this house," Granny said, perfunctorily. It was always a good opening remark for a witch. It concentrated people's minds on what other things might be on this house.

Exactly. The right people definition may be subject to change

overrated. Techno-oligarchy is the way to go

Shol'va!

Trailing ofc

it would be a great system to deliver some kind of poision that needs to be mixed right before ingestion

If it's always DNS one would think people would be better prepared for it

Top minds of Australia worked on this no doubt

funny that going full cork or full plastic would be much better. They chose the worst of both worlds

Pull it out a bit and cut off the plastic bit :-D

F

Why would they cheap out on the cork?

ahh, I've googled it and I see what you mean. Yeah that's terrible

I meant the corkscrew

maybe not so much skill but equipment issue

the wine key is the generic term as I understand it

what wine key do you have?

sounds like a skill issue

@PaulWhite must be very tiresome. Their dopamine receptors must be fried by now

Same

Thank you Erik, that worked

Oh I remember why I didn't finish the SQL Prompt blog post. My trial has expired

I don't know why it won't look into the Epstein files. Seems like a low-hanging fruit

I can pickup again the Kusto detective series or finally finish the post about SQL Prompt snippets

well, the blog turned over staff

I should be blogging today, got some free time