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


An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper


An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Author
Message
Harveysburger
Harveysburger
SSC Veteran
SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)SSC Veteran (268 reputation)

Group: General Forum Members
Points: 268 Visits: 430
Thumbs up from Curaçao
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)

Group: General Forum Members
Points: 116834 Visits: 41433
Anipaul (9/20/2011)
Great Jeff Great Talk!!! Thanks for all the help you provided to all of us!!!

We should also thank Rich Bay and your boss :-) for the "accident", otherwise we may miss this great SQL UMBRELLA named Jeff Moden....


Thanks for the great feedback, Anipaul. The article on my interview has actually been cut back quite a bit... It's actually Rich Bay that I have to thank for my primordial anti-RBAR sentiment.

During the week that Rich was on-site and acting as an SQL Mentor to me when he had the time, I ran into a bit of a problem in SQL and originally resorted to trying to solve the problem with RBAR. Now, Rich had assigned chapters for me to study in the books we bought for my education on SQL Server. I didn't realize it at the time, but he'd intentionally left out the chapters on loops and cursors. Rich is a mild mannered gentleman, but when I asked Rich how I would assign a variable a value from a row so I could loop through the rows, he almost snarled while saying "For that you'd need a cursor... and if you ever write one for something like this, I'm all done teaching you."

Let's just say that particular lesson stuck like glue. :-)

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)

Group: General Forum Members
Points: 116834 Visits: 41433
sharath.chalamgari (9/21/2011)
Congrats Jeff, this will be really inspirational for other sql folks.


Thanks, Sharath. I really do hope this helps inspire others especially when it comes to sharing knowledge. I try to help because the "teacher" in me gets a great thrill to watch someone's "light" come on. What I didn't realize when I first started sharing info is how much good info comes back to you... there's always someone with a nifty trick that you might not have thought of. The "Tally Oh" and "Replace Multiple Spaces" articles are prime examples of where just such a thing happened. Just several hours after each article came out, someone either made an improvement that I'd not thought of or came up with an alternate method that was even better than the one I wrote about.

The old saying is "Nothing ventured, nothing gained." Believe it. Help others and you'll be amazed at how much knowledge people will share in return.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)

Group: General Forum Members
Points: 116834 Visits: 41433
opc.three (9/21/2011)
Congratulations Jeff, and Thank You for all you do :-)


Thanks, Orlando. I've not forgotten the pair of articles you and I want to write together. It's going to be a whole lot of fun writing them. Now that SQLSaturday #84 has come and gone, I'm finishing up a couple of things I need to get done and then I'll start writing my half. I'll definitely be in touch.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)

Group: General Forum Members
Points: 116834 Visits: 41433
sql_lock (9/21/2011)
Simply, well deserved!!!


Thank you for the feedback. I aim to please. I sometimes miss, but I'm always aiming. :-)

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)

Group: General Forum Members
Points: 116834 Visits: 41433
Jim Murphy (9/21/2011)
Congratulations Jeff! Well deserved. Really.

I look forward to meeting you at The Summit in a few weeks!

I especially appreciate your spirit of giving. Let me tell you, as a full time consultant, many of my peers and companions are 'takers', always looking for a way to keep what they know to themselves to keep money coming in. The job security argument. I CAN'T STAND THAT! Teaching is giving and when done with a giving attitude (rather than a taking [of glory] attitude, it is a beautiful thing.

Please, keep it up as I know you will... Because you can't help it. You ARE a giver, not a taker in disguise.

Thanks for all of your help around here.


You've absolutely hit the nail on the head on the job security thing, Jim. And those poor people being so stingy with information just don't know what they're actually doing to themselves especially in the money department. I can't speak for anyone else, of course, but I've found that the information-stingy contractors are actually the ones that work themselves out of a job because word gets around that they are, in fact, stingy. The ones that are willing share information and take a bit of time to teach a couple of things to site personel are the ones who are perceived to be trustworthy, honest, helpful and a couple of other Boy Scout terms and are invited back for repeat business. And that kind of information gets around... so does the information about being stingy.

I definitely look forward to meeting you at PASS and, hopefully, at the SQLServerCentral party on Tuesday night.

And thank you for the very kind words both here and in other threads. I don't "teach" expecting to hear such things in return, but they sure are a joy. Thanks, Jim.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)

Group: General Forum Members
Points: 116834 Visits: 41433
Chris Harshman (9/21/2011)
I'd just like to say how glad I am that Jeff is a part of the SQL Server community, and say thanks for all I've learned from his writings. He's such an inspiration! Wow


Gosh, Chris... thanks for the nice thoughts. I'm glad I could help.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)

Group: General Forum Members
Points: 116834 Visits: 41433
Evil Kraig F (9/21/2011)
*claps* Rock on ya old whitebeard! Us younguns are still learnin' every day from ya! :-D


Heh... I'm really only 23! Guess I'm going to have to fire my stunt double or at least get him to shave (no chance in that, by the way) and suck in that gut! :-P

What a tremendous community we have here. Old teaches young. Young teaches old. Thanks for the great posts you've put out there, Craig.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)

Group: General Forum Members
Points: 116834 Visits: 41433
Roy Ernest (9/21/2011)
Evil Kraig F (9/21/2011)
*claps* Rock on ya old whitebeard! Us younguns are still learnin' every day from ya! :-D

You a youngun? Hehe
Great job Jeff.. Looking forward to meet you at the Summit. We will meet on Monday evening at the Lowells. :-)


Now THAT sounds like a plan, Roy! I'm definitely looking forward to it! :-)

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)SSC Guru (116K reputation)

Group: General Forum Members
Points: 116834 Visits: 41433
ken.trock (9/21/2011)
Jeff, congratulations on the award. I know everytime I need a solution to a database programming problem my well trained programmer brain wants to construct a loop. Then I think about you and your teachings keeping us out of RBAR!

Ken


Thanks, Ken. Going back and forth between the procedural and declarative paradigms is one of the toughest things there is to do especially when someone like yourself is really good on the procedural side of the world. Glad to see that folks are mastering the shift between the two. Thanks for letting me be a part of all that.

--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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
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