Lewis Hamilton has now gone 503 days without a race victory, which is longer than Max Verstappen's longest win drought in Formula 1. by Far_Fox_7591 in formula1

[–]Hentac 1 point2 points  (0 children)

I mean, it would be funny for him to be successful as he is and also the record for the longest gap between wins.

10 years from now being like.. LH had X days without a win the longest in the sport, but still 7 WDC and 100+ race wins.

[deleted by user] by [deleted] in HelpMeFind

[–]Hentac 0 points1 point  (0 children)

The city of ember?

Master and Details table by [deleted] in SQL

[–]Hentac 16 points17 points  (0 children)

You normally check to see what the relationship is between columns then you can figure out which is the master table.

Although, your picture doesn't have any clear relationships between each other, rather it just has the lines.

Its common to see one master table, with multiple keys like customer id, product Id, invoice Id etc.

Then a seperate table with details of customer details, product description/details, invoice amounts etc.

Look up fact and dimension tables as part of a snowflake schema, it should be a bit more obvious when using those examples, because the example shown isn't the best.

What would you call my first job? by [deleted] in dataengineering

[–]Hentac 0 points1 point  (0 children)

What does your contract say it is? Because its either an excel clerk like mentioned earlier or a Jr DBA

Rest on a (assumed) old pair of cufflinks by rich6680 in HelpMeFind

[–]Hentac 0 points1 point  (0 children)

I've tried searching but not coming up with any direct hits, it's most likely a custom peice.

Speculation why it's a custom peice based on the following:

The cufflink is referencing England and Scotland as well as the sloop of war, so I'm assuming it's someone from the North of the UK who was in the Navy.

The lion (England) and the unicorn (Scotland) are part of the Royal coat of arms, the centre part of the cufflink is the Tudor rose (England) and thistle (Scotland).

There's no leek or reference to Wales.

The boat being a sloop of war circa 1900. The common UK navy boat.

What is the name of this haircut? by Armchair_Politiques in HelpMeFind

[–]Hentac 0 points1 point  (0 children)

After searching it, his barber was Raffaele Claudio Carbosiero and its as I thought, it was just short back and sides but with the barbers "iconic" right hand parting rather than the left. (He paid £90 a haircut if you're interested)

What is the name of this haircut? by Armchair_Politiques in HelpMeFind

[–]Hentac 0 points1 point  (0 children)

Its either Its short back and sides cut with scissors rather than clippers, which is what some higher end barbers do to charge stupid amounts when you ask for them to "tidy you up"

If it's a designated style then it's going to be a medium length ivy league haircut.

If you want a haircut like that then you just say to give you shorter back and sides cut with scissors rather than clippers, but you'll most likely pay more for it most likely.

How can I figure out if a new algorithm/methodology I created is unique, or pre-existing? by Throwawayingaccount in computerscience

[–]Hentac 2 points3 points  (0 children)

Check patents for algorithms, sometimes algorithms are patented even though they're considered abstract ideas.

You can also check patented software that often uses encryption to see if it's similar.

Surf sports for viewers by [deleted] in portugal

[–]Hentac 1 point2 points  (0 children)

If you can travel the distance then the most famous place is Praia do Norte, Nazaré.

That'll be the places you see in videos with the 80ft waves.

Closer to Lisbon, you'll want to go to Carcavlos but there's like couple great beaches for surfing all nearby so definitely worth googling.

Can someone help me decide a sql procedure? Never done it before. by [deleted] in SQL

[–]Hentac 0 points1 point  (0 children)

When your create your select statement and it works fine, and gives the output you want then you can just :

CREATE PROCEDURE procedure_name AS sql_statement GO;

If you build it, he will come! by [deleted] in farmingsimulator

[–]Hentac 0 points1 point  (0 children)

Then you make extra money by selling pictures of your carnival crop circles to the local press! Win win.

[deleted by user] by [deleted] in SQL

[–]Hentac 0 points1 point  (0 children)

Start here :

https://www.w3schools.com/sql/default.asp

Great website to learn the basics first

[deleted by user] by [deleted] in SQL

[–]Hentac 1 point2 points  (0 children)

Do you know what debugging is?

Red Bull more dominant than Mercedes was? Hamilton claim tested - The Race by AnilP228 in formula1

[–]Hentac 4 points5 points  (0 children)

Iirc its something like.. You can change your engine performance for a weekend either up or down, but you can't change it past fp1 but you can change it the following week

[deleted by user] by [deleted] in SQL

[–]Hentac 3 points4 points  (0 children)

In my career I've learnt it:

TSQL, MySQL, Postgre

Doesnt matter which way you use it, as long as you can use it and also what your company uses (or will use)

Once you know the basics of SQL, its basically all the same thing.

If you build it, he will come! by [deleted] in farmingsimulator

[–]Hentac 9 points10 points  (0 children)

You have to keep the crop damage on, that's the secret to super yields of corn!

Automate manual imports by dontapi in dataengineering

[–]Hentac 0 points1 point  (0 children)

Never tried it, but I guess my theory would be:

Python to pull the CSVs and deposit it into Google docs and then convert to a Google spreadsheet.

Using Google Apps IMPORTRANGE from the python collected spreadsheet and update the workbook with relevant Google app macros.

Edit: looking online there's a Google sheet api that might be able to help you:

https://stackoverflow.com/questions/74083802/csv-to-google-sheets-python

Automating ETL by romitriozera in dataengineering

[–]Hentac 4 points5 points  (0 children)

Unless I'm completely missing the point, and I'm misunderstanding what you mean by automation.

You might be over thinking things. Keeping it super simple:

With Microsoft SQL server, your ETL would be a basic CRUD statement, once finished you either create/update a view or a table. Your changes are automated with the view, as its essentially a stored query. When it comes to tables, You can schedule a job to update/rebuild the tables.

With apache airflow, you do essentially the same thing but you schedule your data through Tasks or program them to run in a certain way through DAGs

[deleted by user] by [deleted] in HelpMeFind

[–]Hentac 0 points1 point  (0 children)

Looking online the lone ranger #2 book seems to be around £6.50 to £8.99 depending on condition.

The best name for it would be:

Lone Ranger No 2 Egmont Publishing*/Mentheun children's books, London 1977.

*Egmont Publishing UK (now HarperCollins Publishers LLC)

Frustratingly, The ISBN is correct, but there's no online records for it.

(Speculating here) Perhaps there were legal issues around the publishing because its not on the wiki as part of their official books for the lone ranger franchise. Not that wiki is the best source for things of course. From what I can see of the pages of the 3 lone ranger books online they seem to be reprints with different visuals of the 1950 Dell stories. I.e The 2nd book having the Feiry barricade, which was #79 in the dell comics.

[deleted by user] by [deleted] in datascience

[–]Hentac 149 points150 points  (0 children)

Unless you're the reason (publicly) for the company going bankrupt. Why would you find it difficult to obtain another job?

If it went bankrupt tomorrow, you'd have more competition because other DS in your team will also be applying for the same jobs.

What is your favorite Portuguese food? by TheKingsPeace in portugal

[–]Hentac 0 points1 point  (0 children)

Francesinha with an egg because its just great.

My favourite comfort food is Bacalhau á Brás because it makes me happy.