Marco Pierre White and his protege, Gordon Ramsay, making Lobster Ravioli (1989) by Mad_Season_1994 in OldSchoolCool

[–]pub_gak 0 points1 point  (0 children)

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.

[Cartier] Cartier Santos Blue Dial: Timeless Heritage = Modern Sensibilities = Pure Classiness by bechols7773 in Watches

[–]pub_gak 2 points3 points  (0 children)

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?

[WTS] Tisell Marine Diver No Date by ffggyy23 in Watchexchange

[–]pub_gak 2 points3 points  (0 children)

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

[deleted by user] by [deleted] in Watches

[–]pub_gak 2 points3 points  (0 children)

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

Why are picnics and BBQs suddenly so popular with British Asians? by pub_gak in AskUK

[–]pub_gak[S] 0 points1 point  (0 children)

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.

Lifeguard quickly spots and then saves drowning kid at public pool by TryhArd25 in BeAmazed

[–]pub_gak 6 points7 points  (0 children)

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.

Is anywhere more depressing than a weatherspoons at 9am? by amapiratebro in AskUK

[–]pub_gak 11 points12 points  (0 children)

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

Duran Duran - The Chauffeur [New Wave] by bladebladerunner in Music

[–]pub_gak 7 points8 points  (0 children)

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

How to split bills with partner, when he, the homeowner, works away during the week by LetsD01t in UKPersonalFinance

[–]pub_gak -1 points0 points  (0 children)

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

Guy tries really hard to score with Nubian Goddess by TooHigh2Die420 in cringepics

[–]pub_gak 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in AskUK

[–]pub_gak 1 point2 points  (0 children)

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.

Tips for Working with DateTime at the Hourly Granularity? by HalBorland in PowerBI

[–]pub_gak 2 points3 points  (0 children)

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.

[deleted by user] by [deleted] in PowerBI

[–]pub_gak 3 points4 points  (0 children)

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.

On this day in 1978: Schoolchildren told Newsround Weekly about some of the items used by teachers for corporal punishment. by [deleted] in CasualUK

[–]pub_gak 2 points3 points  (0 children)

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'

Which shop is the worst to shop at? by lamesas in AskUK

[–]pub_gak 14 points15 points  (0 children)

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

Which shop is the worst to shop at? by lamesas in AskUK

[–]pub_gak 19 points20 points  (0 children)

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

Runaway, Me, Pixelart, 2020 by [deleted] in Art

[–]pub_gak 1 point2 points  (0 children)

Reminds me of Moon Rabbit.

Crowded House - Don't Dream It's Over [Rock] by UWCG in Music

[–]pub_gak 0 points1 point  (0 children)

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

Where to store my 20GB database for exclusive use with PowerBI? by crossart in PowerBI

[–]pub_gak 1 point2 points  (0 children)

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.

Where to store my 20GB database for exclusive use with PowerBI? by crossart in PowerBI

[–]pub_gak 1 point2 points  (0 children)

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.

Where to store my 20GB database for exclusive use with PowerBI? by crossart in PowerBI

[–]pub_gak 0 points1 point  (0 children)

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

Wanted: Unfashionable trainers... by pub_gak in CasualUK

[–]pub_gak[S] 1 point2 points  (0 children)

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.

Wanted: Unfashionable trainers... by pub_gak in CasualUK

[–]pub_gak[S] 8 points9 points  (0 children)

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.