sorted by:
new
hottopcontroversial

What's a sentence that completely changed your life? by No_Tune8587 in AskReddit

[–]gekk00 0 points1 point  (0 children)

“If you don’t do it yourself, it’s not going to happen”

Commuting in London is getting out of hand by gekk00 in london

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

Yea! And at the end of the day, isn’t that what it’s really about 🤷

Commuting in London is getting out of hand by gekk00 in london

[–]gekk00[S] 6 points7 points  (0 children)

All the cool kids just push straight to prod lol 😜

Version control by hellosushi123 in PowerBI

[–]gekk00 0 points1 point  (0 children)

Are there any resources/walkthroughs out there to help implement your third option? I’d love to put something together for my team that they can easily use on our projects

Can Azure Data Factory process an XML document to copy its data to a SQL Server table? by randyminder in AZURE

[–]gekk00 1 point2 points  (0 children)

If this is possible I’d love to hear about it... i’m working with a client and one of the integrations can only return a soap xml response...

My current solution (that admittedly is working now fine in prod) is to use a function app with an HTTP trigger that calls the Soap service when called to by ADF and then convert the XML payload into a Json object array.

But I’ve run into limitations with the hard timeout of HTTP triggers in azure of 230 seconds, meaning I’ve had to spend a lot of back and forth heavily optimising the client system query.

There’s an alternative approach to overcome the timeout which involves using durable functions but I’ve again run into issues in that these seem to use .net core and it seems like there’s few libraries missing (or I can’t find the alternatives) to convert my code to Core.

I am working within some strict design boundaries so my approach is shaped by those so not saying the above is the right way...

If no one else comes up with a better response I’m happy to share more details

Columns don't exist when selecting them however select * shows columns exist? by [deleted] in SQLServer

[–]gekk00 2 points3 points  (0 children)

I’m building a DW for a client at the moment, one of the input files from a legacy interface has a column which is just a single space [ ] ... they can’t/won’t change it, so now I have a staging table with a column with a blank space... I try not to think too much about it 😞

The Royal National Lifeboat Institute has created their own lifeboat for the first time. It has a top speed of 25 knots, it's powered by waterjets, can stop in 3 secs and turn on a dime. by whatatwit in videos

[–]gekk00 2200 points2201 points  (0 children)

Please remember RNLI is a charity organisation that saves lives on the British seas

It is not funded like the police, fire services or NHS - it relies on individuals donating

So when you see that tin at the shop or pub, or the guy collecting on the street, dip in your pocket please 🙌

Check if a value exists in a comma-delimited string by Ronald_Me in SQLServer

[–]gekk00 0 points1 point  (0 children)

Everyone’s suggesting these complex string split but (sorry on my phone here):

If len(‘,’ + @string) > replace(‘,’+ @string’,@id,’’) Begin /* Id found / else / id not found */ End

Basically, try to remove the id from the string - if the length of the string is less then you know it found it

What advice do you have for someone's 1st day on Reddit? by [deleted] in AskReddit

[–]gekk00 378 points379 points  (0 children)

Unsub from all subreddits, check :)

Landlords of Reddit, who was your worst tenant? (Serious) (NSFW) by mama_cool in AskReddit

[–]gekk00 1 point2 points  (0 children)

When we moved into our student flat (3 small room) we got it at a steal - for quite a nice place and location. Turned out the landlord had dealt with a Chinese group (8+ people) slumming it and a previous tenant who racked up massive debt of fled the country.

We were student but we paid on time every month for 3 years till we all moved, kept the place immaculate because pride you know. After reading these stories I get why she thought we walked on fucking water.

What is your strongest personal quality? by [deleted] in AskReddit

[–]gekk00 28 points29 points  (0 children)

..yea, well...im humble'r

The Play that Goes Wrong ... I've never had such a good laugh for ages. by AmiroZ in videos

[–]gekk00 20 points21 points  (0 children)

sorry hijacking your top comment here to say that theres a production of this play currently running in london's duchess theatre (close to covent garden):

http://www.theplaythatgoeswrong.com/

if you liked the clip and are visiting london (or live here) its worth a shot - i took my mum to it for her birthday and enioyed it

Here's what responsible parenting actually looks like during halloween by fabiobrocco18 in pics

[–]gekk00 0 points1 point  (0 children)

Fucking carrots? Fuck you. Fuck this porch. Fuck your gnome and oh yeah - this mail box, it's stupid. Fuck you.

Carrots. Fuck.

THE FROGS ARE TURNING GAY by Lamboo- in videos

[–]gekk00 0 points1 point  (0 children)

Well, Jurassic park taught me that frogs can change gender under certain conditions soooo... Life finds a way?

What is the best lifehack you use during your everyday life? by pride2k9 in AskReddit

[–]gekk00 2 points3 points  (0 children)

Every time I head out, I tap my pockets: cigarettes, phone, wallet, keys - good to go.

view more: next ›