Morning

Morning

Morning

morning and evening

sigh

morning

@PaulWhite A 50 rep user gets it apparently

:43505674 Yep sorry was formatting the other answer.

@TomV :)

It's all right. I would've edited it myself after the grace period if you hadn't.

Someone ask me if I ever get tired of doing this dba.stackexchange.com/posts/201761/revisions

@PaulWhite no, you don't

Someone ask me if I want to read a pissing contest when i get in.

@dezso Oh well have I got news for you

@gbn hm? where?

top of my screen. We moved the crypto chat to slack out of courtesy. Do I want to read "says the guy who calls a bloated inefficient clusterfuck a "SQL Server."" and other such gems.

Take your pick iamadrainonsociety.wordpress.com/2014/04/07/…

Oh I see. Hadn't had chance to look at the transcript yet.

btw what is "crypto chat"?

bitcoin etc. Sorry, crypto currency

goes to read transcript

doesn't seem to be anything actionable there

just skip stuff you don't want to read, I guess

It's not about actionable, and I do skip most of it. But notice that some people are here a lot less then they use to be...

Must ha' missed summet

Morning

So this question already had a tag visual-studio . Suggested edit was to add tag visual-studio-2017 (yes, it is mentioned in the question). MdHaidarAliKhan and JJussi reviewed and suggested to add the tag. Is that a substantial edit?

dba.stackexchange.com/review/suggested-edits/109425

@PaulWhite Rubbing ear Woooozaaaaa!

@hot2use top tip on lard for Rösti BTW. Apropos of ages ago

@gbn You're welcome.

@hot2use I skipped it because I didn't care either way.

I did the same for this one, approved by the same two people. It did seem to me more a response than an edit but in the end it was difficult to determine from reading the post itself.

@AndriyM Well the last image was broken, and the language wasn't great. I fixed those up. I guess the author of the answer can judge if it's a good addition or not.

@gbn I hadn't really noticed, to be honest.

Chat participation in the heap has always been a bit variable.

@JackDouglas Have you made any progress getting DB2 onto dbfiddle?

Is comment converter suggesting edits now? :)

@TomV Once in a while.

It gets bored.

@dezso Pfft - my phone's .. oh, hang on.

@MichaelGreen did you buy TomTom's?

@dezso Does he still run SQL Server on his phone now they made the switch from cpu to core licensing?

@dezso :-)

@PaulWhite not yet :S

SSMS 2017 has a "vulnerability assessment" menu item for each database; it returns this "failed" security check about the DAC:

> The Dedicated Admin Connection (DAC) is intended to be used by administrators for troubleshooting in scenarios when normal connections are not available due to an abnormal state of the system. For scenarios, other than clusters, the DAC is intended to be used only on the same node, and not remotely, to prevent automated attacks against this entry point.

isn't that a bit stupid? I mean wouldn't you really want to have it enabled for remote access in case the server is so busy you cannot even login to it?

Should that be a question on Database Administrators?

@JackDouglas is there even an evaluation version of it that you could use there?

@MaxVernon What I would expect, and I've had to use the DAC recently too from another server

Where do you see this?

@MaxVernon blog about it ;)

i bet it'd make a weekly link

@sp_BlitzErik sounds like a challenge to me!

that's a screenshot of the result

that's real goofy

@MaxVernon I wouldn't trust your assessment about vulnerabilities though, did you ever pass that security test?

;)

cheeeky!

Never mind, I'm on SQL Server 2005

Then it doesn't :)

Otherwise it supports target names with up to three parts (you can't merge into a table at a remote server using the four-part notification), according to the manual.

@sp_BlitzErik does this work? sqlserver.science/security/…

I really need a better header / logo etc for that site.

plus it might help if I blogged more often than once a year.

Evan runs Windows. What does everyone else run?

@Philᵀᴹ RSX 11M+

@Philᵀᴹ Does he need rebooted?

@MaxVernon sure, will pass it along

cheers!

I'm on macOS primarily (and have been for 10 years), but I have 2 Windows VMs that I use for SQL Server (though SQL Operations Studio is getting there), and <3 Unix

@Philᵀᴹ AIX at work is fun.

I play video games so Windows it is, although I am looking at what will run on Linux now. Just need some spare time

@AndriyM thanks

@MaxVernon I think I have ideas

@dezso I'd love to get input!

@Philᵀᴹ Ubuntu 16.04

@MaxVernon well, ask @Taryn first

@ypercubeᵀᴹ I think they also want to skip the rows where the email already matches the primary row

> I want to update the users primary address to the rest of the users where it's different.

@AndriyM Ah thnx. Didn't read that.

The whole thing looks silly to me to be honest, that's why I haven't answered (except in comments, for our mod's rejoice ;).

Yes, sometimes a question is dealing with a silly scenario and you are not sure whether the OP is trying to perpetuate it or to normalise things.

Another one of this kind was the one about parsing a column description to use it as a lookup table

A well-presented question, which I actually upvoted, but in the end I wasn't sure what we were helping there.

I'm glad the accepted answer is talking about creating an actual lookup table

@ypercubeᵀᴹ yay

@dezso what?

cya tomo

@AndyK I was to suggest something dynamic

@sp_BlitzErik there is a free version called Express-C

@MaxVernon So I looked into it more (for that answer) and what a rabbit hole that was

@SeanGallardy-Microsoft sounds interesting!

It's not complicated on the surface but stupid complicated because you can add whatever you want.

extensibility strikes again

There are two different limits that could be hit... and it's easy to tell which one (the error number and message) but it's too internal for a full post (nor does my 30 minutes of looking into it mean I'm the expert on it)

So I think I'll leave the answer somewhat... bland? You can edit it if you don't think it's good enough.

We could make it community too, not sure what all that does

@MaxVernon Pretty much

@SeanGallardy-Microsoft if I get a chance soonish I'll look at it. Right now, I'm on other things, and have to go out later on.

I must bear a hand to my sister with one c++ exercise on linux. Can you suggest any lightweight linux distro? Basically I should install gcc

@McNets do something easy like Linux mint, Ubuntu, you could use it as a live boot and not even worry

@SeanGallardy-Microsoft what about lubuntu?

Never tried it

@MaxVernon Mr fancy pants - going out :)

@SeanGallardy-Microsoft yah, they only let me out once a month :-)

If I'm good.

How do I sign up for that?

I know, right!

@McNets xubuntu, kubuntu, lubuntu, and ubuntu are different only in their graphical environment - in this case it also means a different set of utility programs. lubuntu is the lightest, so I guess it's the best fit for you.

@dezso thank you

@McNets distrowatch.com/?language=EN

Always a good starting place.

> Scientific Linux is a recompiled Red Hat Enterprise Linux, co-developed by Fermi National Accelerator Laboratory and the European Organization for Nuclear Research (CERN). Although it aims to be fully compatible with Red Hat Enterprise Linux, it also provides additional packages not found in the upstream product; the most notable among these are various file systems, including Cluster Suite and Global File System (GFS), ...

> ...FUSE, OpenAFS, Squashfs and Unionfs, wireless networking support with Intel wireless firmware, MadWiFi and NDISwrapper, Sun Java and Java Development Kit (JDK), the lightweight IceWM window manager, R - a language and environment for statistical computing, and the Alpine email client.

distrowatch.com/search.php

@hot2use Thanks, I'll take a look

Weee that was fun

Girlfriend totally dropped a pint of diet coke on my keyboard yesterday

just took it apart and cleaned it, and got it back to work again

wtf, "I run Windows" got 6 stars.

How else will I play blizzard games?

@EvanCarroll I play 4 different Blizzard games on my Mac

Overwatch?