Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Getting It Right First Time. Almost? Expand / Collapse
Author
Message
Posted Monday, August 4, 2014 10:30 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:56 AM
Points: 2,406, Visits: 1,000
Comments posted to this topic are about the item Getting It Right First Time. Almost?

SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1599465
Posted Tuesday, August 5, 2014 3:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:48 PM
Points: 5,574, Visits: 3,420
Code reviews are essential. I am not stipulating the amount of code reviewed or the frequency but I have found that a team that employs code reviews encourages everyone to review their code before checking in (OK, I admit it: I am coming at this from a developers perspective). Having said that I believe that reviewing anything that can be reviewed is applicable.

As for code reviews, I am always the slowest person from when then code is development completed to checked in. The reason? I review each and every file change before check in. The downside is that I have to start to complete my tasks before most others. The upside is that I have less check in issues such as debugging code, missing implementation with comment to complete or file added to project files but not to source control.

I may have called it something else but in principle, yes, Check & Test!!!


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1599543
Posted Tuesday, August 5, 2014 4:13 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:56 AM
Points: 2,406, Visits: 1,000
Possibly for many Devs/DBAs/etc the phrase "Test & Check-In" is more apt (ie Source/Version Control).

Gary Varga (8/5/2014)
I review each and every file change before check in.


You'd be surprised (or maybe not) at how many IT companies don't bother with this procedure. And yet they wonder why mistakes happen.

qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1599550
Posted Tuesday, August 5, 2014 5:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:48 PM
Points: 5,574, Visits: 3,420
quackhandle1975 (8/5/2014)
Possibly for many Devs/DBAs/etc the phrase "Test & Check-In" is more apt (ie Source/Version Control).

Gary Varga (8/5/2014)
I review each and every file change before check in.


You'd be surprised (or maybe not) at how many IT companies don't bother with this procedure. And yet they wonder why mistakes happen.

qh


Most developers I have worked with (including good ones and DB Devs - good or otherwise) complete their testing then check in ANY CHANGES without reviewing what they have done. People who do this should be made to maintain their own code for two years after release alongside developers who say "I don't need to comment my code because I named everything well and used simple well named methods so it is all obvious".


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1599610
Posted Tuesday, August 5, 2014 6:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 6:00 AM
Points: 138, Visits: 254
On a slightly different note, I wonder how much fiscal "constraints" play into this. Think of rather small businesses who are unable (or probably more correctly unwilling) to procure adequate infrastructure to support truly good testing and QA.

I can imagine managers and directors saying, "What? You want another SQL Server license just for testing?"

Yes, it's a matter of "how can you afford not to" and the advent of better hardware and VMs has made this less of an excuse, but management and the bean counters don't always see that. They tend to have a bit of bottom line tunnel vision.


____________
Just my $0.02 from over here in the cheap seats of the peanut gallery - please adjust for inflation and/or your local currency.
Post #1599651
Posted Tuesday, August 5, 2014 7:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 2:37 PM
Points: 1, Visits: 61
This is a great policy. If you can stand up an exact duplicate of your environment then you can really get a good idea of what will happen. However the financial constraints typically trump a good test environment. In that case, perfection is expected and the business side doesn't understand why mistakes happen. Most people typically learn this only after they have made one of those big career changing mistakes.
Post #1599676
Posted Tuesday, August 5, 2014 7:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:48 PM
Points: 5,574, Visits: 3,420
lshanahan (8/5/2014)
...I can imagine managers and directors saying, "What? You want another SQL Server license just for testing?"
...


Sometimes Express editions can be useful for functional testing. Obviously, this is not the solution for performance testing.


Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Post #1599686
Posted Tuesday, August 5, 2014 7:16 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:56 AM
Points: 2,406, Visits: 1,000
lshanahan (8/5/2014)
I can imagine managers and directors saying, "What? You want another SQL Server license just for testing?"


Yep, been there many times. Thankfully there are Eval/Developer/Express editions.


qh


SQL 2K acts like a spoilt child - you need to coax it round with lollipops.
Post #1599688
Posted Tuesday, August 5, 2014 5:05 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 7:42 PM
Points: 635, Visits: 2,215
lshanahan (8/5/2014)
I can imagine managers and directors saying, "What? You want another SQL Server license just for testing?"

I've always have gotten the reading from our legal staff that setting up a server for dev or testing was considered legal and free as far as licensing is concerned. But it has to be in a separate domain.

Have they all been wrong?




----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
Post #1599988
Posted Tuesday, August 5, 2014 10:13 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:03 PM
Points: 35,347, Visits: 31,884
Jim P. (8/5/2014)
lshanahan (8/5/2014)
I can imagine managers and directors saying, "What? You want another SQL Server license just for testing?"

I've always have gotten the reading from our legal staff that setting up a server for dev or testing was considered legal and free as far as licensing is concerned. But it has to be in a separate domain.

Have they all been wrong?


From my understanding, it's not actually free. It should be the Developer's Edition and each chair should have a license for it. In quantity, they can be as low as 30 bucks from a good MS authorized dealer.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1600025
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse