A chairde - Morning all!

@ErikDarling My vote goes for a Hiberno-French dual-Presidency Republic - we'd get all that lovely smelly cheese and they'd have cheaper Guinness (v. expensive there - "export..." - it is stonger than the Guinness in Ireland - so we might get more bang for our buck into the bargain?

@Criggie One can only hope!

@JoshDarnell If it's a short function, then maybe. Otherwise I end up having too go all the way through it to find out what that var is anyway. Plus I just like to be explicit.

Much of the time, if you have the code open in VS, you can replace the shorthand with a more explicit version via a popup (lightbulb icon, IIRC)

Adding and removing discards is one of those options, for example

As is much of the lambda malarkey

@PaulWhite That's my next big issue

If it's good enough to be anonymous, make it a function

Really it should be a wand icon for add/remove magic

Speaking of icons, I've finally hit the age where some people don't know what the basic icons mean. I guess I'm officially old now.

I'm sure more accessible versions will be along soon enough

All of the icons will just be clouds. Want to open? Cloud. Save? Cloud. New? Cloud.

I hear auto-save-to-cloud makes all such concepts obsolete, old man

👴

There was a push, which was done without warning of course, to auto-upload and auto-update all the computers you log into with the files on your desktop via OneDrive. Guess my surprise when I logged into my build box and all of my build templates were gone and replaced with what was on my normal desktop.

completely broke my environment

The OneDrive desktop icons arrangement is maddening, indeed

@ErikDarling Not as far as I'm aware

More details about the regex private preview techcommunity.microsoft.com/t5/azure-sql-blog/…

@PaulWhite What's Azure SQL DB? Never heard of her.

No idea

Perhaps that's in private preview too

@PaulWhite bummer

yeah, it would be handy sometimes

@ErikDarling Casual look says there is not

@PaulWhite You know it's good because there is a QR code on the post.

They're so very useful

to give people malware and viruses, sure

It really irks me when we go somewhere to eat and the "menu" is a qr code

@SeanGallardy "Otherwise I end up having too go all the way through it to find out what that var is anyway" - seems like you'd have the same problem in a big function whether using var or not. Also, you can hover over any mention of the variable to see its type.

I do understand wanting to be explicit. But that seems to be the main reason (style preference). I don't buy the other reasons people give for the most part.

:65402139 Not really, instead of
var myInterface = anotherLocalVar.GetData();
var myOtherItem = myInterface.SubmitItem();
var myData = myOtherItem.DoSomething();

It's easier to read with the types (for me)

@SeanGallardy The main thing I dislike about OneDrive in our environment is that I used to be able to type "documents" into the Run box (Windows + r) and it would open my documents folder. After enabling OneDrive, for some reason that doesn't work.

Yeah the folder redirection stuff takes a hit

@JoshDarnell The null question mark usage kills me, makes me laugh every time

One day I might be at Josh's level of programming, if I'm lucky and I keep practicing

Take my flintstone vitamins

@SeanGallardy I thought about writing a .bat file that would essentially add it back, but then I kind of got used to just using the mouse like some kind of noob.

Or Paul.

@SeanGallardy Hey man, I think you're way over my head in a lot of areas. Writing filter drivers for fun, for instance.

techcommunity.microsoft.com/t5/azure-sql-blog/…

Is self-service BI REALLY FINALLY possible? Or is that going to be the new EF bogging databases down?

@JoshDarnell Now I'll just get AI to do it. Also my filter drivers aren't great, but they served their purpose :D

You've seen my web dev skills lol

@SeanGallardy i'm surprised and annoyed

@PeterVandivier Foiled AGAIN!

> The table has tens of megarows

0_0

Lakhs proper units

i choose to interpret that as meaning the table has like 35 rows but they all have gigs of off-row text

MegaRow

Not to be confused with Giga row or Peta row

what in the what

AI will fix it

Kids were just watching Over the Moon. Surprising amount of frog screen time

i was under the impression that lookups couldn't be used during index creation

I'm torn... on one hand, I want to write an answer to some questions... but on the other, it'll turn into a dissertation because some special user never marks answers and only keeps asking questions while arguing with you.

O wise chat, what shall I do

<shakes chat like a magic 8 ball>

Answer the question and flag all the comments as no longer needed

You can choose to update your answer to reply to the comments of course

Which is the preferred way of dealing with follow ups that are in scope

<Paul voice>

If someone keeps asking new questions that are basically the same as each other, then flag as a dupe of the best one (perhaps the one with the most/any answers)

Otherwise "comments are ephemeral and only exist for long enough to improve/clarify the question/answer"

@Criggie This person likes to do the opposite. Ask a few question in the OP, then leave comments on your answer asking new questions, quoting sentences out of context and then pretending like they can't read.

Also never marking items as an answer

eugh - yeah they're bored and its a social interaction more than a question

Well what should we do with this bloke who can't even decide what their question is about

Every bit of that is infuriating

To be completely honest - I know fuckall about databases so can't comment directly. But I'm a sysadmin and work next to the DBAs.

However - that question doesn't seem to have a question

the text doesn't match the title question, right ?

If it can be saved with edits, let-rip. If not - VTC as "more detail needed"

You should tell them SQL Server is using too much memory

and that Mauve has the most ram.

@Criggie “the chartreuse CPU needs to be rebooted”