« first day (5036 days earlier)      last day (128 days later) » 

mustaccio
mustaccio
01:50
user image
sure
 
3 hours later…
Hannah Vernon
Hannah Vernon
05:12
Wordle 1,217 5/6*

⬛⬛🟨⬛⬛
🟨⬛⬛⬛⬛
🟩⬛⬛🟩⬛
🟩🟩🟩🟩⬛
🟩🟩🟩🟩🟩
 
1 hour later…
Paul White
Paul White
06:32
Wordle 1,217 5/6*

⬛⬛🟩⬛⬛
⬛⬛🟩⬛🟩
⬛⬛🟩🟩🟩
🟩⬛🟩🟩🟩
🟩🟩🟩🟩🟩
@ErikReasonableRatesDarling Regarding lock compatibility battleship, the conflicts don't seem so bad to me. In essence, S conflicts with X. Most of the entries show N for No Conflict.
And in particular, IS doesn't conflict with IX.
John K. N.
John K. N.
07:31
Jó nappot.
Wordle 1,217 4/6*

🟩🟩⬛⬛⬛
🟩🟩⬛🟨⬛
🟩🟩🟩🟩⬛
🟩🟩🟩🟩🟩
 
4 hours later…
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
11:57
@PaulWhite i was committed to the joke at that point
Master Database
Master Database
0
Q: how to blur up sensitive information on questions or answers?

Marcello Miorellias it was just recently the case on this question of mine - I want to show the result of a query, but I cannot show server names and other specific properties that would potentially cause harm. however, I enjoy details and clarity, my question is: visually the way I did - blurring all with red on...

discussion support questions answers
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
just spit on your monitor
Paul White
Paul White
12:14
@ErikReasonableRatesDarling Well, fair enough
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
@PaulWhite i have attempted an improvement so that i don't ruin your great weekend™️
Paul White
Paul White
I suppose it's all by the by since they were talking about a PAGE-level shared lock
Makes one curious about the exact type of deadlock
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
12:38
curious enough to ask?
Paul White
Paul White
I don't want to nag
They asked their question and got an answer they were happy with
Already had the question updated once
It's probably a fairly routine multi-resource deadlock
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
12:57
could be
speaking of which
how was the wine haul?
Paul White
Paul White
Awesome as usual. In progress
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
there wasn't much fanfare, so i was getting nervous
Paul White
Paul White
It's essentially a slight variation on the first case, which is fine by me
There were many opportunities to change the contents, but I saw no reason to mess with a winning formula
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
13:21
try something new
experience the world around you
get a different kind of drunk
i dunno
Paul White
Paul White
There is already plenty of variety. Each box is typically different years as well
9
A: SQL Server Deadlock between two selects and one update on one table

Randi VertongenWhen looking at the deadlock graph: Update query - SPID 75 The update query locking (spid 75) is pretty straightforward, an X (exclusive) lock is requested on the key/row value, while that row is currently locked by the select query. The update query also holds an IX (Intent exclusive) lock...

Interesting example using a single table (but multiple accesses) in a single statement
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
a self join
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
13:40
you know that randi had some pretty good answers
whatever became of him
Paul White
Paul White
13:50
🤷‍♂️
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
> Hi, I am Randi.
> I am currently working as a freelance Azure Data Consultant.
probably got sick of working for free
Josh Darnell
Josh Darnell
He was at MSFT for a while, I think.
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
user image
Zikato
Zikato
14:35
Oct 14 at 17:06, by Zikato
I might just blog about how sys.fn_xe_file_target_read_file is the worst system function in SQL Server.
straightforwardsql.com/posts/…
3
Hannah Vernon
Hannah Vernon
I went to add a comment (for seo) but I had to authorize utteranc.es to act on my behalf in GitHub, and that won't happen unfortunately.
I'm guessing that certainly cuts down on the number of comments you need to deal with 😁
good article btw
user image
Zikato
Zikato
Paul had similar comment. It's basically GitHub's fault because the message is misleading
the act on behalf means only comment on that particular repo
Hannah Vernon
Hannah Vernon
either way, that gives me the creeps lol
This is only tangentially related, but to authenticate with github, I have a 2FA key, which has lately got me wondering what happens if my heirs want to login to something after I'm gone, but need to find (and use) this key. I think they will be very unlikely to understand authentication sufficiently to make it work.
how much documentation does one want to write
Peter Vandivier
Peter Vandivier
15:45
@HannahVernon my understanding is that account recovery keys bypass mfa. i've printed mine out and left them in a safe deposit box. you can also nominate a successor
Chrissy LeMaire did a pretty comprehensive writeup along with a few other folks on this a few years ago github.com/potatoqualitee/eol-dr
FWIW at present i've just left a list of "who to ask for help" in specific sections of my hit-by-a-bus doc for things i think are likely to be difficult to grok for the target audience
> this is not a shopping list question
doth protesting too much methinks
John K. N.
John K. N.
16:11
@HannahVernon That's why i switched to the family plan of 1password.com
You can work with vaults (private, family, financial, ...) and grant access to other family members to your different vaults.
Integrates into all major browsers. Includes options for 2fa and passkey.
Peter Vandivier
Peter Vandivier
yes but then you need to write documentation for how to use the password wallet too ;p
John K. N.
John K. N.
Is endorsed by the author / creator of haveibeenpwned.com
My wife is already using it. It's pretty simple once you have the app on your phone.
Peter Vandivier
Peter Vandivier
16:26
> Adding as an answer because a comment wouldn't fit.:
😚🤌
Peter Vandivier
Peter Vandivier
16:54
@JohnK.N. also maybe a mod should edit this typo - thought it was amusing at first but that's a legit malicious cybersquatted domain :\
Hannah Vernon
Hannah Vernon
17:09
@PeterVandivier thanks, I fixed it
@PeterVandivier "EOL DR" - what an awesome name
Peter Vandivier
Peter Vandivier
:p
you gotta have some fun with it
Hannah Vernon
Hannah Vernon
For sure
Peter Vandivier
Peter Vandivier
mine is titled "oops-i-died"
Hannah Vernon
Hannah Vernon
I think I'll go with not dead yet
Peter Vandivier
Peter Vandivier
46 mins ago, by Peter Vandivier
😚🤌
but also back to your original point - in addition to having a couple named people who know how to use mfa & would be available & happy to help your successors listed in the DR doc, i also have one-time-use recovery keys printed & secured together for all the "major" mfa secured credentials
anything that's used for IDP basically
Zikato
Zikato
17:20
@JohnK.N. I'm also team 1password
 
3 hours later…
Erik Reasonable Rates Darling
Erik Reasonable Rates Darling
20:45
Have a great and tangible weekend.
 
2 hours later…
Josh Darnell
Josh Darnell
22:50
A fungible weekend.

« first day (5036 days earlier)      last day (128 days later) »