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


The myth of the ‘shared development model’


The myth of the ‘shared development model’

Author
Message
Phil Factor
Phil Factor
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4936 Visits: 3031
Comments posted to this topic are about the item The myth of the ‘shared development model’


Best wishes,

Phil Factor
Simple Talk
Gary Varga
Gary Varga
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27540 Visits: 6552
Development environments should be as simple as you can get away with but not simpler (to deliberately misquote Einstein).

All code should be under source control at any point it is released (even internally), to be worked on by multiple team members (under any guise) or passed on between team members. Other restrictions due to local best practices may apply.

That is my opinion. Others will have differing ones from their different experiences, environments and requirements.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
call.copse
call.copse
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: 5672 Visits: 2011
I think even those simple requirements would tax many shops to be fair Gary. I think it's a reasonable summary of minimum requirements - I don't think it's sensible to say there is anything too much you should definitely do - circumstances are all different.

I think it interesting to hear Mr Factor has never reverted SQL code during active development - I was trying to think of when I have done so, and failed. What I have more often used SQL Source Control for is a) checking changes made by other team members b) reviewing what the code was doing at some point in history and why it has been changed to what it does now. Both of these are incredibly useful but not exactly the primary purpose of source control as I originally thought of it, as a developer.
Gary Varga
Gary Varga
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27540 Visits: 6552
call.copse (7/2/2014)
I think even those simple requirements would tax many shops to be fair Gary. I think it's a reasonable summary of minimum requirements - I don't think it's sensible to say there is anything too much you should definitely do - circumstances are all different.

I think it interesting to hear Mr Factor has never reverted SQL code during active development - I was trying to think of when I have done so, and failed. What I have more often used SQL Source Control for is a) checking changes made by other team members b) reviewing what the code was doing at some point in history and why it has been changed to what it does now. Both of these are incredibly useful but not exactly the primary purpose of source control as I originally thought of it, as a developer.


In my opinion, the minimum requirements should not be too taxing for any professional software developer (including database developer) to achieve. Of course, source control could be achieved by saving it to a network location as specified in the editorial. However, I maintain my stance that this is the minimum.

Everyone is entitled to disagree. My opinion is just that: my opinion.

:-)

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Andrew Peterson
Andrew Peterson
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1551 Visits: 734
Wow, I'm just amazed that this is such a sensitive topic. As the others have said, each organization has its own approach. As long as it works. But it must work, if not then its time to improve.

The more you are prepared, the less you need it.
Gary Varga
Gary Varga
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27540 Visits: 6552
Friendly, passionate debate but with mutual respect. I am quite happy to disagree and be disagreed with. Where is the value of debate if there isn't point and counterpoint?

Right, ladies and gentlemen?

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
call.copse
call.copse
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: 5672 Visits: 2011
Sorry folks - wasn't trying to be contentious - just reflecting on the poor state of some shops I've encountered. I was pretty much agreeing with you Gary.
Gary Varga
Gary Varga
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27540 Visits: 6552
call.copse (7/4/2014)
Sorry folks - wasn't trying to be contentious - just reflecting on the poor state of some shops I've encountered. I was pretty much agreeing with you Gary.


No worries. It's all just healthy debate :-)

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Tom Wilson
Tom Wilson
SSC Journeyman
SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)SSC Journeyman (96 reputation)

Group: General Forum Members
Points: 96 Visits: 162
Regarding the "central/shared" database: We have scripts that do the nightly build process, and do a database install to a shared server, with the extra twist that the build number is part of the database name (as suffix). This central database can be used by a developer who doesn't want/need to install each build locally every day. We don't view the central install as "inviolate", they get thrown away after a while; but they let a developer compare a query on their environment versus "how did it work in the build yesterday/week ago/etc."
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