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 123»»»

Taking Risks Expand / Collapse
Author
Message
Posted Sunday, October 2, 2011 1:38 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, January 10, 2014 7:20 AM
Points: 175, Visits: 723
Comments posted to this topic are about the item Taking Risks

Brad M. McGehee
Microsoft SQL Server MVP
Director of DBA Education, Red Gate Software
www.bradmcgehee.com
Post #1184212
Posted Sunday, October 2, 2011 2:01 PM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 10:48 AM
Points: 37,075, Visits: 31,631
Ah... sorry, Brad... I have to disagree with you on most of what you said except for "pushing a change to production without testing it first on a test server, should always be avoided".

First, I think that most DBA's that I know (and I know more than a hundred) do take the very risks that you speak of. The only thing they're not (and I'm not) willing to take a risk with is the safety of the data in a production database.

You want to upgrade a production box from 2005 to 2008 R2? Not a problem... build a parallel machine and work out all the bugs and faults first because experience tells me there's no such thing as a "transparent" migration. Then, do full regression testing of the apps because, sure as shootin', someone has embedded code somewhere and it can break during a rev change just like anything else (happend to us just about 3 months ago and our system DBA's had to migrate the data back to 2005.).

If you think all that's a bit cowardly, consider this... you know the risk of jumping out of an airplane with no parachute... so why don't you try it just based on someone's word or in the spirit of taking a risk? Heh... the answer, of course, is that you know better.

Same principle applies here... All good DBA's are secretly born in Missouri... the "Show Me" State.

And, remember... they don't call it the "bleeding edge" for nothing.


--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 #1184215
Posted Monday, October 3, 2011 2:12 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:11 AM
Points: 171, Visits: 444
In terms of personal risk taking/development, I love my motorbike. So the last week I arranged an Enhanced Rider Scheme course for the following day.
Whilst I was REALLY nervous about what I was going to have to do and the new speed of risk assessment that I was going to have to pick up (remembering that not only is this life and death stuff... it's my own!), I thoroughly enjoyed myself and this morning on the way into work I felt a lot safer and cut through the traffic a lot smoother/quicker.

Therefore, I partly agree.
I do however agree that as long as the precautions don't detract from your aim, some risks are acceptable.
Life after all, is a balance of risk vs. benefit and it's up to us to decide the ratio we're happy with.
Post #1184336
Posted Monday, October 3, 2011 2:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 4, 2014 9:03 AM
Points: 1,415, Visits: 796
Try professional gambling for a living - that sure teaches you a thing or two about risk taking.
Post #1184338
Posted Monday, October 3, 2011 5:13 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,106, Visits: 1,334
This coming Saturday i am having my first flying lesson. I have flown before but i have st myself the short term challenge of learning to fly and getting a private license within 18 months. And the then long term goal would be to get and maintain mmy own plain to fly the wife and kids around europe.

I volunteer at a RAF museum and look after the jets and bombers, so the mechanics are nothing new to me but learning to 'drive' them is. Its a natural progression really.

As for 'risk', well i guess there is risk involved but only if im really unlucky and a bit crap!


Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1184424
Posted Monday, October 3, 2011 5:16 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:11 AM
Points: 171, Visits: 444
You lucky thing Adam!
I thought a motorbike was exciting! :P

Have fun
Post #1184427
Posted Monday, October 3, 2011 5:20 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,106, Visits: 1,334
Ben Moorhouse (10/3/2011)
You lucky thing Adam!
I thought a motorbike was exciting! :P

Have fun


Thanks
CANNOT WAIT.
Im also learning from the World, UK, European Micro-Light champion..... He's my instructor. So i think im in safe hands.
When you start looking into ways to 'own' its not as pricey as people think. Not really much more then a small family car.


Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1184429
Posted Monday, October 3, 2011 5:23 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:11 AM
Points: 171, Visits: 444
Wow! Now that I hadn't expected!
Don't you have to pay for the airport etc?
Post #1184431
Posted Monday, October 3, 2011 5:32 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,106, Visits: 1,334
No/ Micro-lights and light aircraft generally operate out of private airstrips or airfields, so all you really pay is hangerage at the airfield where you keep it. Generally speaking, most strips are free to land in (given prior notice).

Its not like with jets and the like that need long runways and facilities. In fact if you go anywhere near a large airport your liable to face heavy fines and police action.


Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #1184436
Posted Monday, October 3, 2011 5:37 AM


SSC-Dedicated

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

Group: General Forum Members
Last Login: Today @ 10:48 AM
Points: 37,075, Visits: 31,631
Ok... you good folks and "risk" takers that have posted so far...

How many of you are actually willing to install a new product (or even "just" a switch from 2k5 to 2k8) on your production boxes without first testing it on a copy of the production or at least a subset-copy of production?

I hope the answer would be "none" but I have a feeling that's not going to be the answer.


--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 #1184438
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse