The Heap™ – Consultancy ©®

1:01 AM

@ypercubeᵀᴹ if you hadn't yet, let me suggest The Queen's Gambit

3:12 AM

Wife is watching it right now (well, restarted as she fell asleep while I took the dog walking) but seems good from what I've caught

Tom V

6:56 AM

@MaxVernon I'll turn the comment into an answer if my guess is right and I'm on an actual computer

Oh didn't notice it was such an old question

John aka hot2use

7:20 AM

Morning

~~again~~ still

Andriy M

7:47 AM

Morning

McNets

Morning

ypercubeᵀᴹ

8:39 AM

@McNets thnx, it's on my list

Tom V

8:55 AM

@McNets Thanks, added as well

McNets

Sorry @TomV, @billinkc, my suggestion was for everyone

Max Vernon

10:30 AM

@TomV thanks - it needs sn answer!

Tom V

10:40 AM

@MaxVernon It has one now!

Max Vernon

@TomV cheers!

Tom V

Hmm, I thought there was a badge for answering an old question. Must have been a hat then

Paul White

You need +2 (revival, 30 days) or +5 (necromancer, 60 days)

and to wait for the badge awarding job to get around to it

Andriy M

10:56 AM

So much impatience these days

3

Paul White

It's a virus

781

Q: What are the badges I can earn on each site, and what are the exact criteria for earning each badge?

Formerly List of all badges with full descriptions. What are badge name's requirements? Why didn't I get badge name (right now)? Which badges can I earn multiple times? Jump to: Question Badges Answer Badges Participation Badges Tag Badges Moderation Badges Other Badges Area 51 Badges ...

Tom V

ah yes I overlooked it

Not that I really care about actually obtaining the badge, rather I was wondering which one it was

Paul White

dba.stackexchange.com/help/badges/59/revival?userid=39384

Tom V

I answered the question to give Max a sense of authority after he demanded and answer

Paul White

well you wouldn't want him to remove your room owner status

Tom V

11:03 AM

Can't be trusted

Paul White

power corrupts

so I hear

@TomV your badge has arrived!

wear it with pride

Tom V

it's my 10th revival badge apparently

Paul White

indeed.

Tom V

I'm so proud, I should call my mom to tell her

Andriy M

Explains why Tom wanted it so badly, that's a nice round number

Paul White

11:10 AM

I wonder who has the most

probably aaron

Tom V

I think Max went on an old question spree a few years ago when he wanted his SQL 2000 gold badge or something

Paul White

heh

oh ha ha I just checked on SEDE and it's me (63)

Murali Dhar Darshan

Hi Paul,
select ascii('ä' collate SQL_Scandinavian_Pref_CP850_CI_AS), ascii('ä' collate Finnish_Swedish_CI_AS)
select ascii('a' collate SQL_Scandinavian_Pref_CP850_CI_AS), ascii('a' collate Finnish_Swedish_CI_AS)

ascii values differing for special chars

Paul White

yeah

Murali Dhar Darshan

is there could be any other mechanism through which this could be achieved...like capturing the data using CDC and transfter them through SSIS packages

Paul White

11:19 AM

6

Q: Changing collation of SQL Database in Production environment to minimize downtime

We have a scenario in which we want to change the collation of our production database (including columns) from SQL_Scandinavian_Pref_CP850_CI_AS to Finnish_Swedish_CI_AS. We have developed scripts to do that. But executing this script in a large database of size more than 100GB will take conside...

sql-server transactional-replication collation

Murali Dhar Darshan

Yes...talking about the same issue.

Paul White

I added it so others could see the context

Murali Dhar Darshan

Yes, Thank you :)

Paul White

@MuraliDharDarshan I doubt it, but it's not my expert area. You might have to translate the mismatched characters manually.

Josh Darnell

What could Solomon possibly be doing that he hasn't written a 20,000 character answer to that question by now?

3

Paul White

11:21 AM

There's a generic 'best fit' algorithm that attempts to match appearance because it's just not feasible to map characters from every collation to every other that would need it.

Tom V

@JoshDarnell 😂

Paul White

@JoshDarnell Probably scared off by the replication element idk

McNets

@AndriyM youth!

Murali Dhar Darshan

Apart from replication, if there could be any other mechanism competent enough to provide data may be on daily basis, then also we can think about that...

Paul White

I get the feeling what you want to do can't be done automatically

Due to the lack of a mapping

Strings can be a pain, just like dates, times, and pretty much everything else

ypercubeᵀᴹ

11:27 AM

@PaulWhite you ! 63 revivals

Paul White

Solomon's usually pretty hot on the collation questions so I guess he has nothing of interest to say about it?

ypercubeᵀᴹ

Max 58
Rolando 40
Solomon 32

Paul White

11 mins ago, by Paul White

oh ha ha I just checked on SEDE and it's me (63)

That does seem like a lot seeing as I don't really answer all that many questions.

Clearly I dwell on the sea floor.

Feeding on old scraps.

Andriy M

Must be causing you so much pressure

Paul White

You have no idea

❌👁‍🗨🦌

Andriy M

11:32 AM

Nice, though doesn't work as well with a rhotic accent

Paul White

blame Unicode mapping

ypercubeᵀᴹ

11:49 AM

We moved to the cloud. No one told us there was storm coming...

Paul White

well every cloud is seeded with silver

or something

John aka hot2use

12:14 PM

@PaulWhite data is a pain if you don't leave it with its preferred collation

Peter Vandivier

12:27 PM

@Johnakahot2use jollborked

Max Vernon

12:54 PM

@TomV h/t lol

Murali Dhar Darshan

Hi Paul, I discovered one scenario and I think that could be used as a solution to our problem.

6

Q: Changing collation of SQL Database in Production environment to minimize downtime

We have a scenario in which we want to change the collation of our production database (including columns) from SQL_Scandinavian_Pref_CP850_CI_AS to Finnish_Swedish_CI_AS. We have developed scripts to do that. But executing this script in a large database of size more than 100GB will take conside...

sql-server transactional-replication collation

I have posted that scenario as an answer to this question

Thank you for your help :)

Thank you guys :)

John aka hot2use

1:54 PM

Tired @PaulWhite ?

;-)

Max Vernon

2:09 PM

if anyone has a chance, I'd appreciate a quick look at this answer about why you should always specify a schema. The question is from a while back, so I don't expect the OP will benefit much from my answer, but new users hopefully will.

Josh Darnell

@Johnakahot2use I'm sure he encountered that answer from the review queue :)

I voted to delete.

I see Max has now "voted" as well 😀

Max Vernon

@JoshDarnell blatant plagiarism lol

John aka hot2use

Yeah, but the effort put into the lost cause....

:-)

Josh Darnell

@MaxVernon I think your answer is good. Seems like there should be a dupe around for that question though.

Max Vernon

@JoshDarnell probably more than one. The OP seems to be focused on it being more flexible to omit the schema.

Josh Darnell

2:21 PM

True. It's not exactly asking "should you always specify schema" although I think the answer to that answers the OP.

Max Vernon

I'll be back in a bit, right now I have real work calling.

bbaird

@MaxVernon Real work? I'm unfamiliar with the concept.

Max Vernon

lol

as DBAs we try to do as little of that as possible. It goes against the grain.

bbaird

Also congrats on your election

Max Vernon

thanks!

John aka hot2use

2:26 PM

@MaxVernon I followed the yellow brick road and left a comment ~~on that one~~ under the question.

However, good argumentation.

Tom V

3:46 PM

Have I complained about timezones yet?

Max Vernon

4:04 PM

no, but you should

Tom V

4:18 PM

more specifically time zone handling in javascript

It has drawn all my energy today, I don't even feel like ranting about it anymore

Mar 4 at 8:03, by Tom V - try topanswers.xyz

Time zones are still hard :(

bbaird

Are you sure your problem is timezones and not javascript generally?

Tom V

likely

and all the implementation differences between JavaScript and JavaScript

Max Vernon

JS makes me want to smash my head against a wall. That's why I never do anything with it.

that and any and all other untyped languages

OPTION EXPLICT ON lol, and strict, for that matter

bbaird

I think my head just hurts on the terrible syntax/awful number of libraries.

Max Vernon

I'm looking at a job that takes a couple of COPY_ONLY backups, then sends an email to IT folks. It has a WAITFOR DELAY 00:15:47; just prior to sending the email.

I automated the taking of backups and sending of the email so that DBAs wouldn't need to bill for 3 hours of overtime for nothing. I suspect the 15:47 might be to make it look like they were actually doing something so they can still bill for it.

(I didn't add the WAITFOR, lol)

billinkc

4:29 PM

Meh, just import the Alexandria library which in turn imports every other JS library and you're set.

Max Vernon

that's what I like about you Bill. You think outside the box.

billinkc

I'm intrigued by waiting 15 minutes and 47 seconds

Max Vernon

me too. I wonder what the 47 seconds is about

billinkc

Do they bill in 15 minute increments?

Max Vernon

try again lol. 3 hours or nothing.

I really don't get it

billinkc

4:31 PM

Oh, wow. Good on them for getting that added into the contract

Bad on them for abusing it of course

Max Vernon

yah... I'm a lowly contractor, so I don't get that bonus.

I bill for time.

the union folks love me

billinkc

I doubt your dogs even love you. (I think you're a cat person but we know cats love no one but themselves)

Max Vernon

my dogs are at my feet right now :-D

actually, they were, they seem to have abandoned me. traitors.

billinkc

Dogs also roll in poop so uhhh that can be a sign to the contrary

ConcernedOfTunbridgeWells

Ape With AK-47

►

Max Vernon

4:39 PM

lol where did you get that video of @jcolebrand !

ConcernedOfTunbridgeWells

Off the interwebs

Tom V

5:08 PM

I once got a call from a recruiter. A very nice lady offering me a full time Javascript job. I said no thanks and she must have noticed something in my voice. She asked "why is that? I'm asking an honest question I only read the words on the job description and don't really know what it means". I told her I value my sanity to work with Javascript every day

I could hear her wondering "maybe that's why all the decent candidates turn me down and have to suppress their laugh"

Max Vernon

5:21 PM

sometimes I feel for recruiters. Not often, mind you.

Tom V

5:50 PM

@ypercubeᵀᴹ @Johnakahot2use mandalorian SE2 started

Max Vernon

@TomV OH MY GOD. /turns on Disney+

that is such an exciting intro

Tom V

6:09 PM

Govt is holding a press conference

full lockdown

Max Vernon

we just had our daily case load double in one day. scary times.

bbaird

Things are bonkers here. Multiple days with 2000+ new cases

Tom V

new hospital admissions:

bbaird

oof

Max Vernon

one of our friends is an emerg room doctor here. They just told us it's 10 times worse than the media reports.

no beds anywhere

Tom V

6:14 PM

Friend of mine's wife has cancer

they're postponing her (and other patients) treatment to keep beds free

Max Vernon

wow that's hard

Tom V

I'm no doctor, I can believe that can perfectly be delayed a couple of weeks from a medical standpoint. There just isn't a way to tell that to the affected people in a compassionate way

mustaccio

@MaxVernon That's pretty much the norm in Canada with or without SARS, no?

Max Vernon

it's so hard to tell what 4 weeks of waiting will do. Could be the difference between stage 3 and stage 4

@mustaccio hahah. No, we normally have a well-functioning medical care system.

Tom V

Thing is, in March we couldn't blame anyone. It was unexpected and nobody was prepared. This time we have had 6 months to prepare and I fully blame both the folks who didn't care but especially politicians

Max Vernon

6:17 PM

agreed 1000%

Tom V

Can you believe they (government) reduced testing capacity just a month ago

mustaccio

I envy you in your Canada. In our Canada the picture is somewhat different

Max Vernon

so many 20 to 30 year olds here just going out and doing whatever they want with utter disregard

@mustaccio I didn't realize you're in TO lol

the center of the universe

bbaird

This pandemic has me hating people with a passion. STAY HOME. WEAR A MASK. The whole thing has short circuited people's ability to measure risk vs reward.

Max Vernon

yep

Tom V

6:20 PM

We had so much excess capacity in tests according to our politicians that my dad who works in a nursing home got tested (along with everybody else in the home) and it took 10 days to get the results

Max Vernon

TEN DAYS

what the actual eff

Tom V

a whole floor could've been wiped out in 10 days

Max Vernon

no kidding

I mean you don't need to be an epidemiologist to know that.

jcolebrand

@bbaird Nah, you're misunderstanding the Nazi Mindset. Especially the American Nazi Mindset. When Hitler said Uber Alles, he meant Me Over All not Us Over All. American Nazis have absolutely taken that to heart, but it appears the rest of the world has some of their own nationalists also doing the same :-(

I know too many of the American kind that truly hold some of these horrendous views, and they are the anti-mask crowd. Anti-vax as often as not too

I have not yet met one empathetic anti-masker

@TomV seems like in ten days you have the result for sure ...

Max Vernon

I think many young people are actually truly of the mindset that this only affects old white men, and old white men are expendable now.

"if we kill off a few old people who cares"

Tom V

6:23 PM

@jcolebrand not everybody gets symptoms, but yeah most will have found out by that time

jcolebrand

@MaxVernon Interesting. I haven't come across any young people who think that way. Granted, my window of young people is small.

@TomV yah that's what I meant lol. And you could have been asympt and still spread in those 10 days

Max Vernon

@jcolebrand it's not just young people either I guess. There are quite a few people who just don't care at all what happens to anyone else. It's so short sighted.

bbaird

@jcolebrand Trust me, I know how much of the disregard for masks comes from racist, fascist conspiracy nuts. But there are a lot of younger people who aren't taking it seriously.

Tom V

@jcolebrand Yeah, not this time, but the initial wave literally had whole floors wiped out at once by 1 spreader in the nursing home where he works

Max Vernon

I loved Fear the Walking Dead for how it shows what happens when everyone loses their shit.

jcolebrand

6:28 PM

@bbaird I've also found those to be the children of the first group

I agree 100% with what y'all are saying

I don't know that anyone else grew up in a fundy cult-like area like I did, where hatred of Others is so insidious but so baked-in

Here's a fun story: My dad bought some rental units in around 2002 when that was a booming period. I ask him about how that's going about 2 years ago. "Well son, it's been hard with so many folks out of work, they can't make rent. I had to start renting to the blacks because at least they get that government check." When I called him out as being racist "I can't be racist son, I'm a Christian"

Tom V

@jcolebrand I don't live in texas, I've seen people not wearing masks, or ostentatiously wearing it only half covering their face or under their chin from all parts of society, but yes especially youngsters who want to look "cool"

jcolebrand

It's so baked-in they can't see it. This was what I was steeped in as a growing human being. I know what casual evil looks like and how to listen to the people who are from these rural areas with no empathy

@TomV Oh, I watched a mother and daughter pair walk into Home Depot wearing lace masks. I could see their lipstick and teeth quite clearly.

Tom V

can't say they are mostly nationalists over here, just a bunch of kids not wanting to look uncool

jcolebrand

@TomV This wasn't just in Texas.

Fun fact: I've only lived in Texas a total of 15 years, and this particular pass I'm at 8 years and 2 weeks.

So the other 26 years of my life were not-in-TX and people can't ever remember where I grew up :D

I would say all this political chat is depressing or that we should keep politics out of it, but as what are statistically mostly only middle aged white men in this room, we are the very group that have to talk about it, statistically speaking, because the people we interact with need us to drive change.

Tom V

I mean, ineurope there are a lot less redneck type folks but just as many people who fuck around without masks

jcolebrand

6:33 PM

The fact that Poland just passed some very anti-women laws, and that the US is on the same path, is problematic. My friends in rural Russia, Australia, France tell me the same stories.

Tom V

France is moving towards the centre yes, but it comes from a start so far down the left most in the US would call it communist

jcolebrand

@TomV Yeah but the level of self-obsessed personal-privilege self-exceptionalism is probably not nearly as high as it in the US

I have hope Tom, that most of your countrymen will learn and do better.

Tom V

I'm not sure

jcolebrand

Unfortunately Trump is a sign of a planetary cancer, and not the creator of one. He's just the thing that makes you go to the doctor to find out why you have a pain.

Tom V

We have different politics maybe, but just as many idiots

jcolebrand

6:36 PM

By the time you do that, you are usually at stage 3 or stage 4 cancer, and that takes a lot of heavy medicine to fix

Or you die

@TomV At a human level, we have the same political problems. The names may be different, the amounts of funding involved may be different, but we have the same problems. We both have large groups of people who are ANGRY that there are others around them that they don't approve of being allowed to just exist.

In my case it's about 1/3 of my country

And the worst part is it's a learned behavior.

With that, I'm gonna go get lunch

Tom V

@jcolebrand That's a really good point

My sister in law is black, so my brothers kids are somewhat coffee+milk

the oldest is 7 and goes toe a running club where another kid told her "you stink cause you're black"

that's just something her parents say, she didn't invent that on her own. Most of the kids that age don't see the difference in skin color

Max Vernon

6:55 PM

@TomV for sure.

Max Vernon

7:13 PM

I love that the Speeder Bike sounds like a Harley Davidson as its driving up the "main street" of that town on Tatooine.

billinkc

@jcolebrand I now have a quest to watch for this but yes, have anecdotally observed the same

Tom V

I think the expanse is due for a new season pretty soon too

John aka hot2use

@MaxVernon we're reaching 10k a day at 8 Mio population here in Switzerland

Max Vernon

@Johnakahot2use wow that's a lot

John aka hot2use

and no lockdown

McNets

7:25 PM

we have a weird lokdown now

John aka hot2use

However, hospital cases are lagging behind.

They reckon another 7 days and then all hospitals will be full in Switzerland with Covid cases.

I've been sent into home office for the next four weeks.

Switzerland is no longer issuing quarantine for foreigners. Free entry for nearly all. I mean who wants to come here now? Switzerland is topping the charts nearly.

McNets

Here you can go to work but, you cannot move to the next region from monday to friday, and during weekend you cannot go out of your city/village

I'm WFH right now

And curfew from 22 to 6

John aka hot2use

Max Vernon

I've been lucky that I've been working from home since March 20th.

John aka hot2use

Woah @TomV. Stay safe and healthy.

@MaxVernon Good news.

Max Vernon

7:32 PM

I'm so lucky

@Johnakahot2use is that case rate per 1000 people or something?

McNets

100,000 ?

jcolebrand

I went to the office for the first time yesterday since March

And that was to take my personal effects to my car

I have about 2 more boxes to go and take off my desk/from my drawers

I only did yesterday because I happened to be driving right past the office

billinkc

Our office (13 people) went remote for all early in March but they wanted to start having normalcy around May? so they had staggered the seating so no one that was adjacent to you was in on the same day. I gave it a few weeks, even started riding my bike to work as the roads had way less traffic on them

But, I talked with the CEO and said, I appreciate the desire but I am not comfortable with the behavior I see in my fellow coworkers with regard to mask wearing. For those with offices, sure maybe they can sit without a mask on but those in the open seating... the risk to reward seemed to weigh heavily on the risk side

Max Vernon

no doubt.

what did they say?

billinkc

Other developers had already said Nope so I wasn't some brave trailblazer but I did try to do as they asked but since then, my butt's been firmly in my house

Max Vernon

7:42 PM

excellent

billinkc

He was cool, understood it wasn't looking to make people be in an unsafe environment (for all the shit I may ever talk, at their heart they want to do the right thing for both the people and the company so good on them)

Max Vernon

👍

billinkc

One of the guys in the other room (deal makers) came down with C19 this week (he'd be a go to the office person) and they've shut the office down for 2 weeks to try and clean/do whatever.

Been on vacation this week so I've missed the majority of the details but what's the phrase, "statistics are numbers until it's personal?" Well, I guess I knew a person in the SQL Server community that passed away earlier this summer from it as well

John aka hot2use

@MaxVernon per million

Max Vernon

cheers

jcolebrand

7:52 PM

Okay ... while I may not have a problem discussing politics for the most part, the fact that there's a Politics and that people are flagging things in their chats this weekend is ...

That's a thing I'm gonna keep a 10' pole's worth away from.

@billinkc i have never heard this but I like it

billinkc

Ah, a quote attributed to Stalin "One death is a tragedy, a million deaths a statistic"

2

Paul White

8:19 PM

@Johnakahot2use Permanently

John aka hot2use

8:36 PM

Weekend! Enjoy