Gavin Clark

Ireland, when it’s anything better than pissing rain and freezin’ 😂😂😂😂

@marcorus FINDCOOLINSIGHTS() , would probably need wrapping inside yours like MAKENOMISTAKES( FINDCOOLINSIGHTS(allmydata) ) 💡

It's Saturday. Name a DAX function that doesn't exist but absolutely should.  Wrong answers only. 😎 I'll start: MAKENOMISTAKES().

Hey @LNER , if you're providing this much info, a useful addition might be the platform number too ?

@johncrickett Built a mini ERP system in Delphi in the late 90's, sales, inventory, procurement, loved it!

Apparently a lot of people loved VB6. How about Delphi? Who was a fan? Who still is? What's it like these days?

Hey @LNER , stuck at Newark Northgate on the 18:33 from KGX to Darlington. Appreciate the situation is difficult but getting on for 5 hours and no movement and lack of updates. Surely by now there should be rail replacement options by now?!

@zachly SCD2 , you have is_actual ? Generally I've used is_active ? I guess it may not matter as long as the logic is applied correctly

Slowly-changing dimensions are modeled incorrectly so much! There are 4 types: - Type 0 These dimensions aren't slowly changing. They are fixed. Think of things like birth date or sign-up date. - Type 1 This is the worst way to model your slowly changing dimensions. You naively update the table with the most recent value. This destroys the historical integrity of the table! - Type 2 This is the golden standard for modeling slowly changing dimensions but also the most complicated. You add a new row to the table every time the value changes with the date range it is valid - Type 3 This is one is a tradeoff where you store the previous value and current value in one row. It maintains some historical integrity but not perfect integrity like Type 2 How do you like to model your slowly changing dimensions? Join the free data engineering boot camp at learn.dataexpert.io to keep learning!

@Pranj_Sometimes @nsubugakasozi @brankopetric00 ControlTower maybe? I'm not sure if that would help your use case though

@nsubugakasozi @brankopetric00 Clock tower ?

Route53 is the only service that actually works 100% of the time, which is why it's terrifying that the UI allows you to delete a hosted zone with two clicks.

Double sacking, has to be !! #TheApprentice

If you're looking for a new tipple, or maybe something different and supporting independents, I can recommend this #rum #libations #caskreserve

@TeenyBella Never been, but quite popular with the mackems

@marcorus Unusual DAX Formula

Microsoft loves acronyms… so much that “UDF” now has multiple personalities in Power BI and Fabric. Do you know what UDF stands for?  Wrong answers only (it’s Saturday). Comics from SQLBI Newsletter: sqlbi.com/nl/v/2436/

@nealkdavis I'd say A or C as there's a bit of ambiguity in the question? More likely A if it is about managing the workloads once in the cloud

📣 AWS CHALLENGE - Test your Knowledge Know the answer? Post it in the comments below! 🙋 📌For additional FREE AWS practice questions, visit dct.news/free-aws-quest… #AWSCloud #AWSChallenge #AWSExamPrep

I know I keep banging on about my designs but it’s not easy being a small business at the moment. Take a look at my wares and please retweet. gailmyerscough.co.uk Thanks!

@LettySpoghetti Awesome, enjoy !

@gavinclark66 Thank you 😁 off to Florida on Thursday 😁😁

Deffo the best way to fly via Dublin no messing at passport control 🥰 but I am wide awake at stupid o'clock 😲😲😲😲

@south_eastone @VickiPrior4 @MartinSLewis @thismorning Just done for my Mum recently, make sure you read it all properly, particularly the sequence of when specific sections need to be signed and by whom !

@VickiPrior4 @MartinSLewis @thismorning I'm not great with tech but I managed it! One more point, as you fill it in you can save what you've done and come back to it so you don't have to rush at it.

A reminder Power of Attorney is arguably more important than a will, and more urgent. Just had a call on @thismorning from an older lady asking about moving bills into her name from her husbands, who she's caring for as he has early stage dementia. Yet she hadn't yet done Power of Attorney. This is by far the more urgent consideration. Get it done while someone has the capacity to sign it. Then if and when they lose their faculties, the transition so you can look after their finances (and health and welfare) for them is relatively easy. If not, leave it too late, and the money may be locked away unless you got to the Court of Protection which is often and expensive and time consuming nightmare. Better still get a PoA when young. I did mine before I was 40. It is in place, so that if I lose my faculties in the future at that point (not before) someone can take over.

@krisela47 Good luck Mils, whatever you chose!

I was offered a good opportunity last week, but these are times when you are given the choice between following your heart or your mind. I chose the former. I just hope I made the right decision.

For your entertainment - some Delhi traffic ....

@BuccaneersNIHL2 Shocking, -£5 pocket money 😂

🚓🚨 PENALTY 🚨🚓 🏴‍☠️ 13 Clark 5 minutes for boarding Time 14:53 #UpTheBuccaneers #UTB #NIHL2 #IceHockeyUK #BillinghamBuccaneers #BlazeVsBuccs

Other than presents, this was my contribution to the Clark Christmas 🎄🎅🎁 celebrations, not a bad attempt at a Beef Wellington!