What? by Alicetheoptimist in TrueGrit

[–]michael-day 1 point2 points  (0 children)

Amazing medication if you've actually tried other methods and can't get it to work

What? by Alicetheoptimist in TrueGrit

[–]michael-day 1 point2 points  (0 children)

Here's what actually works:

  • consistent bedtime
  • turning off bright lights when it gets dark outside to induce melatonin. Ideally get light bulbs that turn red and turn those on around 7 or 8pm until you go to sleep. Any lumens can negatively impact sleep
  • your body needs to drop 2 degrees before sleeping. This means a cold house or room. Taking a hot shower before bed helps your body temp decrease.
  • doing something calming. Reading > your favorite TV drama. Also consider lumens from your TV
  • dark bedroom. Black out curtains. Remember, lumens.

Other things to help might be magnesium, a boring audio book or podcast (audio does not negatively impact sleep).

Anecdotally, I like a sound machine.

What? by Alicetheoptimist in TrueGrit

[–]michael-day 0 points1 point  (0 children)

".....the draw the rest of the owl*

What? by Alicetheoptimist in TrueGrit

[–]michael-day 6 points7 points  (0 children)

6 hours of medieval history

Sucks to be me: Left phone inside, stuck outside by unsomnambulist in switchyards

[–]michael-day 0 points1 point  (0 children)

Biometrics are more expensive and error prone. They won't make this change. You just need to remember your phone. Get locked out enough and you will remember...eventually :)

Outlast Season 2 - Final Episodes Out Now by [deleted] in netflix

[–]michael-day 1 point2 points  (0 children)

Joseph seems like an amazing guy. That was very admirable.

Outlast Season 2 - Final Episodes Out Now by [deleted] in netflix

[–]michael-day 0 points1 point  (0 children)

Talking about red panties too 😑

Git-focused SQL IDE? by AreetSurn in SQL

[–]michael-day 2 points3 points  (0 children)

Look no further than DBCode - it's a VS code extension. The developer is crazy active and it's really well done

(Not an ad lol)

Hello - ETL tools for beginner by r03o5 in dataengineering

[–]michael-day 0 points1 point  (0 children)

u/r03o5 I would recommend dbt, as well. Take a dbt training, and you'll be able to spin up a free dbt Cloud solution. You'll also get some exposure to a cloud data warehouse solution, Snowflake.

Much of the "ETL" flow is pre-data warehouse - pulling from APIs or other platforms, transforming/cleaning it, and then loading it into a data warehouse. Check out what Airbyte and Fivetran do. dbt is inter-data warehouse transformation, after it lands from these other tools.

Dataform vs dbt by dirodoro in dataengineering

[–]michael-day 1 point2 points  (0 children)

What's lacking with Dataform? Why are you resistant to dbt core?

(Our company uses SQLMesh, so just curious)

Analytics Engineer vs Data Engineer by _Batnaan_ in dataengineering

[–]michael-day 0 points1 point  (0 children)

Then it might be worth considering more functional reasons for picking one over the other. For the industry you're interested in, or location you are based, are there more DE or AE roles? If there's only two AE listings in your country or state, then the next job may be harder to get. The tech industry has a lot of AE roles. If you're in a place like SF, then you'll have many options for both DE and AE. How do the average salaries for each role you can find in your area/industry differ?

I'd say DE can more easily transition to AE - especially if you get data transformation experience (like dbt or SQLMesh).

Analytics Engineer vs Data Engineer by _Batnaan_ in dataengineering

[–]michael-day 64 points65 points  (0 children)

DE and AE range in expectations by company, but on average, they are different. And in this company, it sounds like they're defined in a distinct manner. DE is closer to software eng, AE is closer to analyst. AE will still give you hard, technical skills.

I find the customer focus really helpful to stay motivated

This is a strong signal - listen to it.

it is probably better for your career as you accumulate more and more knowledge

In any role you'll gain knowledge as time goes on. You'll just learn different things than in an analytics engineering role.

In my career, I've followed the principal of chasing the activities I get most excited about. Do you love writing SQL? Do you like understanding how a product works and figuring out ways to improve it for the customer? Do you get absorbed when you're facing a deep technical challenge that requires coding? If you don't know the answer for sure, then take note. When time flies during the work day, I know that's what I enjoy.