The Heap™ – Consultancy ©®

Paul White

00:55

That's so several years ago

Sean Gallardy

You aren't enthused about AI wording on every slide?

Hannah Vernon

04:15

Out our front window an hour ago

John K. N.

06:04

Wordle 1,269 4/6*

⬛⬛⬛⬛⬛
⬛⬛⬛⬛🟨
⬛🟨🟨⬛⬛
🟩🟩🟩🟩🟩

Yano_of_Queenscastle

10:18

@HannahVernon Beautiful!

Erik Reasonable Rates Darling

10:51

If anyone feels like getting stupider: The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner

Paul White

o no

it gets worse the more u read

that's just depressing

how can they have possibly missed the recent and moderately influential youtube series

Zikato

Bad advice is good marketing

Paul White

It's worse than that. SSC has always been prone to handing out participation awards to encourage people

Zikato

If we stop giving platforms and paying attention to stupid people, maybe they'll go away. But it seems impossible

Paul White

i.e. never mind it makes the reader less knowledgeable than they were, the author tried their best and spelled most of the words correctly

the SSC editor should not have published that. There is a learning opportunity for the author, but no one else

In my experience, the justification will be that the comment discussion (ugh!) adds more value that the original post, so on balance it's a win 🤦‍♂️

Zikato

11:05

Paul White

The author likely isn't stupid and believes what he or she wrote. They're just inexperienced or misinformed

It's like reading something from the SQL Server 2000 days

Zikato

I'm a slow typer myself

Paul White

To be clear: read uncommitted is a valid choice if it is an informed one.

Erik has ruined my day.

Zikato

A wine sacrifice has to be made

Erik Reasonable Rates Darling

11:21

I’m sorry have some butter 🧈

Paul White

Jul 29 at 21:45, by Paul White

Erik Reasonable Rates Darling

Cute duck

Be a shame when f it exploded

Paul White

Don't 🍆 with it

Paul White

11:40

Don't add to its trauma

❌🍆🦆❌💥

Hannah Vernon

13:50

Wordle 1,269 3/6*

⬛⬛⬛🟨⬛
⬛🟩⬛🟩⬛
🟩🟩🟩🟩🟩

John K. N.

congrats

Hannah Vernon

Cheers

Sean Gallardy

@HannahVernon That doe looks pregnant

The buck looks delicious

Hannah Vernon

yeah I'm pretty sure the coyotes living in the neighborhood think they're tasty too

Paul White

Nov 28 at 17:08, by Erik Reasonable Rates Darling

o deer

Wordle 1,269 6/6*

⬛⬛⬛⬛⬛
⬛⬛⬛🟨⬛
⬛🟩🟩⬛⬛
🟩🟩🟩⬛⬛
🟩🟩🟩⬛⬛
🟩🟩🟩🟩🟩

Jan 5, 2015 at 18:10, by billinkc

Deer nuts are still under a buck

classic

mustaccio

14:08

Wordle 1,269 4/6*

⬜⬜⬜⬜⬜
⬜🟩⬜🟩⬜
🟩🟩🟩🟩⬜
🟩🟩🟩🟩🟩

almost frog

Lamak

14:18

Wordle 1,269 5/6

⬜⬜⬜⬜⬜
🟩⬜🟨⬜⬜
🟩🟩⬜🟨⬜
🟩🟩🟩🟩⬜
🟩🟩🟩🟩🟩

Peter Vandivier

14:36

Hey Duggee frog

Erik Reasonable Rates Darling

19:47

@mustaccio I will give you frog credit for that one

mustaccio

$0.50 off your next invoice?

Erik Reasonable Rates Darling

20:06

We’ll see what happens with exchange rates

Paul White

Thank goodness, I thought you had died

Again

Hannah Vernon

just in case anyone wonders what the price of alcohol is like here. The answer is ridiculous.

Paul White

Planning a quiet night in?

That looks pretty cheap actually, but I haven't done the currency conversion

Hannah Vernon

yeah that's it

Paul White

I often wondered how people coped with living in a snowy country

Hannah Vernon

20:19

$673.98 NZD

@PaulWhite we drink and watch the deer go by

Paul White

Yeah but 1.1L of Bombay Sapphire for NZD 53 😲

Hannah Vernon

is that cheap or expensive?

Paul White

1L would be around NZD 60

Hannah Vernon

ok, so somewhat comparable.

Paul White

I'd forgotten standard B Sap is at the cheaper end

Hannah Vernon

20:21

in Florida the entire bill would be about $200 I think.

Paul White

Yes but the US just prints dollars to consume from overseas

It's not real money

Some sort of Ponzi scheme

Hannah Vernon

truth

Paul White

Notwithstanding the man Trump's advanced economic theories in this area 🤦‍♂️

Apparently buying things the US needs from CAN and MEX with printed money is some sort of subsidy

Hannah Vernon

definitely facepalm

Paul White

May not have enough booze

Hannah Vernon

20:25

yeah I don't think one could even have too much booze for the next 4 years.

Paul White

The past four weren't gr8 either tbf

Perhaps it would've been better to re-elect Biden and just let him sleep

From a damage limitation point of view

Zikato

Great answer on the Kendra question, Paul.

Paul White

Yeah, I didn't have time to make it shorter yet

It was a short answer in my head

Zikato

I like the details. Had to reread some portions few times but it makes perfect sense

Paul White

Shorter can mean replacing words with pictures

I hear there's a 1000:1 exchange rate

Just had an email

> Paul, it's time to renew your AA Membership

> Your AA Membership is due for renewal on 31 January 2025

🤣

That will get paid the day before as every year

Erik Reasonable Rates Darling

20:46

> cached execution context (MXC)

we need to talk about your acronym selection

i had a catch up call with JS and we spoke some about the new abort after query hint

he was quite a bit more enthused by feedback wrt setting a time out value

Paul White

One of us

@ErikReasonableRatesDarling Not my fault docs.microsoft.com/en-us/archive/blogs/sqlprogrammability/…

Perhaps you would prefer MsqlExecContext

Erik Reasonable Rates Darling

21:02

if we're going strictly on preference, i would like a bottle of 2015 saint cosme cote rotie that has been decanted for 37 minutes and served by 1985 marisa tomei

that would make me forget about all this

mustaccio

> Paul, it's time to renew your AA Membership

It's not "A" if they know your name

The other "A" czechs out

Erik Reasonable Rates Darling

friends of paul w

mustaccio

And in Canada membership in AA is free

Hannah Vernon

what canada do you live in

mustaccio

the other one, obviously

Paul White

21:06

I think the joke is Alcoholics Anonymous

Hannah Vernon

ooooh you're thinking of alcoholics anonymous

Paul White

could be

Hannah Vernon

not automobile association

Paul White

it's possible

Hannah Vernon

sometimes it takes me a while, but I usually get there eventually

Paul White

21:07

DNS delays, no doubt

Hannah Vernon

nice cookie btw

@PaulWhite unfortunately my TTL is too long

Paul White

🍪

Erik Reasonable Rates Darling

🥠

Hannah Vernon

Paul proves the devil is always in the details with that cached plan/cached execution context answer.

as I was reading it, I was thinking, so it's a timing thing. Then in the last paragraph we get confirmation of that, and a great explanation about how there is pretty much nothing that can be done except the recompile.

Paul White

21:24

Kendra rarely asks trivial questions in areas she knows well

Hannah Vernon

that is a gem of a question, and a really well written clearly thought out response. It belongs in a hall of fame, IMO.

Paul White

Many senior DBAs are too proud to ask at all

Hannah Vernon

for sure

Paul White

Others settle for writing yet another wrong piece about NOLOCK

It's a funny world

Hannah Vernon

as you said, it's surprising the editors let that be published.

Erik Reasonable Rates Darling

21:31

i had a talk with a couple people about that article

i'm not sure what they're doing to do with it

but they agreed it was quite painful

Hannah Vernon

that her question never made it onto the HNQ, but that turd SYNC question did, just goes to show how strange world we live in really is.

Erik Reasonable Rates Darling

did not seem to get published as a teachable moment

how about z getting 8 upvotes for the laziest link-only and update: sorry i answered the wrong question answer

Hannah Vernon

I found it funny that they think uncommitted is just that things are not maybe fully accurate, and not that things can be completely and utterly wrong

@ErikReasonableRatesDarling 9 😛

Erik Reasonable Rates Darling

one day you'll all die

Hannah Vernon

probably not even that many days in the future

Erik Reasonable Rates Darling

21:37

not with that shopping list

Hannah Vernon

hahah I'm not going to drink it all at once

nice callout to Andy's blog, btw. I read that back in 2019 but would never have remembered to reference it.

Erik Reasonable Rates Darling

just trying to improve an incredibly shabby answer situation

or non-answer situation, as it were

Hannah Vernon

when I read the question just now, I was thinking to myself what the what.

sometimes I feel like people are speaking a different language, even though its clearly written in english

I doubt you could get a better example of an XY problem

Erik Reasonable Rates Darling

not without starting an argument about bathrooms

Hannah Vernon

Z got an upvote from me as a reward for providing an answer of some kind.

@ErikReasonableRatesDarling good point

Erik Reasonable Rates Darling

21:44

jeez, all it takes is some form of an answer

votes from you should be worth 0

Paul White

@ErikReasonableRatesDarling which q is that pls

@ErikReasonableRatesDarling participation awards are all the rage

Erik Reasonable Rates Darling

5

Q: Are there best practices for SQL Server blue/green deployment?

Is it possible to spin up the new instance with the same structure and replicate all the data there, then perform some long running blocking operations that actually do not perform incompatible changes (for example change bigint to int or nvarchar to varchar if the types were chosen incorrectly),...

Hannah Vernon

@ErikReasonableRatesDarling I don't normally vote that easily, but what good is a voting ring if nobody votes :-)

also, to give a bit of credit to Z, he did answer the question in a reasonable way given how it was asked

Erik Reasonable Rates Darling

🙄

Paul White

22:04

Love you all and your addiction to commentary

4

Hannah Vernon

I was just going to say nice edit

Paul White

Every time I started on it, a new and irrelevant bit of chatter turned up

Hannah Vernon

Who starred that

Paul White

Not me, prob Erik

Or the phantom

Hannah Vernon

My money's on that

Paul White

22:08

You just never know with a phantom

Erik Reasonable Rates Darling

wasn't me

i only star nice things

Paul White

Well, there you go then

Phantom strikes again

Hannah Vernon

maybe it was Z

maybe Z is the phantom

Paul White

Nah

Zed's dead, baby

Hannah Vernon

who's chopper is that

Paul White

22:13

Oh, actually that makes sense 👻

Erik Reasonable Rates Darling

died of embarrassment from that answer probably

Paul White

Was a shocker

Imagine preserving it

Hannah Vernon

that's what was running through my head just a moment ago.

Paul White

Never understood the fascination with adding edit and update and whatnot
There's a complete revision history right there for anyone who cares

Hannah Vernon

I was tempted to edit the question, but good lord there is nothing good that can come of that question without making it just "how do I change an int to a bigint without downtime"

Paul White

22:15

I just shoehorned their comments in. It broadly makes sense, but they can edit it if they want to

Hannah Vernon

@PaulWhite it's so weird

Paul White

I don't mind the 👋 new ones because SO/SE don't exactly go out of their way to make it discoverable

Sadly, UI improvements are just impossible

They spent all their money and time on a Stacks framework to make future changes to the UI easy

Hannah Vernon

I think people believe they need to keep it as a conversation, and not just a single question, hence the "edit:" header

Paul White

Perhaps we should start Database Conversations Stack Exchange for them

Hannah Vernon

hahahahah no

it could just be all comments and no content

Paul White

22:18

Moving comments to chat was a good start, but they never followed through with move the entire Q & A shambles to chat and bury it

Hannah Vernon

@PaulWhite what do you mean "new ones"

Paul White

@HannahVernon Yeah, but then it would be their problem. I don't propose to ever visit the site myself

Hannah Vernon

good point

Paul White

@HannahVernon 👋 New Contributors 👋

Hannah Vernon

oh

Paul White

22:21

Poorly expressed. I meant I could understand it from people unfamiliar with our site

It's rampant on SO, of course, as are all bad things

Hannah Vernon

gotcha

I try to avoid SO like the plague it is

I tried to get rid of a couple of terrible questions I created a decade ago and got denied for "vandalism" lol

literally trying to help clean up and that's the thanks I get 😂

Paul White

I just deleted my account

Created another one l8r, don't quite remember why

Erik Reasonable Rates Darling

probably to do a kindness

Paul White

sadly, that's probably true

I'm such a sucker

mustaccio

22:36

That blue-green question makes me blue in the face and green with despair. My (helpful) comment was ruthlessly deleted by someone; pasting the question title produces a large number of helpful results (from SO, no less), but LMGTFY is unacceptable;

the question is heavily upvoted despite showing no effort to find an answer

and is too broad

What's a girl to do

Erik Reasonable Rates Darling

Get pregnant

mustaccio

I'm already pregnant, with thought

as you can see above

Paul White

@mustaccio Something different?

Have you considered fishing

Crochet perhaps

mustaccio

do girls fish

Paul White

sure

Erik Reasonable Rates Darling

22:40

Yes, just not for fish

mustaccio

I'm not that kind of girl

crochet sounds enticing

this being winter, especially

Paul White

It's not far from crotchety

mustaccio

I'll get there, I'm sure

grab her by the crochet

I'll go git some orphan branches for now

Erik Reasonable Rates Darling

You could get into baking

Grab her by the pastry

mustaccio

oh, that I do regularly

you should see my sourdoughs -- can be used as curling stones, easily

Erik Reasonable Rates Darling

22:49

Very Canadian

mustaccio

eh, eh?

Erik Reasonable Rates Darling

My wife recently tried to do a thing with sour dough. Got some good crackers out of it.

mustaccio

I know, mine's also cracking with laughter

Erik Reasonable Rates Darling

Hopefully with everything bagel seasoning

Paul White

23:06

Erik Reasonable Rates Darling

What a prompt engineer

Paul White

Same prompt, improved Grok

x.ai/blog/grok-image-generation-release

Erik Reasonable Rates Darling

Oh cool

I’m trying to decide what level of insufferable I’ll have to reach to start making AI videos

Paul White

Results are not always gr8

🤣

Maybe that was an early creation effort

Erik Reasonable Rates Darling

Basically a platypus

Paul White

23:14

The rest of it is so good

Fresco style and all

But the frog 🤣

It's like it just gave up

Erik Reasonable Rates Darling

Maybe it was trained on the Wordles in here

mustaccio

Erik usually gives frog credits for that

Paul White

Well, the Wordle grid format is quite limited

decent effort

Erik Reasonable Rates Darling

Great frogs there

Happy little things

Paul White

I think I like the first one best, but they all have their charm

Erik Reasonable Rates Darling

23:30

I had a nice chat with the AI video monkey about its capabilities. Might mess around with it tomorrow when I’m at a computer again.

Wonder how they’ll share in here

Transcript for

The Heap™ – Consultancy ©®