• 6 Posts
  • 210 Comments
Joined 2 years ago
cake
Cake day: June 20th, 2023

help-circle




  • This isn’t everyone but it’s partially the Peter principal… Basically people get promoted till they are incompetent.

    Let’s say you run a manufacturing plant. You have a team of 10 people but 1 is far better. They are quicker and cause less mistakes so you decide to promote them to team lead.

    They are a good team lead. They share knowledge and help out in between so you promote them supervisor.

    They are a decent supervisor, monitoring the workers, good communication etc. You promote them to manager.

    They suck as a manager. Can’t keep track of inventory, quality is slipping, quantity produced per day is dropping. You can’t really demote them that’s not really a thing in most companies. You can either stick with a crappy manager or fire them. Either way you lost your best operator. To make it worse they have “manager” on their resume now so a lot more likely to get another manager position at a different company where they will also suck.



  • That’s not even code grief…

    Two examples that were far worse:

    1. My last company wanted software developers. They offered to send me to code boot camp and give me a promotion. The boot camp was primarily python. I complete and get the promotion. New manager tells me the code base I’ll work on is actually c… Umm ok. New manager retires a week later. I spend a few weeks basically teaching myself c. New manager is assigned. He tells me I should basically assist the senior Dev, ok no problem. Find out the code base is actually c#… Should be doable it’s c based atleast. It’s c# framework 4.8 based on winforns… No one in the building had heard of a unit test…the code was released to production on December of '23. Oh and yeah the senior Dev then announced he was retiring. There are no other c# programmers on the team.

    2. I told this story before recently. On a separate c# code base the “login” function had hard coded credentials in the source, which checked if they existed in a local sql database table with one entry(the hard coded values) and then verified the returned value for “password” was >= than 5. It then logged you in. Didn’t check if the password was correct or even the correct length just that the return of the select statement was greater than or equal to 5 characters… Just for fun remember that false is 5 characters 😂






  • I actually find the opposite is true. I don’t mean it’s bad but you get much better results with some basic starting point.

    For example at my last company we had a database which for a VERY small example had a table with device serial, test type, test result(pass/fail), and an ID to another table. For each test in the other table there was a series of rows with that id which had all the details of test. For example unit 123 might be circuit board with 5 test points testing voltages at various points, all tested at one test station.

    So you would go into table 1, select all lines with serial 123 and test type “electrical test”, copy the test ID, go into table 2 and select all results for that ID.

    One day my boss sent me a list of 500 serials and told me to pull all the details and present it in a table.

    Doing that manually would be hours. So people with some sql knowledge might recognize you could use a sub query. Problem being the list sent to me was just a table copied and sent over teams. Would probably take atleast half an hour to copy that into ssms and correct all the formatting to be valid sql.

    I wrote a script that pulled the details for 1 serial using a sub query and pivot the results , copied that and the list of serials into chatgpt and asked it to modify the query to include all the serials in the table in correct sql format. It worked great( I got results for 500 unique serials and a test of a random 10 of them got the same results). It took maybe 5 minutes.

    Now trying to get chatgpt to do that from scratch would be painful but with some idea of structure of data, an idea of what I wanted to do and an example to follow it worked wonderfully.