The Heap™ – Consultancy ©® - 2022-10-21 (page 1 of 2)

J.D.

01:26

@ErikDarling Mm fair point. But ok.

@ErikDarling In all seriousness, what if there is no table variable used, but it's still multi-statement?

Scratch that, I'm still an idiot... J.D. was a mistake. 😐

Zikato

06:08

Morning

John K. N.

Morning

Paul White

Morning

John K. N.

09:50

@PaulWhite puzzled look

Paul White

Oh sorry wrong room

(it was a cricket score)

John K. N.

10:23

I thought as much.

ypercubeᵀᴹ

12:36

@J.D. feel free to put my comments and links in your answer.

J.D.

13:12

@ypercubeᵀᴹ Done deal, thanks! 🙂

ypercubeᵀᴹ

Redshift probably has the standard_conforming_strings) setting to off (the default is on since Postgres version 9.1 but Redshift being fork from older version that explains it) — ypercubeᵀᴹ 41 mins ago

and I do notice the parentheses mismatch :(

Erik Darling

i'm willing to forgive you but i don't speak for the group

J.D.

@ypercubeᵀᴹ Gotcha, good to know. Cheers!

Erik Darling

14:28

HAPPY FRIDEE

Sean Gallardy

seems questionable

Paul White

Is Saturday

bbaird

Lies

Paul White

checked, confirmed

Sean Gallardy

Confirmed lies?

Paul White

14:40

local factors

Sean Gallardy

"works on my machine"

Did that upgrade ever finish?

Paul White

Well, it got to the point where it wanted to reboot

I left instructions but have heard nothing back so far

But they're v busy people

Obviously

bbaird

I checked the UTC timestamps and...

Sean Gallardy

Might have shutdown, that upgrade might not happen for another year

ypercubeᵀᴹ

@SeanGallardy I have moved

@PaulWhite wait another year ;)

Sean Gallardy

14:46

@ypercubeᵀᴹ 👍 Lichess doesn't let me know and when I get busy I forget to check

Paul White

@ypercubeᵀᴹ You'd think old people would be in more of a hurry

Gradually teaching Sean how to use the site. He's got the hang of flagging obsolete comments, just need to get him not to leave them in first place.

Zikato

9 mins ago, by ypercubeᵀᴹ

@PaulWhite wait another year ;)

Paul White

yesterday, by Paul White

Nov 30, 2012 at 2:40, by SQLkiwi

Regarding The Battle, progress is slow, but I'm in it for the long haul :)

Sean Gallardy

29 secs ago, by Zikato

9 mins ago, by ypercubeᵀᴹ

@PaulWhite wait another year ;)

ypercubeᵀᴹ

@Zikato no, we finished the games in blitz fashion, a few min ago!

Paul White

14:56

Is a v slow learner

Sean Gallardy

I died in both games

tragic deaths

opine my loss

Paul White

> If you make this into an answer I'll upvote and mark it.

ypercubeᵀᴹ

I'm sure a good port will soften the hit

Sean Gallardy

I fully expected to lose

Paul White

@PaulWhite Saddest words in the world

Sean Gallardy

14:57

also not use to the way it was moving and not asking for confirmation

I told you all I am not good

Zikato

Nonsense. You've practically beat me and I used to be good.

Paul White

No one's any good at Chess until they've been SUED for $100M

Zikato

Everbody in the kindergarten was afraid to play against me

some few years back

Paul White

Still true now

Zikato

now more than ever

Paul White

15:05

They should've learnt to read

J.D.

@PaulWhite and no small fluffy bunnies were harmed today...at least for that one. 🙂

Paul White

Sadly, a bunny was killed

Oct 13 at 14:57, by Erik Darling

@PaulWhite every time you comment-answer, god kills a bunny

Can't be resurrected when an answer appears later, sadly

Those are the rules

J.D.

😐 who makes the rules?

Paul White

No idea. I'm just a dumb enforcer

Bunny dead

J.D.

Fair enough.

Sean Gallardy

15:14

@PaulWhite Only thing left to do is eat the tasty rabbit

Paul White

You monster

17 mins ago, by Sean Gallardy

I told you all I am not good

So true

Sean Gallardy

lol

I raised rabbits before, I also ate them

J.D.

Reminds me of a bit of irony IRL. One time I was in Lancaster, PA and saw a sign for dwarf bunnies for sale. (Small fluffy bunnies heh.) Pulled onto the farm, and an actual dwarf person came out holding the dwarf bunnies. Sadly he wasn't fluffy himself.

Sean Gallardy

same with cows, pigs, and chickens

@J.D. You were so close to where I lived and you didn't stop and say hi

wow.

J.D.

lol for reals? I still have a house near there actually, East Earl to be precise. Around the corner of Shady Maple.

Paul White

15:17

Another dev with a housing empire, like Mr Darneli

Sean Gallardy

Yeah I used to live up in PA

bbaird

I grew up east of there in West Chester

Back when there were dairy farms and not subdivisions

J.D.

Cool cool cool.

Lot of buffets around that area. Never saw bunny on the menu though.

Sean Gallardy

I grew west of you all, around Johnstown, then moved to Willow Grove

Paul White

@J.D. They've learned not to comment-answer the hard way

J.D.

15:21

Hah, I don't think the Amish have computers so that's probably more so why they're not up in here making a muck of comments.

bbaird

Brother Josiah is not amused. He told me that via letter written by candlelight.

Verbatim: "You English may think us simple because we don't use the Devil's box, but there's nothing simple about living a good life free from the corruption of technology."

Paul White

Very wise

bbaird

Actually, I don't think the Amish ever have to deal with MongoDB, and that's a attractive aspect of the community.

3

J.D.

@bbaird Lol facts.

Sean Gallardy

That's a sign near where I grew up

Paul White

15:25

You never grew up, Sean

Sean Gallardy

I sit corrected

I have no plans, either

Paul White

Very wise

@SeanGallardy As is clear from your Chess playing

Sean Gallardy

@PaulWhite You're not wrong.

Paul knows much about me, I think he's internet stalking me

ConcernedOfTunbridgeWells

Scrum master demonstrating the value brought to the project today -

Paul White

The first image made more sense

ConcernedOfTunbridgeWells

15:30

In related news, Liz didn't outlast the lettuce.

Paul White

Neither of them did

tbf Queen Liz was at a bit of a disadvantage

ConcernedOfTunbridgeWells

Indeed. Clearly the other Liz was enough to push her over the edge.

Paul White

Fits the facts

Sean Gallardy

Most people need to go on a diet first, crazy it fit first try

Paul White

One amusing possibility is to end up with the same PM and Chancellor as a few months ago

ypercubeᵀᴹ

15:37

@PaulWhite I'm sure there are bets on that

ConcernedOfTunbridgeWells

Cheer up, they said, things could be worse. And then -

Paul White

@ypercubeᵀᴹ It's amusing it's even a non-zero possibility

ConcernedOfTunbridgeWells

Says a lot about the standard of the other candidates.

My money is on Jacob Rees-Mogg.

Paul White

OMG

Can you imagine
You think the world's laughing at the UK now

bbaird

@ConcernedOfTunbridgeWells You could be making up that name and honestly I wouldn't know

ConcernedOfTunbridgeWells

15:39

Well, it has been observed that now we're out of the EU, we are actually free to re-instate the death penalty for treason.

I'm pretty sure folks would pay good money to see Jacob Rees-Mogg hung, drawn and quartered.

Sean Gallardy

@PaulWhite No, we've been laughing since the late 1700's :D

You think the world's laughing at the UK... look at us

Paul White

Indeed

ConcernedOfTunbridgeWells

Well, yes, from the could-be-worse desk.

Sean Gallardy

I have two words for you "Look at US"

Paul White

ha ha ha

I understood that reference

Sean Gallardy

15:41

:O

I thought that was going to be a JEAGL

I'll try harder next time

Paul White

Maiden America lol

Sean Gallardy

I don't think that amount of brain power exists, currently

Paul White

I'm trying to remember the last US president who didn't seem overtly ridiculous

Obama?

Before that was dubya

bbaird

How Biden is ridiculous?

Sean Gallardy

@PaulWhite Probably the original Bush

Paul White

15:44

@SeanGallardy George HW?

Sean Gallardy

yeah

Paul White

I just looked up the list. It's a lot shorter than I expected

Cade Roux

Didn't he throw up on the Japanese Prime Minister and pass out, though?

Paul White

Ooo did he

Sean Gallardy

That would be HILARIOUS

bbaird

15:45

No, GHWB was pretty clownish - puking I won't pin on him

Paul White

Jimmy Carter then

Sean Gallardy

Taft

I'm going with Taft

Paul White

I just about remember him (Carter)

Cade Roux

George H. W. Bush vomiting incident

On 8 January 1992, about 20:20 JST, while attending a banquet hosted by the Prime Minister of Japan, Kiichi Miyazawa, U.S. President George H. W. Bush fainted after vomiting in Miyazawa's lap. Doctors later attributed the incident to a case of acute gastroenteritis. == History == George H.W. Bush rang in the New Year of 1992 with a 12-day trade-focused trip to Asia and the Pacific to discuss America's post-Cold War readjustment of economic relations and policies. On 8 January 1992, Bush played a doubles tennis match with U.S. ambassador to Japan Michael Armacost against Emperor of Japan Akihito...

Sean Gallardy

@CadeRoux lololol

J.D.

15:46

Theodore Roosevelt wasn't too bad, TBH.

@CadeRoux also lololol.

Paul White

It sounded real but I can't honestly say I remember that well

The 90s were a bit of a haze

Sean Gallardy

Purple?

Paul White

Nah that was the 70s, surely

90s was all acid

I see no one stepped forward to propose Ronald Raygun or Bill Clinton

Sean Gallardy

No steps forward, maybe a few knees forward

Paul White

Richard Nixon was president when I was born

Sean Gallardy

15:52

Reagan was for me

Paul White

wow

bbaird

Carter

Paul White

I suppose it's a bit like the Olympics

Every four years

But they tend to do doubles

Erik Darling

the least ridiculous us president was william henry harrison

since then they have all been p. wacky

Sean Gallardy

Yeah, hard to be wacky in just 1 month

although 1841 was a crazy year

Erik Darling

16:06

that's why i like him

didn't overstay his welcome

Sean Gallardy

shortest president ever

(in the US, term wise)

Paul White

a month should be easily enough if you know what you're about

Sean Gallardy

PeeDubs for pres

Paul White

@ErikDarling wasn't he in Cheers?

Erik Darling

@PaulWhite good question

Paul White

16:08

Played Woody, I think

Erik Darling

-_____-

Paul White

Everyone seemed to know his name anyway

Erik Darling

you're fix'n t' st'w m'

Paul White

idk perhaps everyone else immediately knows who William Henry Harrison was

OMG Woody married the girl from the Raspberry Beret video

Jackie Swanson

Jackie Swanson (born June 25, 1963) is an American actress. She is best known for her role on the American sitcom Cheers as Kelly Gaines, the rich and simple love interest of Woody Boyd. == Biography == === Career === In 1985, Swanson made her professional debut in the Prince video Raspberry Beret as the girl wearing the raspberry-colored beret who hands Prince his guitar at the beginning of the song. She and Prince were friends. He wrote a song entitled "Palomino Pleasure Ride" for her. In 1987, Swanson made her feature debut in the opening scene of Lethal Weapon. She played Amanda Hunsaker, who...

small world

bbaird

Well, student loan forgiveness gets me 1550, so that's something. OTOH, I've been out of school for 10 years and paid all the high interest stuff off within the first couple years LIKE A BOSS

No ragrets

Erik Darling

16:28

@PaulWhite just when you think you can’t envy someone more

Paul White

Would've made a fine president eh

What is not clear in my question ? ? — Rollo 1 hour ago

Two question marks!

Extreme puzzlement detected

lifeisajourney

147 5

man, so true

Erik Darling

lifeisavariable

i was just going to do something

what was it

Paul White

answer a question about logical reads?

Erik Darling

sounds like a mimi

Sean Gallardy

17:03

Where is @JoshDarnell these days?

I'm trying to use a nuget package thing and it isn't working

I feel like this is his wheelhouse

Paul White

a housing empire doesn't run itself, you know

@ErikDarling did you remember?

Erik Darling

17:18

@PaulWhite yeah nah might think about it over a drink

Paul White

always a good option

if you don't remember, you won't care as much

Zikato

@SeanGallardy Add the correct package source and keep rebuilding until it works

Heap chat today:

Sean Gallardy

@Zikato I installed the package, and following the MS Docs I should be able to add the namespace. I try to do that and it doesnt' see it, but the package shows up in the solution explorer.

Zikato

Animaniacs - The Presidents Song

►

Can you screenshot it?

Vérace

A chairde - Morning all!

@ConcernedOfTunbridgeWells Seriously - Rees-Mogg? As if Britain isn't enough of a laughing stock already? I see that Johson is not the bookies 2nd favourite - and Rees-Mogg is supporting Johnson - one blind buffoon following another... I'd put serious money on Sunak right now!

Zikato

17:33

Ready4Rishi. Not2soon4Sunak 2 - Electric Boogaloo

Vérace

@Zikato The way British politics have been going, you'd be a serious candidate for special campaign manager! :-)

Or should that be campaign manager for candidates with special needs?

Josh Darnell

@SeanGallardy If you see it in the packages list in the solution explorer, then the types in the package should be available to you.

Paul White

BoJo the SQL

Vérace

Or, translated to the original IBMspeak, "BoJo, the SEQUEL"?

Or worse yet, "The Return of BoJo'?

Even scarier than the original - book your seat now at a Conservative Association near you!

Paul White

BoJo II - just when you thought it was safe to go back in the EU

> Endorsements
68 - Rishi Sunak
36 - Boris Johnson
17 - Penny Mordaunt

Vérace

18:05

It's now at ~80/40/20 - bbc.com/news/uk-politics-63343308

Erik Darling

electric bojoloo

Paul White

A run off would be terrible

Especially if the member vote reverses the MP preference like last time

Vérace

Yes, it's terrible what happens when one lets the plebs vote!

Irish RTE news - 84 for Sunak - no/little apparent movement for others...

Erik Darling

18:25

what's an irish recursive table expression

Vérace

An Irish RCTE? "It's your round!" :-)

3

Erik Darling

hah

Sean Gallardy

@JoshDarnell So clearly I'm an idiot, but that being said it doesn't work

Josh Darnell

18:41

@SeanGallardy Well shucks :( You're getting an error that the namespace isn't found?

Erik Darling

invoices are gonna be FLYING today

Sean Gallardy

I start typing in the namespace and it just doesn't' exist, won't show up in intellisense and when I type it out, complains that it doesn't exist.

Erik Darling

do any namespaces work?

Sean Gallardy

Just your mom's

but yes, I can use all the other ones

just nothing nuget wise

Erik Darling

i'd burn the whole thing down

Sean Gallardy

18:47

I do like fire...

Josh Darnell

@SeanGallardy Are you sure you have the namespace / type name spelled right?

Erik Darling

lol

Sean Gallardy

Yes

Paul White

Probably putting spare apostrophes in

Erik Darling

'postr'ph's

Paul White

18:59

nuget: package not found

Maybe USPS is delivering it

Sean Gallardy

J.D.

@SeanGallardy if you need help being more of an idiot, I've been pretty good at it this week.

Paul White

"this week"

Sean Gallardy

Are you encroaching on my market monopoly?

J.D.

I've been in the game for a while.

Sean Gallardy

19:02

I'm in the professional leagues

get on my level of idiocy

Paul White

@ErikDarling Did you ever get help with your delivery?

Josh Darnell

@SeanGallardy A NuGet package can have multiple assemblies with different namespaces in it. It's convention to have the package name match the namespace, but it's not required. Do you know the class name that you need out of that package? If so, you could type it into the program, and then see if Visual Studio suggests adding a using statement.

Sean Gallardy

chuffed.gif

no, how do I find that out

Paul White

You don't know the name of any class in that package?

Mystery package

Erik Darling

@PaulWhite vaguely

anyway it's very boring

like talking about weather and the past

take a picture, etc.

did any gin ever show up to you? those cretins accepted an order and then went silent.

also they only allow for one bottle per order

Paul White

19:16

Not yet

Erik Darling

upsetting

Paul White

But it's early Saturday morning so who knows

Erik Darling

how will you cope with this tumult in the uk without gin

Paul White

It's a very worrying situation

But I'll probably be ok until lunchtime

Josh Darnell

@SeanGallardy Whatever has prompted you to use that package probably included how to use some class in there to do something, right? Like documentation, a code sample, etc.

Sean Gallardy

19:18

@JoshDarnell Ha! nope.

Erik Darling

...

@PaulWhite are you sure?

Paul White

No

Josh Darnell

@SeanGallardy You could point something like dotPeek at whatever assembly is in that package - it'll decompile the DLL and you can see the types / namespaces defined inside.

Erik Darling

i read an article recently about how churchill conducted his days

Sean Gallardy

@JoshDarnell I just chatted with the author, he gave me a sample. I used his using directives and I get this.

Erik Darling

19:20

ikea code

Sean Gallardy

So the nuget is installed but the authors' example code doesn't work

something is wrong

I blame nuget

junk

Paul White

Have you tried adding a using or assembly reference

Erik Darling

don't have these problems with ssms

Paul White

@ErikDarling Try creating an add-in

Sean Gallardy

Apparently it requires .net 6

Erik Darling

19:22

seems perilous

Sean Gallardy

Too much COMplaining about addins

Erik Darling

i recently worked with a developer who had so many ssms add-ins that typing was impossible

you'd get like 4 completion dialogs and a bunch of others showing object definitions etc

Paul White

People are strange

Zikato

@ErikDarling Your brain does the translating. I don't even see the code. All I see is blonde, brunette, redhead.

Erik Darling

if this is a joke i don't get it and i don't want to get it

Paul White

19:25

Matrix

Zikato

Bingo

Erik Darling

i liked the book better

J.D.

I like tables better

Josh Darnell

@SeanGallardy Oh so that was the problem?

Sean Gallardy

@JoshDarnell no idea

It's still not working

Paul White

19:27

We need a standard .net

A unifying one

Zikato

Sean is working on the mystery project I wanted to try it out, but there are plenty of debugger NuGets

Sean Gallardy

Yeah, I'm trying to use the "don't have to know about COM" wrapper around enghost so I don't have to write interfaces in C++ for IDebugClient 1-8

Erik Darling

this is the opposite of consulting

Sean Gallardy

Not even hyperbole.

Paul White

Is this how you people live

Zikato

19:30

Dependency hell

Dependency hell is a colloquial term for the frustration of some software users who have installed software packages which have dependencies on specific versions of other software packages.The dependency issue arises when several packages have dependencies on the same shared packages or libraries, but they depend on different and incompatible versions of the shared packages. If the shared package or library can only be installed in a single version, the user may need to address the problem by obtaining newer or older versions of the dependent packages. This, in turn, may break other dependencies...

Sean Gallardy

use nuget they said, it's easy they said, it's the best they said

Paul White

@ErikDarling invoices are supposed to be FLYING today

Zikato

@SeanGallardy Don't NuGet it?

Sean Gallardy

All air traffic is cancelled for today

Paul White

@Zikato So it depends then

Zikato

19:32

let me search the transcript

Sean Gallardy

There will be none of that going on here

Cade Roux

Sean Gallardy

We do not consult the documentation, nor do we search the transcript. This is the way.

Paul White

To dependency hell

Cade Roux

Just run apt-get until it says there's nothing left to do, right?

Paul White

19:36

Seems like Sean might need a New Get

PSS Diag might fix it

Erik Darling

ted nuget

Sean Gallardy

PSS diag wouldn't have these problems, just sayin'

Zikato

Can I offer you a nugát instead?

Nugát

Nugát je cukrářská hmota vytvořená z cukru nebo medu, pražených mandlí nebo oříšků (vlašský ořech, pistácie a lískový ořech jsou nejběžnější) a doplněná dalšími složkami (například kandovaným ovocem). Často se používá jako náplň bonbonů a čokolády. == Historie nugátu == Názory historiků ohledně původu nugátu nejsou jednotné. Podle některých historie této cukrovinky sahá až do dob starých římských časů. Původně to měl být pokrm z medu, mandlí a vajíček, určený jako oběť bohům. Slovo nugát (nougat) pocház z okcitánského pan nogat (výslovnost: [ˈpa nuˈɣat]) (ořechový chléb/chléb s ořechy). P...

Josh Darnell

@SeanGallardy If you want to jump on a Teams call and look at it let me know. It's got to be something simple I'd think, and we're just missing it. Like the package is installed in a different project than where you're trying to use it.

Zikato

@JoshDarnell you said the T word

Paul White

19:42

Did anybody ever want to jump on a T call

First time for everything I guess

So funny watching Sean get support

Erik Darling

if there's an invoice involved, sure

Zikato

@PaulWhite I once worked on a database from dependency hell. Two-way foreign keys. A user who's default schema was owned by him. Circular linked servers

Paul White

Josh should have outsourced it

Cade Roux

It's all I use, always with a screen share back and forth. It would be really great if I could share my right screen and they could share one of their screens on my left

Erik Darling

i'm hissing

is anyone else hissing

Zikato

19:44

maybe you're the heir of Slytherin

The Chamber of invoices has been opened. Enemies of the heir, beware

Erik Darling

this sounds like reddit things

Paul White

Harry Potter

Do you know no references

From popular culture

Zikato

20 mins ago, by Erik Darling

i liked the book better

Erik Darling

i have a cutoff date

Zikato

I'll try greek mythology next

Erik Darling

19:46

i don't remember most of the 2000s

when did can't hardly wait come out?

Sean Gallardy

@JoshDarnell Yeah if you have a moment

Paul White

I'm hissing = really excited in NZ. Took me a moment to work out you were being literal

Zikato

"really excited in NZ" is a very specific phrase

Erik Darling

boo hiss etc

Josh Darnell

@SeanGallardy I will at 4

Paul White

19:48

Yeah I got it now

Sean Gallardy

@JoshDarnell sent

Zikato

@ErikDarling Had to google that, but 1998

Paul White

@Zikato Proper punctuation is stupidly hard on mobile

Man, I so hope Gallardy is doing something really dumb

Erik Darling

@Zikato yeah i think that's my high water mark

Paul White

A spelling mistake would be perfect

Zikato

19:51

@ErikDarling what's your low water mark?

Sean Gallardy

@PaulWhite That makes 2 of us

@Zikato Ghost cleanup

Paul White

Did anyone suggest turning it off then on again yet

Erik Darling

the guy at the aa meeting said i haven't hit it yet

Zikato

@SeanGallardy Is that a Ghost Busters rip off?

Sean Gallardy

Nah, it's the crew that comes in behind them and cleans up all the ectoplasm

or ghost DNA

Zikato

19:54

A box office hit

Sean Gallardy

I'll leavestream the T call

Paul White

I like the idea of a leave stream

Erik Darling

josh is $4.99 for the first minute and $1.99 for every additional minute

Zikato

Send the link, I'll prepare the popcorn

Paul White

Everyone joins the stream, then Sean just leaves

Classic

Transcript for

The Heap™ – Consultancy ©®