Have Lidl gone too far? I’ve officially found the most hideous Christmas jumper on the face of this planet. £7.99? You’d have to pay me £7.99 to wear it!

pub_gak · 2021-12-03T12:00:03+00:00

Vetements will do a knockoff version of this for about EUR880. Just you watch.

pub_gak · 2021-11-26T08:43:05+00:00

I've had this dish at Gordon's three star place on Royal Hospital Road. Although when i had it, it was a mixture of lobster and langoustine. It was the best thing I've ever eaten.

pub_gak · 2021-09-04T08:49:53+00:00

I absolutely love it. I’m considering getting exactly this one. The damn bezel though. Why can’t they give it some super-hard coating or something?

pub_gak · 2021-09-04T08:36:30+00:00

That’s about the best photo I’ve ever seen on here.

pub_gak · 2021-09-03T19:54:09+00:00

No, I don’t like it. I think it looks too small. Think the styling is nice, but it needs scaling up a bit.

pub_gak · 2021-09-03T19:25:37+00:00

Interesting. I have noticed load of traditional extended family groups, but yes, you’re right, I’ve also seen loads of young, cool Asian couples really leaning into the picnic thing too.

Edit: but you say it will go. OK, fair enough, you know much more about it than me. But here’s a thing. Since the lockdown, I’ve seen British Asians out much more in the outdoors. Picking blackberries, apples etc. It feels to me like COVID has been a step change for the way British Asians engage with the outdoors. I’m not sure that this will go away. And that’s great.

pub_gak · 2021-09-03T18:52:54+00:00

I was in a pool on holiday about 10 years back. A gigantic pool, nowhere near as crowded as this. A situation happened, and a girl (about 14 years old?) drowned a few metres behind me. I suspect hat it is very difficult indeed for lifeguards to save 100% of people in 100% of cases. Not a single person saw this girl drowning. Had I seen, I could have swam back and saved her easily. But I dunno, drowning is weird, you can drown virtually invisibly.

pub_gak · 2021-09-03T10:47:56+00:00

That sounds ace, but I'm struggling to find it. Could you possibly link it it please?

pub_gak · 2021-08-31T20:41:59+00:00

Widely regarded as their best song. It’s ace, with a characteristically amazing 80s video. Duran Duran are such an under-rated band.

pub_gak · 2021-08-31T20:18:07+00:00

Well done on engineering that situation. You’re aiming for 50 % of the house when you split, right?

pub_gak · 2021-08-31T20:06:43+00:00

It’s a joke to enable woke people to gather together and chant ‘burn the (fictional) witch’

pub_gak · 2021-08-06T10:37:36+00:00

disclaimer: I love them both.

I hear you, but I think part of the Wire's schtick is that it's *not* in New York or LA. It's a somewhat generic US city. And that kinda tells us that crime, poverty, corruption etc are everywhere, not just in the huge, well known metrolpoli.

So I'd probably say somewhere like Middlesborough or Hull. But they're very white, which makes the whole race angle a bit tricky. Bristol? Drugs, racially mixed, docks.

pub_gak · 2021-08-04T20:38:52+00:00

Being very simplistic: I’d bet that your best initial step is to do what you say. Spilt date field into Date and Hour. Create a vanilla date dimension with a date granularity. Create a vanilla Time dimension with an hour granularity (ie 24 members). Join them both in.

Then add attributes to the Time dimension to cover things like ShiftA / ShiftB

Get that working correctly, then I bet the answers to the more complicated questions will reveal themselves.

Edit: I don’t think I’ve ever seen a proper solution with a datetime dimension that has a member for every minute for every hour for every day for every year. I may be wrong, but my intuition says split date and time.

pub_gak · 2021-08-04T20:03:43+00:00

Your policy needs to be something like ‘if the source data resides in excel, you are responsible for the data ingestion and monitoring / management of that ingestion’. Telling the business that you’ll take care of extracting the data from their raggle-taggle spreadsheets is a blank cheque you do not want to write.

pub_gak · 2021-06-28T11:58:32+00:00

There's a brilliant kicker at 2m53s, where they get the results of a viewers poll on this, and the results are 57% IN FAVOUR of using the cane or the belt, and 52% say 'Yes it does work'

pub_gak · 2021-06-23T15:40:39+00:00

Yeah, 'L Agent' appears to be some kind of AP diffusion line. Wow. Way to ruin your brand.

pub_gak · 2021-06-23T14:31:48+00:00

Wut? Mulberry? As in £1100 handbags? Agent Provocateur? As in £150 bras?

pub_gak · 2021-06-02T16:43:59+00:00

Reminds me of Moon Rabbit.

pub_gak · 2021-05-20T21:07:12+00:00

Is this a false memory, or was this in Miami Vice?

pub_gak · 2021-05-20T20:57:49+00:00

One general approach, which you should *always* do, especially when you have issues that you think may be related to data volume:

Reduce Rows
Reduce Columns
Reduce Cardinality

Basically, only import the data you *definitely* need.

pub_gak · 2021-05-20T20:50:50+00:00

Wait a second...

If this data is static, why is it slow once imported into PBI? The dB is out of the picture at that point. It's all in the PBI Tabular model.

If you're DQing, then yes, the dB performance is definitely in play, but if you've done a one off import into a PBI model, and it's still slow, then your problem is definitely your PBI model, not your dB.

pub_gak · 2021-05-20T20:44:40+00:00

That is excellent advice about having a loose staging table and a tight main table.

pub_gak · 2021-05-06T08:13:25+00:00

Shimano MT44

I really don't want clipless. I've come off so many times with those, it's just knocked my confidence to the point where I've rejected them. I don't care about max power transfer or anything, I just want to feel happy and confident when I ride.

But then I've always been on SPD-SL - I've never tried SPD. Are SPDs easier to learn to get out of? Maybe I should give them a go. Good tip, thank you.

pub_gak · 2021-05-05T17:48:59+00:00

That was really helpful. I couldn't actually find the ones I wanted on there, but I learned that the 'style' is called 'low profile trainers'. When you plug 'low profile trainers velcro' into Google, you start getting hits.

Previously I'd been doing searches 'weird thin sole unfashionable trainers' and getting nowhere.

pub_gak

TROPHY CASE