The Heap™ – Consultancy ©®

Evan Carroll

1:33 AM

hahah cool

TIL there is a 10s compliment

Paul White

2:57 AM

@ypercubeᵀᴹ Moderator on Code Review

18

Q: Putting down my mug

I joined CR in May 2013, but only started living here in September of that year. I remember very well then, the site had been in beta for almost 1000 days, and I kept thinking that was a shame, CR was such an awesome twist of the Stack Exchange format, it had to "graduate". Soon I met folks that...

Two vacancies on CR in fact: codereview.meta.stackexchange.com/questions/8661/…

Jack Douglas

8:24 AM

→ 1 message moved to Trash

hot2use

11:15 AM

hello

Last chance for comments before the sites go down.

I second renaming the chat

...or extending on the description:

General on- and off-site discussion for dba.stackexchange.com. Jokes explained at great length (JEAGL) please. Monty Python is considered to be philosophical

Paul White

11:39 AM

I suppose we could add python :)

1h 20m to go I think @hot2use

ypercubeᵀᴹ

feeling non-grumpy today, 3 reopen votes casted!

hot2use

@PaulWhite haha. Yeah.

@ypercubeᵀᴹ I only voted to reopen two

ypercubeᵀᴹ

11:54 AM

@hot2use history says 3: dba.stackexchange.com/review/reopen/history

hot2use

ooops

I thought I'd do some house-keeping before the site goes down.

17 mins ago, by Paul White

1h 20m to go I think @hot2use

Taryn

@PaulWhite about an hour now, we're doing other servers stuff first

Paul White

@ypercubeᵀᴹ Lots of good edits after closure and reopen votes recently. Good to see!

@Taryn Thanks.

Paul White

12:43 PM

Stack Overflow SQL Server Upgrade (2016 to 2017)

►

Live stream link because none of you read featured meta

sp_BlitzErik

Why isn't @Taryn on?!

Taryn

@sp_BlitzErik I'm sharing a screen

I've been on since the start

sp_BlitzErik

Get on cam and snort a line of whey

Taryn

lol

Paul White

I expect to hear a shout out to The Heap

Taryn

12:50 PM

I'll try :P

Paul White

We should choose unlikely phrases for Taryn to slip into the recording

"Evan Carroll for Community Manager" is one option

sp_BlitzErik

I don't think he'd appreciate being used as a prop to troll the audience.

Paul White

Oh good point

sp_BlitzErik

We should put together an ad for your sandwich shop

"cost based sandwiches"

Paul White

Good idea.

I wonder if Taryn has her chat doink turned on

Taryn

12:58 PM

:/

Paul White

Geek humour OMG

sp_BlitzErik

Taryn has a surprisingly nice voice for a mod

Paul White

Bit on the American side

I imagine this is a bit like watching the moon landing

sp_BlitzErik

Way more RAM involved.

Andriy M

No ram has been involved in either event, I'm sure.

Paul White

1:07 PM

baaa

Current status: turning it off and back on again

sp_BlitzErik

@Taryn we need to have a talk about your posture

Taryn

and sometimes that works

@sp_BlitzErik bah

sp_BlitzErik

There's the ram!

Paul White

@sp_BlitzErik The latest research is that slouching is optimal

Max Vernon

Fun watching this; just wish I could be watching on a screen big enough to see the T-SQL action.

Paul White

1:18 PM

I think the resolution is deliberately too low for that

Also these guys have no idea what they're doing. They should let Taryn drive.

Taryn

hence the poor posture on my part - trying to read Nick's read at times

sp_BlitzErik

@Taryn would never use the wizard

amateur hour

Taryn

I'd use it and then hit script :P

Paul White

@sp_BlitzErik Shocking eh

Max Vernon

@Taryn pro!

Taryn

1:21 PM

did you think we were professionals?

sp_BlitzErik

ah you should hire paul. he's a professional.

and his time zone makes maintenance windows a breeze.

Max Vernon

If you guys aren't, no-one is.

Paul White

@sp_BlitzErik I could probably connect them with a professional

He uses a VM though

Max Vernon

I restore T-LOGS all the time.

Paul White

It's advanced work

obviously SQL Server lost track of LSNs

Max Vernon

1:24 PM

I hate when it does that ;-)

Paul White

A real database wouldn't have these problems

Max Vernon

It's so great being in the peanut gallery

Paul White

Isn't it though

So much better than live streaming one's own major upgrade

That would be tense

Max Vernon

Yah

Taryn

just a bit

Paul White

1:26 PM

It's clearly a recording. Faked, just like the moon landing.

Max Vernon

Lol. I love the constant chatter. If that was me, it'd be really quiet and boring.

Nerves

BACKUP SCRIPTS

Lol

Wait! Don't turn off the...

Max Vernon

1:30 PM

Will se chat go read-only?

Paul White

I understand so yes

sp_BlitzErik

Mar 13 at 16:51, by Paul White

Mar 8 at 14:42, by Tom V

You don't even read the transcript

Paul White

Launching DDoS attack in 3...2...1...

sp_BlitzErik

> installing chrome and firefox on your servers

Max Vernon

Watch Windows Update want to kick in now.

Paul White

1:33 PM

@sp_BlitzErik The mark of a professional outfit

sp_BlitzErik

GOODNIGHT MOTHER

Paul White

> We don't want user data to get lost if we can avoid it

Tom arrives at exactly the wrong moment

bye!

sp_BlitzErik

$false

$true

Andriy M

yay

Paul White

> amateurs with Access

@Taryn doink

Taryn

1:38 PM

I heard that

Paul White

:)

Max Vernon

I'm on mute so I don't interrupt anyone. ;-)

Paul White

I wish

dba.se is read only

sp_BlitzErik

WOOHOO BUTTHOLDIING

Paul White

doing the flip

sp_BlitzErik

1:41 PM

> This site is currently in read-only mode; we'll return with full functionality soon. Follow @StackStatus or visit our status blog for more info.

nifty

Taryn

@sp_BlitzErik giphy.com/gifs/…

sp_BlitzErik

it's aware

Paul White

artificial inteeligence at work

So does anyone remember those SO/SE Q & A style sites? They were fun.

> We are currently offline for maintenance

sp_BlitzErik

Andriy M

I remember the experience as if it were yesterday

Paul White

1:44 PM

And back in read-only.

boom

sp_BlitzErik

staring at idle powershell windows

Paul White

heh heh heh

sp_BlitzErik

> getting gmail notifications on your production server

> mfw

Paul White

Yeah I saw that too.

Taryn

@sp_BlitzErik hah not really

Andriy M

1:47 PM

"Slightly lower priority"?

sp_BlitzErik

oh is opserver wrong about something?

;)

Paul White

What is opserver?

sp_BlitzErik

define: opserver

github.com/opserver/Opserver

Paul White

Did Nick Craver hack that together?

Seems so

They're only having small issues because Taryn didn't say hi to The Heap

site seems to be read-write again

sp_BlitzErik

"we build a button"

Paul White

1:53 PM

flushing redis down the toilet

sp_BlitzErik

"worked on my computer"

what a guy

Paul White

I think I finally understand the term plansplaining

sp_BlitzErik

right?

Paul White

jesus christ

sp_BlitzErik

WHAT TRACE FLAGS, @Taryn?

Taryn

2:01 PM

1204, 1222, 3226, 9023

sp_BlitzErik

nick's screen looks like a glaucoma test

Taryn

hence my posture

sp_BlitzErik

wow, the linux plan isn't set in stone

i figured that'd be nick's next kid

Paul White

blogs.technet.microsoft.com/dataplatform/2016/03/16/…

sp_BlitzErik

no one tell evan that the best tool for the job isn't postgres

Paul White

2:05 PM

> there's no reason to update stats until we change compat level

sp_BlitzErik

i hope we're shaking our heads in synchronization right now

smh doesn't cover it

smh + cmf

cover my face?

you know it

Sean Gallardy - Microsoft

2:24 PM

am I missing a live stream of upgrading distributed AGs?

sp_BlitzErik

sure are

they said they needed some trace flags

Paul White

and now everything's on fire

Sean Gallardy - Microsoft

link?

sp_BlitzErik

Stack Overflow SQL Server Upgrade (2016 to 2017)

►

Paul White

Mar 8 at 14:42, by Tom V

You don't even read the transcript

Sean Gallardy - Microsoft

2:26 PM

True story.

sp_BlitzErik

@PaulWhite if you cared you'd quote me quoting you quoting tom for maximum recursion

Sean Gallardy - Microsoft

No pressure, @Taryn , but I'm watching now

Taryn

the worst is over

Paul White

@sp_BlitzErik We've done that before. It's not as much fun as you'd think.

sp_BlitzErik

@PaulWhite your fun is upside down

Paul White

2:27 PM

They should have a BBQ next time, Sean would be on time for that

Sean Gallardy - Microsoft

@sp_BlitzErik you chilling outside the datacenter as the DR option?

sp_BlitzErik

i offered, but taryn declined

bet she's kicking her knee braces now

Paul White

Their entire support budget would buy like 15 minutes

sp_BlitzErik

best 15 minutes of your life pal

after the upgrade livestream i'm watching this one

Starting Strength Live Stream WFAC

►

Paul White

smh^smh

> ONE SYLLABLE OF POWERSHELL

lol

Sean Gallardy - Microsoft

2:33 PM

@sp_BlitzErik Hey, what… What can I get for, uh… $275 and a yogurt lite rewards card?

sp_BlitzErik

it's the natural raa. to your one line of powershell snark

@SeanGallardy-Microsoft 1st generation ipod

Sean Gallardy - Microsoft

SMH. That's a quote from Deadpool.

Who updates in place?

sp_BlitzErik

@SeanGallardy-Microsoft $2.75

> mfw

Sean Gallardy - Microsoft

omg I missed a character

sp_BlitzErik

heh heh heh

CU UPGRADES AREN'T AS INTRUSIVE

Sean Gallardy - Microsoft

2:36 PM

pretty sure it was 275 though

sp_BlitzErik

WHOOOOOOOOOOOOOOOOOOOOOAAAAHHHHHHHHHHHHHHHHHHH

Sean Gallardy - Microsoft

not 2.75

> we didn't know what was going to happen.

I think I said something...

sp_BlitzErik

i met that australian dude at a devops meetup, hahaha

Sean Gallardy - Microsoft

Was it wolverine?

Paul White

straya

sp_BlitzErik

2:38 PM

@PaulWhite yeah nah

Paul White

correct

sp_BlitzErik

@SeanGallardy-Microsoft you mean the greatest showman?

noice

Sean Gallardy - Microsoft

Depends, does all of his demos fail too?

Paul White

~~I hear he abuses apostrophes~~

Sean Gallardy - Microsoft

Unless the Windows logins belong to different domains across the distributed ag

sp_BlitzErik

2:39 PM

would a half austrailian half new zealandish baby say "noice as"?

Paul White

what a horrible concept

sp_BlitzErik

urribol

Sean Gallardy - Microsoft

@PaulWhite We just give people the ability to shoot themselves in the foot, they choose to do it all on their own

I can see the syntax for adding logins as part of AGs

Paul White

Go on

Sean Gallardy - Microsoft

CREATE LOGIN xyz FROM WINDOWS FOR AVAILABILITY GROUP (AG1, AG2, AG3) ON REPLICAS (R1, R2, R3, R4) WITH DISTRIBUTED

(St Patrick's Day jokes)

Paul White

2:47 PM

@Taryn Yay!

Taryn

:)

Sean Gallardy - Microsoft

Internet INFAMOUS

Taryn

a bunch of troublemakers in here

Paul White

So I hear

sp_BlitzErik

The Heap: A good place to waste your time

if that's not a tag line...

Sean Gallardy - Microsoft

2:48 PM

Heaps are good wastes of time

and space

Paul White

and completely unordered

Andriy M

by definition

Sean Gallardy - Microsoft

SQL doesn't send registry information, windows does :)

Paul White

1 hour ago, by Taryn

did you think we were professionals?

Sean Gallardy - Microsoft

> Don't use replication

True story

sp_BlitzErik

2:53 PM

> 5 minutes of data loss on bicycles

no data was harmed

Paul White

replication is a time vampire

@Taryn presents fun with DAGs

3

Sean Gallardy - Microsoft

BUT IT STILL WORKS DOESNT IT

> was a total shock.

:)

Soooo this day doesn't get any better.

I was told I was right, and it is St Patrick's day.

sp_BlitzErik

Taryn

@SeanGallardy-Microsoft ;)

Paul White

@SeanGallardy-Microsoft I think you owe her $275 (or $2.75)

Andriy M

2:59 PM

and a yogurt lite rewards card

Paul White

> we can wait 'til Monday

Sunday will be a busy day

Sean Gallardy - Microsoft

I get back and the livestream is over?

sp_BlitzErik

3:15 PM

they failed over to postgres

it was all a big gag

Sean Gallardy - Microsoft

@sp_BlitzErik You chose Postgres, that's how I know you're lying

Any number of options are better than that...

Andriy M

That, or Evan hacked his account

McNets

morning, evening

sp_BlitzErik

evan isn't terribly good at exposing secrets we've learned

Sean Gallardy - Microsoft

FTFY: Evan isn't terribly good

sp_BlitzErik

3:17 PM

damn

DAMN

Sean Gallardy - Microsoft

:mic drop:

McNets

0

Q: Backup + Restore software for PostgreSQL

I have databases on Postgres 10 on some CentOS 7 servers. It's necessary to maintain different database backup copies and diverse retention requirements for critical PostgreSQL instances. What's the most reliable backup/restore database solution for PostgreSQL nowadays?

postgresql

Shopping list question?

Sean Gallardy - Microsoft

If not, definitely opinion based

Paul White

> critical PostgreSQL instances

found the problem

Sean Gallardy - Microsoft

LMFAO

sp_BlitzErik

3:22 PM

breaking the backboard on these jams

Sean Gallardy - Microsoft

3:33 PM

Alright, time to go get some sun

In this 77 degree lovely weather

sp_BlitzErik

don't turn into a potato

Taryn

3:50 PM

thanks for following along today :)

3

Paul White

Ireland 21-5 England at half time. More good St. Patrick's Day news

Seems to be snowing

Paul White

4:48 PM

Ireland 24-15 full time. (rugby union, six nations competition)

Evan Carroll

5:26 PM

I AM BACK.

Andriy M

5:52 PM

@EvanCarroll I've noticed you often announce your arrival like that. But I don't remember your doing the same on departure. Is that because you think the former event is more important for people in this room than the latter?

Evan Carroll

I think they're both equally important, but I tend to want to focus on the glee and euphoria that I bring, rather than the solitude and dismay that fills the void when I leave.

McNets

ooohhhh !!!

Evan Carroll

@McNets IS BACK!!!

McNets

ha ha ha

I'm working, glee and euphoria has no place disgracefully

Andriy M

6:08 PM

And I'm not any more. Thoughts of glee and euphoria will comfort me on my way home. Thank you Evan.

McNets

@AndriyM I'm at home, remotely connected to work

Sean Gallardy - Microsoft

7:56 PM

@PaulWhite I was wearing my Ireland rugby shirt today, too!

McNets

8:48 PM

:43467070 no, I'm working completely naked.

sp_BlitzErik

That was for Sean

Do over!

@SeanGallardy-Microsoft were you wearing anything else?

Evan Carroll

MY SWEET SWEET @sp_BlitzErik

sp_BlitzErik

@EvanCarroll ayyy

Evan Carroll

9:30 PM

who is learning something fun?

Sean Gallardy - Microsoft

9:57 PM

@sp_BlitzErik no comment

ypercubeᵀᴹ

10:25 PM

@Colin'tHart, Rick, I've incorporated the comments into the answer. — ypercubeᵀᴹ 46 secs ago

Mods, feel free to remove all comments ;)

sp_BlitzErik

10:55 PM

@SeanGallardy-Microsoft that must have been wicked awkward in a pile of dudes

Sean Gallardy - Microsoft

I like how you assume I was around a "pile of dudes"

ypercubeᵀᴹ

"in", not "around" ;)

Sean Gallardy - Microsoft

LOL

ypercubeᵀᴹ

87

Q: Why is Math.random() not designed to be cryptographically secure?

The JavaScript Math.random() function is designed to return a floating point value between 0 and 1. It is widely known (or at least should be) that the output is not cryptographically secure. Most modern implementations use the XorShift128+ algorithm which can be easily broken. As it is not uncom...

cryptography javascript random

> Second, let's remember what the fundamental design purpose of JS was in the 1990s. Make the monkey dance when you move the mouse.

laughing with tears

Transcript for

The Heap™ – Consultancy ©®