The Heap™ – Consultancy ©®

Philᵀᴹ

12:11 AM

At the moment I can’t walk ...

Should be amusing* in the morning

Max Vernon

12:35 AM

Ouch dude that looks nasty!

Philᵀᴹ

12:56 AM

Yeah, i’d got back from rock climbing and wasn’t paying attention on the stairs. Quite looking forward to seeing it in the morning 😂

Evan Carroll

4:24 AM

@JackDouglas you know what would be really cool for dbfiddle, neo4j support.

hot2use

5:44 AM

Good morning

gbn

6:07 AM

for the first time ever, my "syspolicy_purge_history" jobs have failed on SQL2012. WTF

hot2use

6:23 AM

@gbn 'ray

gbn

Is that what the young people say?

Tom V

6:46 AM

Morning

@Philᵀᴹ That'll suck

hot2use

@gbn Just short for Hooray

Change the hostname?

ypercubeᵀᴹ

@Philᵀᴹ that's a bit ironic ("Rock climber injured at stair climbing" ;)

gbn

7:06 AM

@hot2use Our out-source "partner" made some useful changes we had no clue about

hot2use

7:23 AM

@gbn Always a reason to "sing and dance" (aka "swear and cuss")

McNets

morning

dezso

8:55 AM

morning

surprisingly enough, I got a -1 on an old answer yesterday, and now got a +1 on the same

McNets

@dezso Maybe the same user?

Tom V

9:11 AM

@McNets The vote is locked after a couple of minutes, so unless the answer has been edited the original voter can't change his mind

ypercubeᵀᴹ

@TomV and if it changed, it would show as un-downvote (+2) and then upvote (+10)

Tom V

Ah yes, maybe a serial voting reversed or a deleted user then

Paul White

That should say voting corrected or user was deleted

dezso

10:10 AM

@TomV the DV is still there

Philᵀᴹ

10:26 AM

@ypercubeᵀᴹ oh, I know! I’ll be very grumpy if I can’t climb for a few weeks!

gbn

@Philᵀᴹ More grumpy than the average DBA?

ConcernedOfTunbridgeWells

10:55 AM

@Philᵀᴹ Ow

@gbn The only thing more grumpy the average DBA is the 95th percentile DBA.

gbn

@sp_BlitzErik: I'm adding feature requests for sp_databaserstore. At last...

sp_BlitzErik

i was just looking at those

are you planning on adding those things in (like you have existing code), or is it something you want us to work on?

gbn

I'll add them and hopefully be able to commit later

I like git, but lordy it's easy to bollix

I do have code already I can adapt.

I think I have a bug too. @Debug = 1 fails for me: it tries to restore

sp_BlitzErik

ah, cool

as for debug, yeah, it'll execute anyway. if you want to add a noexec param that's cool with me.

gbn

But I need to make sure I'm doing it right first...

ah I see

sp_BlitzErik

11:05 AM

most of our debugging comes from dynamic sql, so it's helpful to get the error msg and the offending block together in output

unfortunate, but hey

gbn

11:20 AM

Crap. can't even clone here (have to use https)

ypercubeᵀᴹ

11:32 AM

@dezso perhaps the question was linked from a newer, relative answer and it got attention

hot2use

@gbn issues with HTTPS? You can force GIT to clone without SSL.

hot2use

11:48 AM

Git config --global http.sslverify "false"

gbn

@hot2use thanks. Will this break other repos that are https?

hot2use

12:38 PM

Yes.

But you could use it in your repo. Then use the flag --local (I think) instead of --global.

Tom V

215

A: How do I set GIT_SSL_NO_VERIFY for specific repos only?

You can do git config http.sslVerify "false" in your specific repo to disable SSL certificate checking for that repo only.

hot2use

Thanks @TomV

Colin 't Hart

Hej

My brain's not working this afternoon:

Andy K

afternoon

Colin 't Hart

What's a good way (in Postgres) to query data for the last year, or the last 50 rows whichever is more?

Want to see some historical data, but if there's not much in the last year, want to show the last 50 events.

dezso

12:43 PM

@Colin'tHart WHERE last_year LIMIT 50 will do exactly that, won't it?

or you mean the last 50, even if they are from this year?

Andriy M

WHERE date <= ... ORDER BY date DESC LIMIT 50?

gbn

@hot2use It's a firewall issue at work

Andriy M

Ah, no, "whichever is more" – so if the last year has more than 50, then it should be more than 50...

Colin 't Hart

Yep, exactly my conundrum

I think I probably need to use ROWNUM()

Andriy M

SELECT
  *
FROM
  (
    SELECT
      *,
      ROW_NUMBER() OVER (ORDER BY date DESC) AS rn
    FROM
      atable
  ) AS derived
WHERE
  date >= CURRENT_TIMESTAMP - INTERVAL 1 YEAR
  OR
  rn <= 50
;

Colin 't Hart

12:57 PM

A bit like the old way of doing LIMIT on Oracle

Andriy M

(not tested)

Colin 't Hart

Yep

I'll do that

Thanks :-)

Andriy M

You're welcome

ypercubeᵀᴹ

@Colin'tHart what does "last year" mean? All data of 2017? Or all data since a year ago (2016-Oct-17)?

Colin 't Hart

The latter.

Trying to show the last year's worth of stock level mutations, but at least 50 rows if it's a slow moving product

Tom V

1:13 PM

120

Q: What options do I have at 26 years old, with 1.2 million USD?

I'm a 26 years old female, got into an accident that almost killed me; I sued, and after attorneys fees and medical bills from hell... I will walk away with around 1.2 million dollars tax free. Here are the crucial details: I have no family (no one I can trust and I appear alone and vulnera...

starting-out-investing

Asking random people on the internet ^^

Lamak

1:24 PM

@TomV I read that last week, she did get some good advice though

Tom V

Yes definitely

I just don't agree with the index funds per se but that's technical

Transcript for

The Heap™ – Consultancy ©®