SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Fix v. Create


Fix v. Create

Author
Message
Michael Valentine Jones
Michael Valentine Jones
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5728 Visits: 11771
I think most maintenance is actually new development activity that was skipped during initial development because the developer was in a hurry, under pressure, incompetent, lazy, etc.

In particular, design review and detailed testing are often skipped, so the problems don't emerge until the application is in production.

It’s far more time-consuming to fix a bug that's in production and design errors, especially database design errors, can take a tremendous effort to fix, so that leads to the 90/10 maintenance/new split.
j_e_o
j_e_o
SSC Veteran
SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)

Group: General Forum Members
Points: 226 Visits: 351
We just completed an Agile project that overall took about 18 months. We had maybe a couple dozen bugs during that time (some of those were really changes in requirements). Test driven development (unit test first!) coupled with automated subsystem testing really keeps the bugs down.

The effort was not trivial and was a true multitier application.

This project had 4 SCRUM teams spread across two continents and three time zones.

The breakdown was roughly 90% on new code and 10% fixing issues.
Carrie.Sim
Carrie.Sim
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 141
Software development for me is an art. It needs experience architect with hand-on and practical experience to design an efficient database access. But, most of the time, a lot of peoples started with coding directly, because he/she not able to think ahead,plan or imagine the scope in future.

Sometime/most of the time, the scope of the system and requirements also changing from time to time. Beside we have very experience Business System Analyst.

Therefore, why we need to spend more time in maintenence, it boiled down lack of experience and critical thinking leader, architect, system analyst.
MSorteberg
MSorteberg
SSC-Enthusiastic
SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)

Group: General Forum Members
Points: 168 Visits: 84
As a Business Intelligence developer I could be working in any of 4 environments, i.e. SSIS, SSAS, SSRS or Dashboards. In my case I am primarily on the latter three so a vast majority of my time is creation. Every once and a while I might be asked to help out on the SSIS side of things but that, as I said is rare. So, I spend probably 90% of my time creating and 10% "fixing". And, sometimes, as a report goes through different iterations - I am asked to make changes/improvements to that report - so the "creating" and "fixing" sometimes gets mingled together. Now, the other members of my team that work primarily in the SSIS area of our business. They are probably just the opposite. They are constantly/often "fixing" problems with data or the flow in one way or another - and doing little creation. I'd say they are doing about 80% "fixing" and 20% "creating".
nelsonj-902869
nelsonj-902869
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2828 Visits: 778
A good Friday topic.

In my current 'Apps team' position, I not only provide SQL support for 8 hardware servers, 8 VM servers and the major applications that may reside on them, but I also support Crystal Reports (Business Objects Enterprise), Access 03/07/10 and a tiny bit of VB.net on Vis Studio 2008.

Fortunately, the SQL side of tasks is mainly server support, maintaining backups, SQL Agent jobs, etc which is an ongoing every morning 15 to 45 minute review. I handle all upgrades for the apps that reside on my servers (maintenance or development?) and have had a big one (not a critical one) going on for about 6 months that because it isn't critical, always seems to get pushed to the back burner when something else jumps up as a perceived crisis.

Then there are the frantic calls from Crystal or Access users asking for assistance with a new/old report or getting a query to do this. Finally there are the VB.net projects that I get to chose, as we have old legacy VB6 code that needs to be updated. I would consider this to be new development work as I'm discovering that VB6 code DOES NOT automatically translate over to VB.Net...much to my chagrin. What fun! I'd say my load is 95/5 on the maintenance/repair/fix this side of the coin.w00t
Question Guy
Question Guy
SSC-Enthusiastic
SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)SSC-Enthusiastic (170 reputation)

Group: General Forum Members
Points: 170 Visits: 763
I've been programming for over 10 years...and now I have finally seen it all...I just inhereted an application that was apporved(and in use) for production(developed by a vendor)...one problem...on some of the reports, the values are hard coded, and don't actually show the real values...why...because the real values are not actually saved to the database.....
FAIL.
But like I always say.... HERE I COME TO SAVE THE DAY!!!!!!!!!!!!!!!!!!!!!!!!!!
Michael Valentine Jones
Michael Valentine Jones
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5728 Visits: 11771
Question Guy (8/24/2012)
...on some of the reports, the values are hard coded, and don't actually show the real values...why...because the real values are not actually saved to the database...


I'll bet that saved a lot of time during development.
GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23425 Visits: 9730
I'd add one more category to that: Prevent.

I spend a significant amount of my time making it so I won't have to fix things in the future.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
F. Dwarf
F. Dwarf
Old Hand
Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)Old Hand (301 reputation)

Group: General Forum Members
Points: 301 Visits: 576
In my current job I went from a 90%/10% fix/mantain ratio to 5%/95%

I consider myself good at troubleshooting and tuning, those are the parts of my job that I enjoy the most. The problem is that the better I do those two, the less I have to work and I tend ot get bored and look for another job that would keep me busy. That has not happened with my current employer though.

I see myself as a problem solver, and I think I do a pretty bad job at creating new stuff (from design to code and test).
Rod
Rod
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2744 Visits: 2059
For me, it is overwhelmingly in favor of "Fix".

Kindest Regards,Rod
Connect with me on LinkedIn.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search