Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Did I dodge a bullet?

Did I dodge a bullet?

Scheduled Pinned Locked Moved The Lounge
databasequestioncsharpcareer
35 Posts 18 Posters 3 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • C Cezar Lamann

    So, I've been applying to a couple of Tech Lead positions recently. I've been in Software development since 2008, and have worked with .NET since 2011. I went through several codebases throughout the years, and I have seen my fair share of atrocities done in codebases (including a critical software with 13 KLOC inside Program.cs). I believe that at least, nowadays, I know how NOT to screw things up. Recently, I had an interview with a big company in the restaurant management sector (with customers like Burger King and others in the same range). The interviewer asked me what I thought about the usage of Stored Procedures. I told them something along the lines of: "Well, they have their place. There might be situations worth considering their usage, but not always. E.g., Let's say you have a highly complex report that depends on several rounds of aggregations and calculations, and it is time critical, it might be worth considering the usage of Stored Procedures, instead of doing everything on the .NET codebase. Since the database has mechanisms to handle data better (indexes, query plans and whatnot) and it is closer to the data than the application, we could leverage these things to reduce the time needed to produce this specific report". Then, two days later, I got a rejection letter saying that my way of thinking was outdated, and that they do everything inside application code, so they would not move on with my application. So, my question is: Did I dodge a bullet, or did I in fact screw this up? How would you guys reply to this question if you were in my shoes?

    G Offline
    G Offline
    GKP1992
    wrote on last edited by
    #6

    Cezar Lamann wrote:

    Did I dodge a bullet

    Yes. Your response of the use of DB stored procedures being situational was correct, them assuming that you were a proponent of using SPs all the time is their mistake and pretty stupid. There also maybe a person in the team who could've been your peer or worse, superior who do things their way and won't change for whatever reason. Keep miles away.

    1 Reply Last reply
    0
    • H honey the codewitch

      I'm not sure what you/they mean when you wrote "they do everything inside the application code" The reporting? If so, good thing you moved on. Also, it's rare and kind of off putting for an interviewer to say something like "your way of thinking is outdated" It tells me you've got a primadonna infestation in that team. When I interviewed for Expedia, some interviewer asked me to defend my lack of a BS degree. It was at that point that I responded "I just whiteboarded all of your problems, because while you were struggling through English lit to round out your requirements, I was coding, so defend your degree first - after all I didn't pay 80k for mine" I didn't get the job I didn't want at that point anyway.

      Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

      R Offline
      R Offline
      raddevus
      wrote on last edited by
      #7

      honey the codewitch wrote:

      asked me to defend my lack of a BS degree.

      That is entirely stupid line of interviewing. So, interviewer just wants to have an argument about, "Is it necessary to have a college degree?"

      honey the codewitch wrote:

      "I just whiteboarded all of your problems, because while you were struggling through English lit to round out your requirements, I was coding, so defend your degree first - after all I didn't pay 80k for mine"

      :thumbsup: Of course there can be value in a college degree, but there is nothing that 100% proves you'll be a good dev anyways. Maybe they should make their litmus test: Have you read the entire The Art of Computer Programming by Knuth?

      O H 2 Replies Last reply
      0
      • H honey the codewitch

        I'm not sure what you/they mean when you wrote "they do everything inside the application code" The reporting? If so, good thing you moved on. Also, it's rare and kind of off putting for an interviewer to say something like "your way of thinking is outdated" It tells me you've got a primadonna infestation in that team. When I interviewed for Expedia, some interviewer asked me to defend my lack of a BS degree. It was at that point that I responded "I just whiteboarded all of your problems, because while you were struggling through English lit to round out your requirements, I was coding, so defend your degree first - after all I didn't pay 80k for mine" I didn't get the job I didn't want at that point anyway.

        Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

        D Offline
        D Offline
        Dave Kreskowiak
        wrote on last edited by
        #8

        Self-taught? So am I. What is a BS degree anyway? It's a directed learning path, with some discussion, a bunch of lecturing, a lot of book reading, and a little experimentation. That's something we can do entirely on our own without spending $80K on it. Hell, we can even get the same/updated books, keep them to boot, and not spend the kind of money on them the students are getting fleeced for! Of course, we do a lot more work experimenting and learning, but that's the fun part! The only downside is a lack of feedback on our work.

        Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles. Dave Kreskowiak

        1 Reply Last reply
        0
        • C Cezar Lamann

          So, I've been applying to a couple of Tech Lead positions recently. I've been in Software development since 2008, and have worked with .NET since 2011. I went through several codebases throughout the years, and I have seen my fair share of atrocities done in codebases (including a critical software with 13 KLOC inside Program.cs). I believe that at least, nowadays, I know how NOT to screw things up. Recently, I had an interview with a big company in the restaurant management sector (with customers like Burger King and others in the same range). The interviewer asked me what I thought about the usage of Stored Procedures. I told them something along the lines of: "Well, they have their place. There might be situations worth considering their usage, but not always. E.g., Let's say you have a highly complex report that depends on several rounds of aggregations and calculations, and it is time critical, it might be worth considering the usage of Stored Procedures, instead of doing everything on the .NET codebase. Since the database has mechanisms to handle data better (indexes, query plans and whatnot) and it is closer to the data than the application, we could leverage these things to reduce the time needed to produce this specific report". Then, two days later, I got a rejection letter saying that my way of thinking was outdated, and that they do everything inside application code, so they would not move on with my application. So, my question is: Did I dodge a bullet, or did I in fact screw this up? How would you guys reply to this question if you were in my shoes?

          D Offline
          D Offline
          Dave Kreskowiak
          wrote on last edited by
          #9

          Yeah, you dodged a bullet. You even told them why it's better than doing it in-code. It seems they've forgotten why you don't do everything in-code. Their way seems to be a pile of security holes with performance issues. They may also be trying to save money on IT operations by skipping the DBA's required to write and maintain the databases and their SQL code. Congratulations, Neo.

          Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles. Dave Kreskowiak

          D 1 Reply Last reply
          0
          • C Cezar Lamann

            So, I've been applying to a couple of Tech Lead positions recently. I've been in Software development since 2008, and have worked with .NET since 2011. I went through several codebases throughout the years, and I have seen my fair share of atrocities done in codebases (including a critical software with 13 KLOC inside Program.cs). I believe that at least, nowadays, I know how NOT to screw things up. Recently, I had an interview with a big company in the restaurant management sector (with customers like Burger King and others in the same range). The interviewer asked me what I thought about the usage of Stored Procedures. I told them something along the lines of: "Well, they have their place. There might be situations worth considering their usage, but not always. E.g., Let's say you have a highly complex report that depends on several rounds of aggregations and calculations, and it is time critical, it might be worth considering the usage of Stored Procedures, instead of doing everything on the .NET codebase. Since the database has mechanisms to handle data better (indexes, query plans and whatnot) and it is closer to the data than the application, we could leverage these things to reduce the time needed to produce this specific report". Then, two days later, I got a rejection letter saying that my way of thinking was outdated, and that they do everything inside application code, so they would not move on with my application. So, my question is: Did I dodge a bullet, or did I in fact screw this up? How would you guys reply to this question if you were in my shoes?

            P Offline
            P Offline
            PIEBALDconsult
            wrote on last edited by
            #10

            I think you gave the best answer. I also prefer to have the code in the application rather than the database, but I consider the particular situation.

            1 Reply Last reply
            0
            • H honey the codewitch

              I'm not sure what you/they mean when you wrote "they do everything inside the application code" The reporting? If so, good thing you moved on. Also, it's rare and kind of off putting for an interviewer to say something like "your way of thinking is outdated" It tells me you've got a primadonna infestation in that team. When I interviewed for Expedia, some interviewer asked me to defend my lack of a BS degree. It was at that point that I responded "I just whiteboarded all of your problems, because while you were struggling through English lit to round out your requirements, I was coding, so defend your degree first - after all I didn't pay 80k for mine" I didn't get the job I didn't want at that point anyway.

              Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

              C Offline
              C Offline
              charlieg
              wrote on last edited by
              #11

              Any time I hear stuff like this it reminds me of an interview with Scientific Atlanta. At the time I was a pure C coder, dabbled in C++ and I could spell object oriented. This was back in the day when companies spent BILLIONS making sure it was all designed OO and never produced anything. The techies were great, I answered all of their questions, actually debugged a problem that had been plaguing them, but the PM and the architect were two of the most pretentious pricks I ever had the displeasure to meet.

              Charlie Gilley “They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759 Has never been more appropriate.

              1 Reply Last reply
              0
              • H honey the codewitch

                I'm not sure what you/they mean when you wrote "they do everything inside the application code" The reporting? If so, good thing you moved on. Also, it's rare and kind of off putting for an interviewer to say something like "your way of thinking is outdated" It tells me you've got a primadonna infestation in that team. When I interviewed for Expedia, some interviewer asked me to defend my lack of a BS degree. It was at that point that I responded "I just whiteboarded all of your problems, because while you were struggling through English lit to round out your requirements, I was coding, so defend your degree first - after all I didn't pay 80k for mine" I didn't get the job I didn't want at that point anyway.

                Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

                D Offline
                D Offline
                dandy72
                wrote on last edited by
                #12

                honey the codewitch wrote:

                It was at that point that I responded "I just whiteboarded all of your problems, because while you were struggling through English lit to round out your requirements, I was coding, so defend your degree first - after all I didn't pay 80k for mine"

                HA! That's awesome.

                H 1 Reply Last reply
                0
                • C Cezar Lamann

                  So, I've been applying to a couple of Tech Lead positions recently. I've been in Software development since 2008, and have worked with .NET since 2011. I went through several codebases throughout the years, and I have seen my fair share of atrocities done in codebases (including a critical software with 13 KLOC inside Program.cs). I believe that at least, nowadays, I know how NOT to screw things up. Recently, I had an interview with a big company in the restaurant management sector (with customers like Burger King and others in the same range). The interviewer asked me what I thought about the usage of Stored Procedures. I told them something along the lines of: "Well, they have their place. There might be situations worth considering their usage, but not always. E.g., Let's say you have a highly complex report that depends on several rounds of aggregations and calculations, and it is time critical, it might be worth considering the usage of Stored Procedures, instead of doing everything on the .NET codebase. Since the database has mechanisms to handle data better (indexes, query plans and whatnot) and it is closer to the data than the application, we could leverage these things to reduce the time needed to produce this specific report". Then, two days later, I got a rejection letter saying that my way of thinking was outdated, and that they do everything inside application code, so they would not move on with my application. So, my question is: Did I dodge a bullet, or did I in fact screw this up? How would you guys reply to this question if you were in my shoes?

                  J Offline
                  J Offline
                  Jeremy Falcon
                  wrote on last edited by
                  #13

                  There was one thing you said that would've made me worry too, but I suspect you dodged a bullet. Here's the proper answer to that question... To give you context, I've been in this game since the 90s... 94 is when I started coding and 97 I was working as a coder. Anyway, this being the Internet expect less experienced people to disagree with what I'm about to say... ignore them. But, the proper answer to that question is: It depends. :) To start with, no expert DBA will accept a code first answer even if you're using an ORM, etc. Only coders that refuse to learn DBs buy into that. Don't ever buy into code first UNLESS they talk about migrations. Then they're smart. But, you can (and should) do migrations in raw SQL. So, that's not an excuse to not learn DBs or DB design. Otherwise, they're mentally lazy, but I digress. So, it would be nice to know "why" they believe their buzzword nonsense. When to use a sproc (stored procedure) * When you need custom logic to run that's too big for a db function. Say maybe in response to a trigger or you want to scaffold out something, etc. Never put this logic in code. Yes it's slower than code, but now you tightly coupled your DB to your code. Good luck reusing that DB. Not to mention, you may potentially have to transfer large amounts of data over the wire, which I can promise will be slower if you have a decent server not under heavy load. That's it. That's the only reason. People will talk about security, but a view or function will do the same thing. When not to use a sproc (stored procedure) * Don't use a sproc when a DB function would do the job. DB functions are meant to be concise and point driven. * Not for encapsulation/security. That's what a view is for. * Not for complex reporting. I suspect this is what made them potentially not like your answer. Sprocs are slow. Reporting is slow. A performant DB should have separate, flattened, read-only reporting DB for complex operations. Now, all of this is invalidated if we're talking about distributed computing, using NoSQL, etc. Maybe that's their case, but it sounds like they're just following the hype train. This may also be invalidated if we're working with complex graphs in GraphQL. So, this assumes we're speaking of the traditional client/server paradigm. Edit: Take away point!!!! Here's the important thing though, if they were smart enough to know the good reasons to break the mold... they would've mentioned in the interview. If they didn't, they're just probably clowns or ca

                  C 1 Reply Last reply
                  0
                  • D dandy72

                    honey the codewitch wrote:

                    It was at that point that I responded "I just whiteboarded all of your problems, because while you were struggling through English lit to round out your requirements, I was coding, so defend your degree first - after all I didn't pay 80k for mine"

                    HA! That's awesome.

                    H Offline
                    H Offline
                    honey the codewitch
                    wrote on last edited by
                    #14

                    I had a mouth on me in my twenties. :laugh:

                    Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

                    D O C 3 Replies Last reply
                    0
                    • J Jeremy Falcon

                      There was one thing you said that would've made me worry too, but I suspect you dodged a bullet. Here's the proper answer to that question... To give you context, I've been in this game since the 90s... 94 is when I started coding and 97 I was working as a coder. Anyway, this being the Internet expect less experienced people to disagree with what I'm about to say... ignore them. But, the proper answer to that question is: It depends. :) To start with, no expert DBA will accept a code first answer even if you're using an ORM, etc. Only coders that refuse to learn DBs buy into that. Don't ever buy into code first UNLESS they talk about migrations. Then they're smart. But, you can (and should) do migrations in raw SQL. So, that's not an excuse to not learn DBs or DB design. Otherwise, they're mentally lazy, but I digress. So, it would be nice to know "why" they believe their buzzword nonsense. When to use a sproc (stored procedure) * When you need custom logic to run that's too big for a db function. Say maybe in response to a trigger or you want to scaffold out something, etc. Never put this logic in code. Yes it's slower than code, but now you tightly coupled your DB to your code. Good luck reusing that DB. Not to mention, you may potentially have to transfer large amounts of data over the wire, which I can promise will be slower if you have a decent server not under heavy load. That's it. That's the only reason. People will talk about security, but a view or function will do the same thing. When not to use a sproc (stored procedure) * Don't use a sproc when a DB function would do the job. DB functions are meant to be concise and point driven. * Not for encapsulation/security. That's what a view is for. * Not for complex reporting. I suspect this is what made them potentially not like your answer. Sprocs are slow. Reporting is slow. A performant DB should have separate, flattened, read-only reporting DB for complex operations. Now, all of this is invalidated if we're talking about distributed computing, using NoSQL, etc. Maybe that's their case, but it sounds like they're just following the hype train. This may also be invalidated if we're working with complex graphs in GraphQL. So, this assumes we're speaking of the traditional client/server paradigm. Edit: Take away point!!!! Here's the important thing though, if they were smart enough to know the good reasons to break the mold... they would've mentioned in the interview. If they didn't, they're just probably clowns or ca

                      C Offline
                      C Offline
                      Cezar Lamann
                      wrote on last edited by
                      #15

                      I got your point. And the infamous "It depends" is what I really wanted to say (maybe I should have started my answer with this instead of "Well, sprocs have their place". I wouldn't blindly rule out a sproc, without knowing what is in front of me and what I should do, functionality-wise (like your last sentence - "all of this is invalidated if we're talking about distributed computing. This may also be invalidated if we're working with complex graphs in GraphQL"). Of course, I would NOT do, in this day and age, just use the .NET code as a shim for exposing sprocs and have the whole business logic in the DB (yes, I worked in an ASP Classic project, that was like this, and I hated every single second I worked on that project). I have also done my fair share of data warehousing and CQRS, and I understand that for OLAP workloads, a separate DB with denormalized tables/materialized views (e.g. "star schemas") can do wonders. Heck, I even ask this kind of question when I'm on the interviewer side (e.g. for senior dev positions), to filter out the ones that are 100% on Sproc side or 100% on code-only side. In other words, I knew how to answer this. But to get a rejection based on this (maybe other non-disclosed things as you mentioned), has bummed me out.

                      J D 2 Replies Last reply
                      0
                      • H honey the codewitch

                        I had a mouth on me in my twenties. :laugh:

                        Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

                        D Offline
                        D Offline
                        dandy72
                        wrote on last edited by
                        #16

                        That's to be applauded. Who knows where you'd be right now if you had held back and gone with them anyway...

                        1 Reply Last reply
                        0
                        • C Cezar Lamann

                          So, I've been applying to a couple of Tech Lead positions recently. I've been in Software development since 2008, and have worked with .NET since 2011. I went through several codebases throughout the years, and I have seen my fair share of atrocities done in codebases (including a critical software with 13 KLOC inside Program.cs). I believe that at least, nowadays, I know how NOT to screw things up. Recently, I had an interview with a big company in the restaurant management sector (with customers like Burger King and others in the same range). The interviewer asked me what I thought about the usage of Stored Procedures. I told them something along the lines of: "Well, they have their place. There might be situations worth considering their usage, but not always. E.g., Let's say you have a highly complex report that depends on several rounds of aggregations and calculations, and it is time critical, it might be worth considering the usage of Stored Procedures, instead of doing everything on the .NET codebase. Since the database has mechanisms to handle data better (indexes, query plans and whatnot) and it is closer to the data than the application, we could leverage these things to reduce the time needed to produce this specific report". Then, two days later, I got a rejection letter saying that my way of thinking was outdated, and that they do everything inside application code, so they would not move on with my application. So, my question is: Did I dodge a bullet, or did I in fact screw this up? How would you guys reply to this question if you were in my shoes?

                          O Offline
                          O Offline
                          obermd
                          wrote on last edited by
                          #17

                          Your answer showed an excellent understanding of the tradeoffs in software design. The fact that they told you otherwise tells me that you didn't dodge a bullet - you dodged a nuclear weapon.

                          1 Reply Last reply
                          0
                          • H honey the codewitch

                            I had a mouth on me in my twenties. :laugh:

                            Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

                            O Offline
                            O Offline
                            obermd
                            wrote on last edited by
                            #18

                            Good. Don't lose it.

                            1 Reply Last reply
                            0
                            • R raddevus

                              honey the codewitch wrote:

                              asked me to defend my lack of a BS degree.

                              That is entirely stupid line of interviewing. So, interviewer just wants to have an argument about, "Is it necessary to have a college degree?"

                              honey the codewitch wrote:

                              "I just whiteboarded all of your problems, because while you were struggling through English lit to round out your requirements, I was coding, so defend your degree first - after all I didn't pay 80k for mine"

                              :thumbsup: Of course there can be value in a college degree, but there is nothing that 100% proves you'll be a good dev anyways. Maybe they should make their litmus test: Have you read the entire The Art of Computer Programming by Knuth?

                              O Offline
                              O Offline
                              obermd
                              wrote on last edited by
                              #19

                              raddevus wrote:

                              Maybe they should make their litmus test: Have you read the entire The Art of Computer Programming by Knuth?

                              I own and have read all four volumes. Knuth simply isn't that good outside the theoretical arena, using mathematical syntax and making APL look readable. (Yes, I wrote some in APL back in high school.) There are far better books on the same subjects.

                              1 Reply Last reply
                              0
                              • H honey the codewitch

                                I'm not sure what you/they mean when you wrote "they do everything inside the application code" The reporting? If so, good thing you moved on. Also, it's rare and kind of off putting for an interviewer to say something like "your way of thinking is outdated" It tells me you've got a primadonna infestation in that team. When I interviewed for Expedia, some interviewer asked me to defend my lack of a BS degree. It was at that point that I responded "I just whiteboarded all of your problems, because while you were struggling through English lit to round out your requirements, I was coding, so defend your degree first - after all I didn't pay 80k for mine" I didn't get the job I didn't want at that point anyway.

                                Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

                                N Offline
                                N Offline
                                Nelek
                                wrote on last edited by
                                #20

                                Not exactly the same situation, but I had something similar. At the beginning one guy (tech guru of the dept.) was getting really annoying with questions and arguments against me. I just stood up and said: "Up to this point, I do not care if you take me, I don't want to work with such a guy" and left. 2 years later, job was still not occupied... what a surprise!

                                M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

                                H 1 Reply Last reply
                                0
                                • C Cezar Lamann

                                  I got your point. And the infamous "It depends" is what I really wanted to say (maybe I should have started my answer with this instead of "Well, sprocs have their place". I wouldn't blindly rule out a sproc, without knowing what is in front of me and what I should do, functionality-wise (like your last sentence - "all of this is invalidated if we're talking about distributed computing. This may also be invalidated if we're working with complex graphs in GraphQL"). Of course, I would NOT do, in this day and age, just use the .NET code as a shim for exposing sprocs and have the whole business logic in the DB (yes, I worked in an ASP Classic project, that was like this, and I hated every single second I worked on that project). I have also done my fair share of data warehousing and CQRS, and I understand that for OLAP workloads, a separate DB with denormalized tables/materialized views (e.g. "star schemas") can do wonders. Heck, I even ask this kind of question when I'm on the interviewer side (e.g. for senior dev positions), to filter out the ones that are 100% on Sproc side or 100% on code-only side. In other words, I knew how to answer this. But to get a rejection based on this (maybe other non-disclosed things as you mentioned), has bummed me out.

                                  J Offline
                                  J Offline
                                  Jeremy Falcon
                                  wrote on last edited by
                                  #21

                                  Cezar Lamann wrote:

                                  has bummed me out.

                                  Been there, done that. Welcome to life. :laugh: Some people will make knee-jerk choices. Especially if said people don't put much effort into interviews. I've seen a lot of devs just want to Google interview questions a day before and roll with that. No real effort put into it. To some extent, we all do it. Like if you meet a random dude on the street with nasty teeth, your first thought is dude don't brush. You don't always take the time to learn his backstory. And then sometimes people just suck at their jobs. :laugh: Including interviews. Even at companies like AWS. Don't me wrong... Amazon/AWS also has some really, really intelligent senior devs. Even some awesome junior ones. But, on that occasion... :laugh: Or maybe it was a personality clash. Could've been two egos going at it rather than just a chill chat. Who knows. Either way, I hope you get the next one man.

                                  Jeremy Falcon

                                  1 Reply Last reply
                                  0
                                  • N Nelek

                                    Not exactly the same situation, but I had something similar. At the beginning one guy (tech guru of the dept.) was getting really annoying with questions and arguments against me. I just stood up and said: "Up to this point, I do not care if you take me, I don't want to work with such a guy" and left. 2 years later, job was still not occupied... what a surprise!

                                    M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

                                    H Offline
                                    H Offline
                                    honey the codewitch
                                    wrote on last edited by
                                    #22

                                    I know someone that nobody can/will work with. It's not because of their demeanor though they can be a bit abrasive, it's more awkward than egotistical. The reason nobody can work with them is that they developed the entire infrastructure for their websites from the ground up over the course of decades, in PHP and JS. No JQuery, no React, none of that, but all those features - yes- hand rolled. Funny thing that nobody can learn it. "But I documented it thoroughly" "You don't understand: You can't google it. Documentation can't answer arbitrary questions, and you don't have the time to give a course" They and their employer are both too invested. And they're all making good money, but they can't grow their business as a result.

                                    Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

                                    N 1 Reply Last reply
                                    0
                                    • H honey the codewitch

                                      I know someone that nobody can/will work with. It's not because of their demeanor though they can be a bit abrasive, it's more awkward than egotistical. The reason nobody can work with them is that they developed the entire infrastructure for their websites from the ground up over the course of decades, in PHP and JS. No JQuery, no React, none of that, but all those features - yes- hand rolled. Funny thing that nobody can learn it. "But I documented it thoroughly" "You don't understand: You can't google it. Documentation can't answer arbitrary questions, and you don't have the time to give a course" They and their employer are both too invested. And they're all making good money, but they can't grow their business as a result.

                                      Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

                                      N Offline
                                      N Offline
                                      Nelek
                                      wrote on last edited by
                                      #23

                                      honey the codewitch wrote:

                                      And they're all making good money, but they can't grow their business as a result.

                                      What it is more than expected, logical in that case.

                                      M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

                                      H 1 Reply Last reply
                                      0
                                      • N Nelek

                                        honey the codewitch wrote:

                                        And they're all making good money, but they can't grow their business as a result.

                                        What it is more than expected, logical in that case.

                                        M.D.V. ;) If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about? Help me to understand what I'm saying, and I'll explain it better to you Rating helpful answers is nice, but saying thanks can be even nicer.

                                        H Offline
                                        H Offline
                                        honey the codewitch
                                        wrote on last edited by
                                        #24

                                        They could bring on other people if they updated their tech stack to use modern, off the shelf tools. I don't think the person I'm talking about is willing to work that way though. NIH in the extreme. When I worked with them, I did discuss this with them, but didn't get very far. To my credit, they said I was the one dev that they found they'd be willing to work with again. But I can't do it, for my sanity. And I wasn't able to deliver at the rate that I usually can because I was constantly tripping over what I didn't know about their system. It's kind of unfortunate too. I actually went to high school with them, and they found out through the grapevine that I was in the field, so they contacted me through a mutual friend. I liked working with them, but I just couldn't be effective to the degree *I* was satisfied with using their tools.

                                        Check out my IoT graphics library here: https://honeythecodewitch.com/gfx And my IoT UI/User Experience library here: https://honeythecodewitch.com/uix

                                        N 1 Reply Last reply
                                        0
                                        • C Cezar Lamann

                                          So, I've been applying to a couple of Tech Lead positions recently. I've been in Software development since 2008, and have worked with .NET since 2011. I went through several codebases throughout the years, and I have seen my fair share of atrocities done in codebases (including a critical software with 13 KLOC inside Program.cs). I believe that at least, nowadays, I know how NOT to screw things up. Recently, I had an interview with a big company in the restaurant management sector (with customers like Burger King and others in the same range). The interviewer asked me what I thought about the usage of Stored Procedures. I told them something along the lines of: "Well, they have their place. There might be situations worth considering their usage, but not always. E.g., Let's say you have a highly complex report that depends on several rounds of aggregations and calculations, and it is time critical, it might be worth considering the usage of Stored Procedures, instead of doing everything on the .NET codebase. Since the database has mechanisms to handle data better (indexes, query plans and whatnot) and it is closer to the data than the application, we could leverage these things to reduce the time needed to produce this specific report". Then, two days later, I got a rejection letter saying that my way of thinking was outdated, and that they do everything inside application code, so they would not move on with my application. So, my question is: Did I dodge a bullet, or did I in fact screw this up? How would you guys reply to this question if you were in my shoes?

                                          K Offline
                                          K Offline
                                          kmoorevs
                                          wrote on last edited by
                                          #25

                                          I recently vented here regarding an issue of SPs vs. code-behind. You are correct, each has pros and cons and the choice depends on the situation. Calling SPs outdated is BS. You dodged a bullet.

                                          "Go forth into the source" - Neal Morse "Hope is contagious"

                                          1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups