Tomorrow is DBA day, and .Net rocks is back on my mind

My blog has moved.
You can view this post at the following address:
http://www.osherove.com/blog/2004/8/23/tomorrow-is-dba-day-and-net-rocks-is-back-on-my-mind.html
Published Tuesday, August 24, 2004 1:00 AM by RoyOsherove
Filed under:

Comments

Monday, August 23, 2004 9:28 PM by JosephCooney

# re: Tomorrow is DBA day, and .Net rocks is back on my mind

Good luck Roy. It's great to go into something like that with a positive attitude, but try to get the WHY out of him/her so you can evaluate their reasoning for yourself. You seem like a very conscienscious developer, so just because somebody is a DBA doesn't necessarily mean they know database design any better than you. Some of the professional DBAs I've met are great at backing up and restoring databases and managing database servers, but don't have a great deal of experience in database design. What you learn would make a great follow-up post.
Tuesday, August 24, 2004 1:13 AM by Yaniv Harpaz

# re: Tomorrow is DBA day, and .Net rocks is back on my mind

I agree with Joseph.
I'm a DBA (Oracle, but it doesn't matter for this post issue). I think it takes quite a bit of time to understand the things you can achieve from a review with a DBA.

a DBA besides the system / recovery issues has a lot of knowledge regarding performance and integrity. This knowledge is very helpful, but one must know that as brilliant as that DBA might be, he cannot truly look at the BIG picture on your system. You should know best what are the things you want to put inside your DB and especially how to retrieve it in the most efficient way.

a DBA can contribute tips, maybe some design flaws he encountered... but the WHY Joseph inssisted on is a great tip.
Tuesday, August 24, 2004 1:18 AM by Yaniv Harpaz

# Please listen to some REAL music man...

I must comment on the CD player item - listening to people talk is not the reason why the CD player was put inside your car. I'm sure there is a great music artist / band that would make your car (camel :) ) travel much more joyful.

I would like to extend that and say the it might be a great post item - people revealing which kind of music helps them working better (not just coding the smart assertion, but finding the music that would <b>inspire</b> you to do it.
Tuesday, August 24, 2004 11:10 AM by James Steele

# re: Tomorrow is DBA day, and .Net rocks is back on my mind

"No one likes to be self spanked " Too funny Roy. That one liner made my day.
Tuesday, August 24, 2004 12:58 PM by Yaniv Harpaz

# re: Tomorrow is DBA day, and .Net rocks is back on my mind

Well James, I had a feeling somebody took care of this issue, I just didn't know exactly where. "Rush" seems to be quite popular, I might try a few others from the detailed list. Thanx !
Tuesday, August 24, 2004 1:24 PM by Scott Allen

# re: Tomorrow is DBA day, and .Net rocks is back on my mind

Yaniv: I've been listening to .NET rocks, Dr. Dobb's Technetcasts, and audio books in the car for years now. I save music for when I get to my desk :)
Tuesday, August 24, 2004 4:56 PM by Anatoly Lubarsky

# re: Tomorrow is DBA day, and .Net rocks is back on my mind

Good luck, Roy.


At least your database queries are in the stored procedures I hope.
So you can start from there. Database design, performance tuning
t-sql optimizations and other interesting things :)
Wednesday, September 1, 2004 3:47 AM by Ricardo

# re: Tomorrow is DBA day, and .Net rocks is back on my mind

Hey Roy,

Are you going to post any lessons (if any) learned from the hours spent with the DBA ?