« first day (4451 days earlier)      last day (715 days later) » 

07:26
morning
07:44
Morning
08:33
@J.D. congrats
 
3 hours later…
11:44
@JohnK.N. Thanks! 🙂
12:21
And today's:
Wordle 632 2/6

⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩
12:32
Wordle 633 5/6

⬛⬛⬛⬛⬛
⬛🟨⬛⬛⬛
⬛⬛🟩⬛🟩
⬛🟩🟩🟩🟩
🟩🟩🟩🟩🟩
Wordle 632 4/6

🟩⬛🟨🟨⬛
🟩🟨⬛⬛🟩
🟩🟩🟩⬛🟩
🟩🟩🟩🟩🟩
Wordle 632 2/6*

⬛⬛🟩⬛🟩
🟩🟩🟩🟩🟩
13:09
I should probably revisit my Wordle blog posts
13:54
@Zikato 7 puzzles or 7 is your Elo rating? ;p
@HannahVernon nice 🤙
14:11
@PeterVandivier Yes
(•_•)
Response to boolean enquiry confirmed correct
Is it ELO though? I thought it was their proprietary rating
It's just a number
I think my ELO was around 1800 when I played. But I don't know if that was the country-wide rating or international.
14:25
But <true> OR <anything> is <true> in two-valued logic anyway.
14:59
TIL "Elo" isn't an acronym chess.com/terms/elo-rating-chess
15:12
i thought it was a band
Emo?
The Electric Light Orchestra (ELO) are an English rock band formed in Birmingham in 1970 by songwriters and multi-instrumentalists Jeff Lynne and Roy Wood with drummer Bev Bevan. Their music is characterised by a fusion of pop and classical arrangements with futuristic iconography. After Wood's departure in 1972, Lynne became the band's sole leader, arranging and producing every album while writing nearly all of their original material. For their initial tenure, Lynne, Bevan, and keyboardist Richard Tandy were the group's only consistent members. ELO was formed out of Lynne's and Wood's desire...
Mr Blue Sky please tell us why
15:51
This question... doesn't make much sense.
0
Q: Name in sys.availability_groups_cluster returns double character length

CrushingIT'select name, len(name) as length from sys.availability_groups_cluster' Returns some double values: name length AG_QBUS_MFG01 13 AG_QBUS003 20 TEST_ONLY 18

along with the answer
it has been DEAGL'd in here
paul has browbeaten us into accepting it as is
Clearly I'm oblivious
sorry, DAGL'd
Sounds like something that could get your arrested in certain states
"yes hello, board of tourism, what are your DAGL laws?"
16:10
sometimes i love this site superuser.com/questions/1773079/…
> Windows is not Linux.
the only other words in that answer should be "Where can I send the invoice?"
@PeterVandivier lol 3 updoots too. They weren't the only one's wondering...
> updoots
I vote that we keep that.
16:34
this is not reddit sir
@SeanGallardy This again. Yes, indeed it is curious. Either they made it all up to troll us in some subtle way, or there's something going on we don't know about or can't reproduce (though I don't know if anyone has checked into that).
this is a hard OPping
days long
I closed it as unclear at one stage, but there was debate and a reopen vote so I reopened it. Nothing happened since then except people saying how weird it is.
So, I guess we've established it is odd.
@PaulWhite I just saw it today, the _clusters reads from the registry... but so does the AGMetadata from the regular one, so the data should be the same
Are you saying it's weird.
16:42
Yes, yes I am.
Well, then I guess I would have to agree.
quorum on weird
2
Feels like a great achievement tbh
Really united the team
PLUR in the heap
I really have 1 thought on repro'ing it
16:43
happy monday(s)
For someone that doesn't like HA sure has some HA jokes :D
@SeanGallardy Make sure you try every possible configuration and type of cluster, on all known SQL Server, Windows and Linux builds.
SQL on Linux can GTFO
sean is the type of guy to have that environment already set up and ready to go
(how'd you know)
16:44
spyware
Does feel like a penguin problem
Someone get Torvalds in here STAT
Get-VM | measure
Count    : 21
You and markdown. Just keeps giving
I still can't get multiline stuff
I'm so bad at it
just hit the fixed font button
16:46
CTRL+K for fixed font
it usually shows up when you multi-line
I need an old internet explorer style BHO toolbar to help me foramt it
As Erik says, there's an orange button for it
Bright orange
OSHA orange
Congrats
Until next time
16:46
I literally never noticed the buttons change on multiline
have you tried looking at them
Sounds precarious
I would stg he's said all this b4. Peak trolling
Mar 7 at 14:10, by Paul White
As do his dates
Some might call it weird
16:48
stack oddity
> FROM dbo.Table_Without_An_Unnecessary_Identity_That_Only_Causes_Pain;
how v. unwelcoming
He's never quite lost his initial snark
But what can you do
Hey, on a separate topic
Did I ever tell you about that one guy
Who had an AG with a strange character length problem
Man, was that weird
way out wiggy weird
Yep, one to tell the grandkids about
I'm pretty sure I'm going to break this AG when I mess with this
maybe you should use docker
16:54
@SeanGallardy Just make sure you don't overrun any buffers
Make double sure if you have to
Or rewrite the entire SQL Server code base in managed code as Mr C. Face suggested
🤦‍♂️
@SeanGallardy OP never responded to comments, so we never got a good debugging on what the actual issue was. It doesn't help that @PaulWhite is very aggressive at deleting comments, so it's possible they simply never saw them.
Paul never met a comment he didn't like.
Oh was I tempted to instantly delete that chat message
out of a 1 hour meeting I just heard my name
oh, it was just to say the meeting is over
crisis averted
16:57
@SeanGallardy Perhaps there's a Unicode/ANSI difference? Or maybe some other weird string manipulation going on?
@Charlieface They've had comments for days, they've had an email about a closed question, visited the site and that page multiple times since, and still nothing. We might not get an update.
Or we might. You just never know with weird questions.
@PaulWhite But now you deleted the comments it's unlikely they are going to respond, and I certainly won't get a pingback.
@Charlieface Yes that's my guess, but all of this should be handled as unicode so it should just kind of work. My only guess is that the _cluster doesn't go through the typical codepage stuff so it might not be LEN sensitive
Do you actually see they visited the page?
Up to 11 minutes ago, the only comments I had deleted on that page were my own.
I added the extraness to make sure I could physically see how it was rendered as well
Unicode strikes again
Strings were a mistake
@SeanGallardy I read retarded first time round
HA! It is something I would probably say
17:07
@JohnK.N. Do you wear reading glasses at all
ystery olved
@Charlieface Have you considered following questions or answers you'd like to be notified about changes to?
I have never used the follow thing, forgot it was even possible
I use that feature a lot
I'm a vanilla user
I'm User-Lite
17:09
More of a leader than a follower eh
Yeah I lead myself into bad situations all the time
These types of titles for cases just make me cringe.
QA query using comp 110 3x slower than prod with same query
Very sad story
Send them a T-shirt from the store
Or a cookie
Maybe some tips on advanced chat markdown usage
@PaulWhite I forget about that half the time, but any case I would probably end up with hundreds in the list. I like to keep that list to just a few that I'm interested in because I want to know the answer if anyone gives one, not because I want to give an answer.
@PaulWhite I actually argued once that strings are breaking 1NF, but it didn't go down well.
17:13
@Charlieface Oh I probably have hundreds on my list. They're no bother if nothing happens to them.
@SeanGallardy That's just so beautiful
Bit daft if you make a strings table where each character is a separate row. Performance over correctness methinks
Yeah, I remember
Technically, though, that argument is bunk
@PaulWhite I figured you'd like that one
@SeanGallardy What actual characters are those can you paste them in here? Are they diacritics?
@SeanGallardy I'd buy one each of the whole range if I could
Two, so I had a spare in case anything unfortunate happened to the original
17:15
@Charlieface Ä̤G̤̈3
I thought about adding supplimentals to it but didn't want to break anything
I always name my clusters exclusively with UTF8 emoji
COMBINING DIAERESIS and COMBINING DIAERESIS BELOW hmm...
🗝🧩👝 is a great performer
very reliable
always on you might say
How many machines do you have named with emojis?
All of my clusters
Please consult transcript
17:17
Confirmed, emoji's break it
Oh yeah, I was going to ask a question about that
No, it's not a bug that one returns 1 less result
You choose to work with this tech
better than replication or query tuning
Better than replication, yes
17:20
Oh snap.
But that's a tautology
this guy
ANYWAY
Can we now agree that question and its answer make sense
A quite beautiful Q & A in all respects
Except the comment
The answer isn't correct and offers no rationale
@SeanGallardy Are you saying a better answer is possible
17:23
🤷‍♂️
As I said to young Mr Face, it appears to have been an acceptable workaround for the OP
@SeanGallardy It seems very much like you're saying a better answer is possible and you're going to write one
But I do sometimes hear things that haven't happened yet due to time zones
I only tested the cluster reading part
AG metadata in memory rarely refreshes
need to force one and not break the AG
sounds like a you problem
truly does
but we're all v supportive
in a general sort of a way
and I feel quite sure Mr Crushing IT would enjoy someone validating his experience
even if they haven't fixed the product yet
17:27
Looks good when I refresh the metadata
everything matches
someone earlier even accused him of making the whole thing up just to troll us
v uncharitable
So to me the only thing is if someone edited the registry
44 mins ago, by Paul White
@SeanGallardy Make sure you try every possible configuration and type of cluster, on all known SQL Server, Windows and Linux builds.
and for that reason, I'm out
closed as no-repro
Add to that all things that might possibly write to the registry
17:29
"works on my machine"
I tried in a database with a WS collation
Width sensitive collation
Ah
As far as I can tell, that user is in the US. Doesn't mean their system is ofc
But you know, things like the OS language and whatnot could factor in
If I had an AG or any kind, I might try it out myself
But I don't
@SeanGallardy Oh, just out of interest, what did you do to "refresh the metadata"
Microsoft should just have a general docs page that says all DMVs are written by interns, so you're lucky if you get any data at all, let alone correct and consistent data
18:31
@PaulWhite Restarted SQL Server, but I could have failed over and back
@PaulWhite Yeah, Turkish has always been a problem with the whole E and I thing
@SeanGallardy Thanks
18:44
Did somebody say replication? 🙃
It's a good name. You might start with one problem, but...
Replicators were one of the big bads of the Star Gate universe
19:05
Star Gate was great
19:22
Star Trek Picard season 3 is really good, by the way
I find that v hard to believe
I'm sure it will not appeal to everyone. just a personal opinion
19:45
Yes. I normally attach quite a lot of weight to your opinions. I had heard not so great things about earlier seasons and prior Star Trek spin offs, which is the reason for my scepticism
 
1 hour later…
20:51
There are some things that are not perfect, like the CGI.
Mostly where they used it to make the characters look younger, for scenes they were supposed to take place decades earlier. Riker's face looks really weird.
 
2 hours later…
22:24
that show mostly just seems like nostalgia masquerading as a new series
i watched a bit of it. it wasn't bad, just... didn't seem to go anywhere.
Seasons 1 and 2 were mostly them trying to retcon away Picard and build a new story around some ideologic garbage. Season 3 is much better so far.

« first day (4451 days earlier)      last day (715 days later) »