loading...
ronsoak  profile picture

ronsoak

Data Analysis Team Lead at Xero in Wellington NZ. Dev tag moderator and passionate about space! All views expressed here are my own.

Location Wellington NZ Joined Joined on  Twitter logo GitHub logo LinkedIn logo Medium logo External link icon
Education

BA in Psychology and Linguistics

Work

Data Analysis Team Lead at Xero

All 132 Comments

re: SQL Vs NoSQL Databases !
Hi Praveen It is against our terms to post a portion of an a...
re: Backup SQL databases on the AWS S3 bucket using Windows PowerShell
Hi there. It is against our terms to post articles like this...
re: DevDiscuss S2E5: How to Harness Radical Candor in Code Reviews
LOVE Radical Candor! Such a good book!
re: 🤩 Best VS Codes Extensions 🛠 Every Developers Should Use in 2020
Amazing Article, have downloaded a few :)
re: SQL Practice Problem to Help You Pass Your Interview
Having been working with SQL for nearly a decade I got hit wi...
re: Afraid of Java?
Hi Rick Posting articles for the sole purpose of driving tra...
re: 5 tools no developer needs
This was a hoot to read, end to end.
re: First impressions of PopSQL’s collaborative SQL editor
Oooooh
re: Is SQL language outdated? (not relational algebra)
I’m sorry why do you keep talking about SQL drivers? What are...
re: Build a URL shortener using FastAPI and Redis
Hi Amal Creating articles like you are doing with just a lin...
re: Python Zero to Hero - Ep.18 - Python packaging
Hi Cheuk Looks like you're doing a heap of content and usefu...
re: A Case Study of Date and Time
My fun fact people don't know is that if you do a SELECT DATE...
re: Is SQL language outdated? (not relational algebra)
No not at all. It's been around for 50 years and the pendul...
re: 10 podcasts I look forward to every week
This is a great list, I listen to upwards of 30 hours a week ...
re: Types of SQL Server Recovery Models
Hi mikehussey7751 It's against our terms to write articles s...
re: Why monitoring your big data analytics pipeline is important (and how to get there)
Hi Divij Posting barebones articles linking back to the orig...
re: GSoC 20: Week 8-9
Nice series you've got going there!
re: MRI Data Processing with Python
This is a FASCINATING read, its amazing to see data science b...
re: SSIS Components and dotConnect for Oracle Now Come with SSH Support
Hi Devart I'm Ron, I'm a dev.to mod, I look after the SQL ta...
re: Codecadmey Data Science Course Part IV
Got to know the basics! I meet too many scientists who just k...
re: PostgreSQL Connection Pooling: Part 4 – PgBouncer vs. Pgpool-II
This is such a good, well thought out, post, thanks for bring...
re: switch case in laravel
Hi Pakainfo I'm Ron, I'm a dev.to mod, I look after the SQL ...
re: What's that piece of code that you have to Google *every time*?
REGEX!
re: What is the first thing you do when setting up a new computer?
Remove the bloat and install VSCode
re: How To Write Better SQL: Advanced SQL Episode 2 - Please Stop Using So Many CTEs
Yes 100000000000000% this. CTE’s in some environments are a...
re: What do you do to protect yourself from burning out? Share some tips.
SHAMELESS PLUG of my own article on this very matter: dev.to/...
re: I built my own SQL tester in Python, then rebuilt it again from scratch,here's what I learned.
Lambda on a lambda!
re: How Do You Support Remote Juniors?
Be flexible with what you would normally do. We're all WFH ...
re: The R.A.G (Redshift Analyst Guide): Understanding the Query Plan (Explain)
Great points!!!
re: New remote DEV jobs at Squire, iPresence, Ebury, and others
Hi Sergei We don't support the use of articles to offer jobs...
re: Welcome Thread - v63
Civil Engineer! That's pretty intense, are you wanting to c...
re: Nevertheless, Code is Magic
I love how you so accurately recount the earliest exposure ...
re: Nevertheless, zuzanadostalova Coded
This is a wonderful insight into a different world, please ...
re: Nevertheless, Heidi Waterhouse Is Technical
100000000% Heidi, SME's / Product Owners / BA's all over th...
re: Nevertheless, Kip dreams of more coders
This is a phenomenal article Kip! It's clear, well structur...
re: I'm moniquejank, and I support women devs.
Hi Monique, it looks like you've published the template, do...
re: Nevertheless, Kaleigh Coded
Great article! Loved getting the history to! I admire that ...
re: Nevertheless, Shilpa Coded
Thank you for the advice!! Good article!
re: She Coded! But she tired from the week.
Congrats on all the change! Good stuff!
re: Nevertheless, she coded
Hey Rolf, exactly right! Women and people of color are cons...
re: Nevertheless, she coded
I love this. You are a women your feelings are valid.
re: DEV extreme moderation !!! #htwgm !!!
Hi Clive Would like to remind you that Dev.to is a communi...
re: The R.A.G (Redshift Analyst Guide): Troubleshooting process
Thanks :)
re: Technical debt so bad I quit my job
One of my previous lives I worked for a national loyalty co...
re: New Machine; New Browser
Great post. I’m very anti the google monopoly and tried Fir...
re: My Experiences In Professional Python
I love the context about how you used to use VBA. Most arti...
re: Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼
Cheers Nathan, it took a long time to find the voldemore on...
re: Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼
It sounds like a great first article idea! We always need m...
re: Data Analyst? TIME TO LEARN PYTHON!!!🐍🐼
That’s great news. If you haven’t already could we tempt yo...
re: are codepen and devto the only startups who know how to code OAUTH properly
Nope, just a member of the community
re: are codepen and devto the only startups who know how to code OAUTH properly
Hi Clive. I can see your posting a lot of articles and to b...
re: Designing the data team
first hire you should make is not a Data Scientist or Mach...
re: Writing DEV articles in VSCode
I actually once looked to see if I could do this. Thanks !
re: The R.A.G (Redshift Analyst Guide): Troubleshooting process
Thank you!!!!!
re: The R.A.G (Redshift Analyst Guide): What is Redshift?
Thank you !!
re: I built my own VS Code Syntax Highlighter from scratch and here's what I learned.
Good Spotting! have rectified that mistake!
re: Why Dashboards are the fast food of Data Analysis
Hi Eddie, I still think Dashboards have a place, just like ...
re: Why Dashboards are the fast food of Data Analysis
I thoroughly love your commitment to the metaphor! “High ...
re: Let's have a look at how AWS names their products...*eye twitch*
Cheers
re: Let's have a look at how AWS names their products...*eye twitch*
Wow did not see that one! Should just be AWS DNS...
re: Let's have a look at how AWS names their products...*eye twitch*
A new one arises! AWS Zelkova........ a tree, well at lea...
re: When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse
Yes I saw this last night and hoped no one would catch it! ...
re: My privacy setup 🔐
If you think Gmail is hard to give up, try finding an alter...
re: I built my own VS Code Syntax Highlighter from scratch and here's what I learned.
Nah the process to register it on the market place is a bit...
re: I built my own VS Code Syntax Highlighter from scratch and here's what I learned.
I'm surprised anyone still knows it exists
re: Changelog: Pin posts you want to feature to the top of your profile feed
Could we add a filter to our dashboard to just see pinned p...
re: What size company do you work for? What's that like?
I suppose I work for a large company, 2,000 staff, however ...
re: What to do when faced with excellence
Great Article :)
re: Do you have your next vacation planned?
A quick trip to Australia later in the year, then 🤷 just ca...
re: I'm changing my job title to Data Librarian.
What did Nat say?
re: What do you think about the idea that "there should be only one way of doing a thing" in programming languages?
No. How will I act superior about how i code if it’s all th...
re: What specifically should I learn for a career in DevOps (more explanation below)
Thanks thats really cool!
re: What specifically should I learn for a career in DevOps (more explanation below)
Ooooh thank you
re: What does a dev's personal website need to include?
This is a masterpiece
re: Famous Company <> Career Happiness
Video game dev is a disaster. In the past year alone we hav...
re: What do you want to be when you grow up?
This resonates too deeply
re: What are you surprisingly terrible at, despite being otherwise competent?
Following process. I’m great at making them and writing the...
re: How do you limit or avoid procrastination?
I treated my time like it was money. If I wanted to do X a...
re: Which part about your job/studies/etc. gives you the most anxiety?
Watching people consistently not live up to the companies c...
re: What is your favorite interview question?
My pro tip is to ask them “do you have any concerns about m...
re: Create Waves With Pure CSS
That’s really cool! Thanks !
re: Who are your career heroes & why? (Signal Boost!)
The one who founded Id software?
re: Who are your career heroes & why? (Signal Boost!)
Well if that’s not a reason to go follow her, I don’t know ...
re: What are your worst coding habits?
I rewrite other people’s code to my extremely high standard...
re: What’s your work/life balance like these days?
My work / life balance is good, compared to most, but still...
re: Who are your career heroes & why? (Signal Boost!)
I followed them all! ❤️
re: Follow Friday: What DEV member would you recommend following?
Right,my turn. She's already been mentioned like a million...
re: Follow Friday: What DEV member would you recommend following?
Shucks :)
re: What was your win this week?
I got fucked over, royally, and kept my cool and the situat...
re: A few tips I wish I could tell my younger self
+1 yes stay healthy!! Both physically and mentally.
re: Underrated Articles on Dev.to Last Week
I love this idea. Please keep it up!
re: The lies and lack of self respect that lead to burnout
8 and gate???? Love it!! This should be a sticker!!!
re: The lies and lack of self respect that lead to burnout
Thanking you! I agree! It’s so painful to watch junior sta...
re: Top 5 DEV Comments from the Past Week
Massive shout out to @mercier_remi for the comment about b...
re: I have written a lot about Burnout and Crunch Culture, Ask Me Anything!
That’s a great question. I’m yet to figure out the golden q...
re: Welcome Thread - v33
Haven’t done this yet. Hello, I’m a Senior Data Analyst wit...
re: The lies and lack of self respect that lead to burnout
Exactly, Look after yourself!
re: The lies and lack of self respect that lead to burnout
I’ve hired staff who do this. No matter how much I yell at ...
re: The lies and lack of self respect that lead to burnout
I wish I could give more than one heart to your reply. Such...
re: The lies and lack of self respect that lead to burnout
Coding for 8 hours? Even that’s too much for me. I hit a wa...
re: The lies and lack of self respect that lead to burnout
This this this a thousand time this. I feel bad for not con...
re: The lies and lack of self respect that lead to burnout
Ugh the imposter syndrome is the worst. We’ll all never esc...
re: The lies and lack of self respect that lead to burnout
Enjoy your brunch! Thanks for you kind words
re: Entity Relationship Diagrams explained by Sonic the Hedgehog
Gotta go fast! Great explanation!
re: The lies and lack of self respect that lead to burnout
That week off sounds like a great idea! Your on the right t...
re: What are you looking to accomplish this next week?
This week........ I need to write an entire end to end trai...
re: The lies and lack of self respect that lead to burnout
Right, so the first thing I did was stop working more than ...
re: The lies and lack of self respect that lead to burnout
Dude that means a lot. Cheers!
re: The lies and lack of self respect that lead to burnout
Thank you so much!
re: Can someone help me out
Hey man, I think the best thing for you to do is to start l...
re: Learn React JS in 5 minutes — A tutorial for beginners
Ooh this actually looks doable by a noob like me. Might giv...
re: Moving Past Tutorials: 8 Tips for Problem Solving
And Documentation...... As well as having a code library of...
re: The Ultimate Reason - Why is data critical to business success?
Good write up. Sometimes I feel like closing down BI for a ...
re: Collection Of Over 30 Dev Tips
Interesting use of twitter but great read. Love the dishe...
re: Flexbox 101
Great write up! Anyone who has been coding in HTML and CSS ...
re: What was your win this week?
This week, I...called someone out on some bad workplace beh...
re: Don’t use progress bars in your CV
Unless you are a graphic designer don't do anything remotel...
re: Determining the worth of one-off Reporting.
Sorry don’t know. Stock image.
re: Fewer Dashboards, More Analysis
Thank you! I needed this, as much as I love delivering a be...
loading...