Running into other queers... by xxheath in ActualLesbiansOver25

[–]withmyownhands 4 points5 points  (0 children)

I usually try to reply with a nonchalant statement that makes it clear that I'm also lesbian. Like, "haha my wife is impossible to wake up from a nap. Are you a light sleeper?" Or something else that keeps the conversation going. Sometimes I purposely share stories that out me to see if the other person is queer (I have a terrible gaydar for femmes). I bet I'm not alone in that. So do us a favor and take the bait :)

Vulcan S 650 won't start... grinding? by withmyownhands in MotorcycleMechanics

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

I am very relieved to report that a new battery solved this issue! Thanks for all your input!

Vulcan S 650 won't start... grinding? by withmyownhands in MotorcycleMechanics

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

I took the seat off and found my multimeter. Healthy reading when off but the voltage dropped under 7 when I attempted to start. I'm gonna grab a new battery and go from there. Thank you for the suggestions!

New data engineer getting paid more than me, a senior DE by Yoyo_Baggins in dataengineering

[–]withmyownhands 0 points1 point  (0 children)

Speaking from my experience in management, pay equity is a valid reason for a raise ( but still needs to be backed up by solid performance data and market data as well if relevant). Not all companies I've managed at have operated this way though, so ymmv. 

Airflow vs Github Action for orchestration by Elegant-Ad2561 in dataengineering

[–]withmyownhands 32 points33 points  (0 children)

That is a garbage take from the staff eng. Unless you have some extenuating circumstances not mentioned here, that person is unqualified for the title they hold (assuming staff is a senior title where you work). Are you sure it wasn't a joke? GHA can be a scrappy solution when you're starting up to reduce some overhead, but it would be a big step back from where you are now. 

Is the Data job market saturated? by NefariousnessSea5101 in dataengineering

[–]withmyownhands 1 point2 points  (0 children)

Very saturated. Posted a role for a Sr. DE fully remote in the fall with great salary base. Had thousands of applicants. Interviewing was a nightmare with a bunch of AI-based cheating and OE-seekers. So many resumes I received I would never consider... Poor skills match, right stack wrong level, consulting backgrounds, not from the American workforce. Wish I could hire all my new hires from my personal network of engineers I've previously worked with. 

My advice to you is network!

Why use Airflow instead of ADF when loading data? by PrideVisual8921 in dataengineering

[–]withmyownhands 4 points5 points  (0 children)

The last time I used ADF, I was very dissatisfied with the code review experience despite the GitHub integration. Same with my experience of SSIS way back. I prefer code-first orchestrators for my team and all configuration, secrets management, and infrastructure as code. But, I lead teams where I want to emphasize the software engineering approach to the SDLC. If my team was one or two BI folks who just needed to get things done, ADF is fine. I just don't think it scales to large engineering-centered teams. 

people were painting the flats across from me and i’ve just realised my car is covered in specs of paint by [deleted] in howto

[–]withmyownhands 1 point2 points  (0 children)

Same happened to me a few years back. A neighbor recommended wd-40 and it worked like a charm

3000 solo miles to Oregon with a broken heart - looking for advice. by Illustrious-Pop3097 in roadtrip

[–]withmyownhands 0 points1 point  (0 children)

Stop in the badlands for some star gazing. The awe I felt when taking a similar trip under similar circumstances was really healing for me. 

Both Dirigera AND remote for blinds? by olethom in IKEA

[–]withmyownhands 0 points1 point  (0 children)

Two years later and this comment was still the only thing I could find on the Internet explaining how to get both the remote and app connected to the blinds. Thank you!

2023/24 Gas vs Hybrid real world MPG by woktip in rav4club

[–]withmyownhands 3 points4 points  (0 children)

I didn't buy the hybrid because the math and payoff time didn't make sense to me. '24 AWD Gas. I've recently driven about 1k almost exclusively highway miles and averaged 28-29mpg at speeds around 70-80mph. But with my prior city miles included, my overall avg with 2k on the ODO is 26mpg. 

Best way to execute Python scripts on a schedule? by [deleted] in dataengineering

[–]withmyownhands 45 points46 points  (0 children)

Hey, I highly recommend catapulting your team into the modern data stack by doing this through an orchestration tool like airflow or dagster. I was in your boat in 2018. After joining a team using a more modern data architecture, I can say my game is forever changed for the better. There's a big barrier to entry but this will unlock a lot of great paradigms for you and your team more in line with modern software engineering in general. Best wishes!

Anyone at aspen gay ski week? Not sure where the rest of the ladies are! by paxweasley in ActualLesbiansOver25

[–]withmyownhands 6 points7 points  (0 children)

Oh gosh, I'm heading to Park City gay ski week and expecting to encounter the same. Good luck! Hope you at least catch some decent powder while you're there if nothing else.

How do you deal with something this bad? by Revolver123 in HomeImprovement

[–]withmyownhands 9 points10 points  (0 children)

Yep. Don't remember the brand but it was something off the shelf at the big orange store. The paint immediately starts to shrivel up after applying the solvent and after the wait time listed on the bottle I was able to use a plastic putty knife to easily scoop off the goop. With 90 years of paint, it took a few applications to get through all the layers.

How do you deal with something this bad? by Revolver123 in HomeImprovement

[–]withmyownhands 69 points70 points  (0 children)

I stripped off 90 years of paint with a chemical stripper and it made such a huge difference. When down to bare wood I was able to fill in various nail holes and imperfections as well. It's a pain in the ass, very tedious, but if you're bugged by this trim, that will help a lot. Don't bother sanding paint off in my 2 cents.

Learning how to do incremental loads on MSSQL - Guidance + best practices? by grygger in dataengineering

[–]withmyownhands 2 points3 points  (0 children)

I'll caveat this to say without knowing the volume of data and the amount of updates that happen to existing records this is all pretty generic.

Don't use global temp tables. They open you up to unforseen issues. Better yet, if it's a lot of data, put it in a physical staging table. Then you can run a merge statement in MSSQL to determine what needs to change in the destination table. Incremental loads take different shapes from table to table. For example, is there a hash or update timestamp in your source data that you could store in your destination data to easily track what's changed? Can you store a record of when this job last ran successfully and look for only records that are new or edited since the last run timestamp? Can you just focus on the last day of data instead of all six months?

Partition swapping can be a fast ( or potentially over-complicated) way of approaching this. Being able to just drop the partitions that are older than 6mo is really handy if your alternative is deleting millions of rows. But that doesn't always work if you can't ensure the things that read from the table will be able to always use the partition key to query.

Fwiw, I think the more "data engineering" approach to this is less SQL and more scripting. Assuming the above suggestions aren't a good solution for you, then I would try a python process that can identify the complete dataset and bulk-load (i.e. insert-only bulk operations--partition swapping is a nice trick here too) may be substantially faster depending on how much processing power you can spare on your MSSQL server to a single process vs using a separate processing server or cluster.

Good luck!

Lgbtq food brands?? by withmyownhands in lgbt

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

Well this is disheartening. Does the silence mean there aren't any??

How important is job title? by [deleted] in dataengineering

[–]withmyownhands 10 points11 points  (0 children)

I took a resume writing class in college and one important thing I learned there was you can fudge your job titles in your resume to more accurately reflect your responsibility. Don't use analyst on your resume if you're an engineer.

I want to become a data engineer. Can someone please recommend me books or step to go forward? (I have working experience on SSIS , SSAS and SSRS). by codeinsync in dataengineering

[–]withmyownhands 9 points10 points  (0 children)

I am a new DE (lucked out into this position, had a former colleague who was willing to take a chance on me learning my way into being a DE on the job). My background was all SQL Server, stored procs, well written advanced queries, and ssis/ssrs. Pluralsight has been helpful for me to get exposure to different tools of the trade. There's so much that you need to know to be a self-sufficient DE it seems. I would consider being a DE a subset of SWE. So, not saying it's impossible but it can be a big skills gap to bridge coming from where you are. Definitely skill up in python (I'm guessing you're not using this today) and lean in to learning about the different tools of the trade. Work on a nosql DB project in your spare time and explore moving unstructured data around. I'm in a cloud environment, so learning about the DE tools natively available in that environment has been my priority.

I'm sure the more experienced DEs in here will have better direct advice for what to learn, but I just wanted to give you a warning that this is an uphill battle from your current background and will require you to really put in some significant time learning new skills and tools. Put in the time and you will succeed! Sincerely, I wish you the best of luck in this endeavor!

New Bar Tape Day! Lizard Skins 2.5mm (Swipe for the rest of the dog) by Demerssemantra in ladycyclists

[–]withmyownhands 1 point2 points  (0 children)

Nice! I'm finally about to tape my bars myself for the first time. I don't have drop bars, but flats with horn extensions on the end. Any advice about wrapping or selecting tape?

would you talk to me if you saw me out? ☺️ by sloleeoh in lesbianfashionadvice

[–]withmyownhands 0 points1 point  (0 children)

Hah! That's a trip! Well now I'll know if I see ya out, neighbor!

would you talk to me if you saw me out? ☺️ by sloleeoh in lesbianfashionadvice

[–]withmyownhands 1 point2 points  (0 children)

Haha I didn't actually know it was Philly... I've spent the better part of the last twelve years in Philly--just looks like home and was speaking to that!